Hello all,

I am trying to create a macro for Outlook 2003 that will open a new message, populate the From Field, populate the Subject field (these never change), and then populate the body of the email (which also never changes). I am very new to this. My goal is to steamline the process down to "click a button, get a populated email".

I have the first part:

Dim olkMsg As Outlook.MailItem
Set olkMsg = Application.CreateItem(olMailItem)
olkMsg.SentOnBehalfOfName = "Email address"
olkMsg.Subject = "My Subject"
olkMsg.Display

And the message:

Selection.TypeText Text:="Good morning,"
Selection.TypeParagraph
Selection.TypeParagraph

.... and so on

When I run the macro, the first part executes fine. I run into problems with the body of the email, because I keep getting the following error:

Run-time error '424': Object Required

What object should come between the first part of my macro and the text?

Thank you!

The Selection object refers to the Word library, Outlook doesn't know that.
You can use the Word library only in Outlook 2007, or if you have set to use
Word as email editor. In both cases you can access the email as a Word
Document object via the olkMsg.GetInspector.WordEditor property.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en



Am Fri, 14 Aug 2009 15:56:22 +0100 schrieb AndreaP:

Hello all,

I am trying to create a macro for Outlook 2003 that will open a new
message, populate the From Field, populate the Subject field (these
never change), and then populate the body of the email (which also
never changes). I am very new to this. My goal is to steamline the
process down to "click a button, get a populated email".

I have the first part:

Dim olkMsg As Outlook.MailItem
Set olkMsg = Application.CreateItem(olMailItem)
olkMsg.SentOnBehalfOfName = "Email address"
olkMsg.Subject = "My Subject"
olkMsg.Display

And the message:

Selection.TypeText Text:="Good morning,"
Selection.TypeParagraph
Selection.TypeParagraph

... and so on

When I run the macro, the first part executes fine. I run into problems
with the body of the email, because I keep getting the following error:

Run-time error '424': Object Required

What object should come between the first part of my macro and the
text?

Thank you!