Free Microsoft Outlook Resources & Whitepapers

Create macro in Outlook to send message to OneNote

I have emails coming in to Outlook 2007, using rules to put them in
appropriate folders. There are a couple of folders, though, where I would
like it to move the email in when received AND automatically send it to
OneNote 2007. A macro would be helpful here, connected to the rules, but
there is not a "Record Macro" command to get me started. Any suggestions?


Post your answer or comment

comments powered by Disqus
when travelling I use my gmail account in Outlook to send messages and not my home provider (different email address). I have not reconfigured Outlook to send out of my home account. Outlook successfully sends the message on my gmail account but then tries to send the message from my home provider account and I get an error message. My gmail account has been set as the default account. I send one message but the dialogue box shows sending 2 of 2. Issue new in past few weeks.

Have two PC's. IE works fine accessing the Net. However, I can not get
either of the PC's Outlooks to send/receive. I can process email via Yahoo,
etc. .... but not Outlooks. Can you please coach me on what I must do in
Outlook to send and receive? Thank you

Can end users create macros in Outlook 2007?
--
Linda in Honolulu

Can end users create macros in Outlook 2007?
--
Linda in Honolulu

I'm sure this question has been asked many times but the more I search, the more confused I get. I have created macros some years ago when I had more brain cells working, but for the life of me I can't get this to work...................

I'm trying to insert a macro in Outlook 2003 to warn me if I inadvertently try to send an email with no subject line.

I found this code:
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
strSubject = Item.Subject
If Len(Trim(strSubject)) = 0 Then
Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"
If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then
Cancel = True
End If
End If
End Sub
and have been trying to insert it in Outlook. I open the VBA editor and can see the code in "ThisOutlookSession" in a window headed VbaProject.OTM - ThisOutlookSession (Code) but, when I click on Tools/Macro/Macros, nothing is visible nor is there any warning when sending mails without subject.

I'm sure I'm doing something immeasurably stupid but would be greatful for being pointed in the right direction.

I'm running Office 2003 on W7 Home Premium x64 with all updates in place.

Can anyone tell me how to create a macro in Outlook 2007? I am trying to
create a command for folders but cannot find how to. Many thanks

The site
http://turtleflock-ol2007.spaces.liv...E3D8!579.entry
gives a nice clear description of how to create a macro in Outlook 2007. What
I tried is:

Sub Blue()
Dim objDoc As Word.Document
Dim objSelection As Word.Selection
On Error Resume Next
Set objDoc = Application.ActiveInspector.WordEditor
Set objSelection = objDoc.Windows(1).Selection
objSelection.Font.Color = wdColorBlue
Set objSelection = Nothing
Set objDoc = Nothing
End Sub

Unfortunately, this does not work. I am using Outlook 2007, and have the
latest updates (12.0.6504.5000) SP2 MSO (12.0.6425.1000) ... am running
WinXP, Service Pack 3.

The site
http://turtleflock-ol2007.spaces.live.com/blog/cns!C1013F1F9 A99E3D8!579.entry
gives a nice clear description of how to create a macro in Outlook 2007.
What I tried is:

Sub Blue()
Dim objDoc As Word.Document
Dim objSelection As Word.Selection
On Error Resume Next
Set objDoc = Application.ActiveInspector.WordEditor
Set objSelection = objDoc.Windows(1).Selection
objSelection.Font.Color = wdColorBlue
Set objSelection = Nothing
Set objDoc = Nothing
End Sub

Unfortunately, this does not work. I am using Outlook 2007, and have the
latest updates (12.0.6504.5000) SP2 MSO (12.0.6425.1000) ... am running
WinXP, Service Pack 3.

I am sort of use to creating macros in Word and having our IT Department
place them on my department's separate systems. Would this work for Outlook
macros? Thank you.

The site
http://turtleflock-ol2007.spaces.liv...E3D8!579.entry
gives a nice clear description of how to create a macro in Outlook 2007.
What I tried is:

Sub Blue()
Dim objDoc As Word.Document
Dim objSelection As Word.Selection
On Error Resume Next
Set objDoc = Application.ActiveInspector.WordEditor
Set objSelection = objDoc.Windows(1).Selection
objSelection.Font.Color = wdColorBlue
Set objSelection = Nothing
Set objDoc = Nothing
End Sub

Unfortunately, this does not work. I am using Outlook 2007, and have the
latest updates (12.0.6504.5000) SP2 MSO (12.0.6425.1000) ... am running
WinXP, Service Pack 3.

I am sort of use to creating macros in Word and having our IT Department
place them on my department's separate systems. Would this work for Outlook
macros? Thank you.

The site
http://turtleflock-ol2007.spaces.liv...E3D8!579.entry
gives a nice clear description of how to create a macro in Outlook 2007. What
I tried is:

Sub Blue()
Dim objDoc As Word.Document
Dim objSelection As Word.Selection
On Error Resume Next
Set objDoc = Application.ActiveInspector.WordEditor
Set objSelection = objDoc.Windows(1).Selection
objSelection.Font.Color = wdColorBlue
Set objSelection = Nothing
Set objDoc = Nothing
End Sub

Unfortunately, this does not work. I am using Outlook 2007, and have the
latest updates (12.0.6504.5000) SP2 MSO (12.0.6425.1000) ... am running
WinXP, Service Pack 3.

How can I set up Email Accounts in outlook to get messages from Windows
Messenger (MICROSOFT EXC SERVER, POP3 IMAP HTTP ) which one to use and any
particular settings? says sending service is currently uaavailable and to try
later AND

I use to be able to right click on a contact and select "send message to
contact". I am un able to get any thing when I right click now. How do I
get this function back?

Hi I have been trying to set up outlook to send messages but keep getting
'failed' error messages and then a note that the pop.mail.server is
incorrect. can someone help plz

In Outlook 2003 I was able to use a macro I had created in Word to insert the
day, date, and time at the beginning of a new email. Outlook 2007 has no
"macro-record" function and my attempt to import a similar macro I created in
Word 2007 has failed ... when I run it, it results in an error message and I
have no clue how to debug. Any counsel?

I have a user that is only able to send messages in Unicode when in Outlook
Web Access. I cannot find any setting that controls this. All other users
are fine. He is the only Mac user that uses OWA in a Mac.

Please help.

Richard C. Goodlett - Information Technologies Manager
Urban Design Group, Inc.
15950 North Dallas Parkway, Suite 325
Dallas, Texas 75248-6615
972 788-9242
972 788-9234 Fax
rgoodlett@urbandesigngroup.com

I have never created a macro and know nowthing about VBA. I am trying to
outomate several tasks in Outlook relating to implementing David Allen's
"Getting Things Done" methodology.

Can you recommend a resource for me that will teach me about VBA and how to
write macros for Outlook?

Thanks,
Mike

I had a macro in Outlook XP that entered a certain amount of text and
formatted it. We use it in most of our emails and immediately run it when
creating a new email. It worked fine. (For what it is worth, I copied it
into a Word 2007 macro and it worked fine there also).

I cannot figure out to create this macro in Outlook 2007. I went to trust
center and enabled all macros with no security at all.

I went to Tools, Macros, Visual Basic Editor. In the top left box I created
a new module and pasted in the text of the macro. But now I cannot figure
out how to run it in a new email. In a newly created macro there is no tool
option to call up a macro.

I try to run it within the visual basic editor, but I get an error message
that says macros in this project are disabled and refers me to online help
for how to enable macros.

How do I create a macro that I can run upon opening a new email that is to
be sent?

If it matters at all, the text in the macro is:
Sub EmailProtocol()
'
' EmailProtocol Macro
' Macro recorded 8/22/2006 by Gisele Prive
'
Selection.InsertDateTime DateTimeFormat:="d-MMM-yy",
InsertAsField:=False, _
DateLanguage:=wdEnglishUS, CalendarType:=wdCalendarWestern, _
InsertAsFullWidth:=False
Selection.TypeText Text:=" "
Selection.InsertDateTime DateTimeFormat:="HH:mm", InsertAsField:=False, _
DateLanguage:=wdEnglishUS, CalendarType:=wdCalendarWestern, _
InsertAsFullWidth:=False
Selection.TypeText Text:=" PST "
Selection.MoveLeft Unit:=wdCharacter, Count:=2
Selection.MoveLeft Unit:=wdCharacter, Count:=9, Extend:=wdExtend
Selection.Font.Bold = wdToggle
Selection.EndKey Unit:=wdLine
Selection.TypeText Text:="-- Folder"
Selection.TypeParagraph
Selection.TypeParagraph
Selection.TypeText Text:="Message Subject "
Selection.MoveUp Unit:=wdLine, Count:=2
Selection.MoveRight Unit:=wdWord, Count:=2
End Sub

I have 2 separate, but possibly related problems:

1. Outlook (2007) is trying to send messages although none are in the
Outbox. I've read this happened in 2003 as well, but was fixed either
by applying a 2003 service pack or running the inbox repair tool. I
ran scanpst.exe and it found errors, says it repaired them, but I
still have the problem.

2. In my Outlook I have Exchange setup via HTTP as well as a PST file
for the POP accounts. When I try to send via my POP accounts that
should use the PST outbox, they end up in the Exchange server Outbox.
The accounts are set to use the PST file, so not sure why this is
happening. One of the POP accounts still sends successfully (with the
resulting "Sent Item" ending up back in the PST's "Sent Items"), but
another one gets an error saying it can't find the SMTP, but my SMTP
settings are correct.

Any ideas?

Thanks,
Kayda

I have a user that is only able to send messages in Unicode when in Outlook
Web Access. I cannot find any setting that controls this. All other users
are fine. He is the only Mac user that uses OWA in a Mac.

Please help.

Richard C. Goodlett - Information Technologies Manager
Urban Design Group, Inc.
15950 North Dallas Parkway, Suite 325
Dallas, Texas 75248-6615
972 788-9242
972 788-9234 Fax

I've had great success creating macros in Excel by capturing keystrokes and
mouse clicks. Is there similar functionality in Outlook?

In any case, I have to regularly send out newsletters and other informatino
to 700 users in 7 Distribution Lists. (because my service bureau limits
outgoing messages to 100). I'd like to automate the process, if possible,
and am sure that VB can do it - and that this question must have been asked
& answered many times before.

Here is my process:
1. Create a note
2. Click on the Cc button and select the B1 distribution list from my
Address Book,
3. Click on the Bcc button to place B1 in the proper field
4. Click Send
5. Open 'Sent Items' and wait for the sent message to show up
6. Click on it to open it
7. Repeat the above process for B2-B7

If anyone has a macro for this, I'd really appreciate it.

Many Thanks
Jimbo

I have an existing Macro in Outlook that basically scans an entire Mailbox
for Messages within a given data Range, dumps the data (date, email address
and email message body) into an excel file and then converts the excel to
..htm and places the .htm file output on a Network drive.

I would like to create a second macro - utilizing part of the code from the
first macro to read all emails and put the email addresses ONLY into a excel
file.

My problem is, when I launch outlook and then go to TOOLS/MACRO - I see my
original Macro and when I Overtype the name and click CREATE to create a new
Macro, I get this error: Compile error - User Type not defined - the code
from my original Macro is displayed in the Code window and this line is
highlighted:

Dim xlApp As Excel.Application

I guess what I don't understand is - How to I create a new Macro from
scratch ????

When I Typed in a new Macro name, I expected to see an empty code window.

DO I need to create a new module or a whole new project??? Any guidance
or help would be much appreciated.

signed,
a VBA Newbie

I want to create a macro that that will send then delete the item from my
sent Items.
Once I have this macro I can assign it to a custom botton in my Quick Access
Toolbar. Ther reason I want this button is for emails that you have no need
to keep a copy of. Like "Thanks"
There is a similar button in the Ribbon that says "Save and Close". I want
one that "Send and Delete"

Can any one write a Macro to do this?


Not finding an answer? Try a Google search.