OutlookEXPRESS and VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BradC - 25 Feb 2005 18:10 GMT

where can i get code or how do I use VBA to open Outlook
Express and merge a word document into a new email and
send it?

Reply to this Message

Doug Robbins - 25 Feb 2005 23:47 GMT

AFAIK, you cannot automate Outlook Express.

Check out Mailmerge in the Visual Basic Help File. This is the example on
how to automate the mailmerge operation to email

This example merges the document named "FormLetter.doc" with its attached
data document and sends the results to the e-mail addresses stored in the
Email merge field.

With Documents("FormLetter.doc").MailMerge
.MailAddressFieldName = "Email"
.MailSubject = "Amazing offer"
.Destination = wdSendToEmail
.Execute
End With

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> where can i get code or how do I use VBA to open Outlook
> Express and merge a word document into a new email and
> send it?

Reply to this Message