open outlook and add email address

[Debbie Horner]

I want to open the Outlook dialog box and populate the "to address" with an
email address - I do not want the email to automatically send. I currently
have code which opens up the dialog box fine..just need to add email address
to it..

code is currently
Application.Dialogs(xlDialogSendMail).Show

Thank you

 

[Steve Yandl]

Debbie,

Try
Application.Dialogs(xlDialogSendMail).Show arg1:="(e-mail address removed)"

If you want more than one address, just separate addresses in the list with
semicolons and enclose the entire string in double quotes.


Steve Yandl

 

[Debbie Horner]

Thanks Steve...I tried that because I saw it out here and it gave me an error
but I will try again and let you know.
I appreciate the prompt response..this site has been very helpful.

 

[Debbie Horner]

Steve -

It gives me compile error - syntax

Thanks

 

[Debbie Horner]

Nevermind...
When I first saw it...it displayed as two different lines...when I got a
bigger screen and saw that you had it on the same line...I moved it and it
works like a charm!!!

Thanks a million!

 

[Steve Yandl]

You're welcome.

You can also have additional arguments using the same format but each
argument separated by a comma. arg2 would be used if you want to pre-set
the 'Subject' line and arg3 could be set to true or false to indicate you
wanted a return receipt.

Steve