Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
send to command/ e-mail and attachments
A mind bending question for all of you.
I have a list of company names and account numbers. Each week I must send them a 'terms file' this is a .tmf or .dsc file (our own suffixes) what I would like is to use send to or VB to create a button per company that does the following; Opens a new e-mail (outlook 2007) Enters there e-mail or e-mail's Enters a subject Enters a body of text Attaches the tmf or dsc from a folder to the e-mail. I can do all but the last step using the send to command in excel, but with the recent upgrade to MS office 2007 and my lack of VB skills I was wondering if the attaching could be done automatically. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send an email, some with/without attachments | Excel Discussion (Misc queries) | |||
send mail from excel 2000 with multiple attachments | Excel Programming | |||
send tomail recipient (as attachments) is grey'd out | Excel Discussion (Misc queries) | |||
Creating TWO-WAY E-Mail Attachments with 'BeforeSave Events' in Code for 2nd E-Mail | Excel Programming | |||
Can I issue a File, Send To, Mail Recipient command in a macro? | Excel Programming |