Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 giving annoying "Send/Don't Send" error when closing | Excel Discussion (Misc queries) | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
My send to in excel/word does not offer send as attachment | Excel Discussion (Misc queries) | |||
Yes / No Feature | Excel Worksheet Functions | |||
How do I build a feature into a cell that would send an email rem. | Excel Worksheet Functions |