LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 giving annoying "Send/Don't Send" error when closing BigDaddyCool Excel Discussion (Misc queries) 0 January 29th 10 02:31 AM
Bypass: A program is trying to send mail using Item.Send prompt Vick Excel Discussion (Misc queries) 1 June 25th 09 03:31 AM
My send to in excel/word does not offer send as attachment Mstink Excel Discussion (Misc queries) 11 March 16th 06 02:49 PM
Yes / No Feature DCSwearingen Excel Worksheet Functions 1 August 5th 05 05:04 PM
How do I build a feature into a cell that would send an email rem. Jim Johnson Excel Worksheet Functions 2 November 4th 04 07:23 PM


All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"