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

Debbie,

Try
Application.Dialogs(xlDialogSendMail).Show "

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" wrote in message
...
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

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.

"Steve Yandl" wrote:

Debbie,

Try
Application.Dialogs(xlDialogSendMail).Show "

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" wrote in message
...
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 -

It gives me compile error - syntax

Thanks

"Steve Yandl" wrote:

Debbie,

Try
Application.Dialogs(xlDialogSendMail).Show "

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" wrote in message
...
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

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" wrote:

Debbie,

Try
Application.Dialogs(xlDialogSendMail).Show "

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" wrote in message
...
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

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



"Debbie Horner" wrote in message
...
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" wrote:

Debbie,

Try
Application.Dialogs(xlDialogSendMail).Show "

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" wrote in message
...
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