Send To Feature

[JohnV]

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

 

[Ron de Bruin]

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