Send To Feature
 

I am able to open an Outlook Email with the spreadsheet as
an attachment by calling:
Application.Dialogs(xlDialogSendMail).Show

What I would like to do is use the code below:
Application.Dialogs(xlDialogMailEditMailer).show
which takes the following arguments: to_recipients,
cc_recipients, bc_recipients, subject, enclosures,
which_address. This will allow me to build a default
email that the users can modify. Has any one worked with
this particular command?

Thanks,
JohnV

Send To Feature
 

See this page John
http://www.rondebruin.nl/sendmail.htm#other

If you use display instead of Send in the sub the user can change
the default things you have add to the code


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"JohnV" wrote in message ...
I am able to open an Outlook Email with the spreadsheet as
an attachment by calling:
Application.Dialogs(xlDialogSendMail).Show

What I would like to do is use the code below:
Application.Dialogs(xlDialogMailEditMailer).show
which takes the following arguments: to_recipients,
cc_recipients, bc_recipients, subject, enclosures,
which_address. This will allow me to build a default
email that the users can modify. Has any one worked with
this particular command?

Thanks,
JohnV