Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Email Macro with Outlook Express
Once a week, I am in a position where I have to send between 80-160 emails to 80-160 different email addresses (the store locations in our company). I have an attachment that needs to be sent to each store, and each attachment is unique. However, I have all the attachments in one folder, and all of the attachments have filenames such as Store 101, Store 102, Store 103, etc... I have another file which lists all store numbers in Column A and their respective emails in Column B. Is there a way I can have a macro that does the following: 1. Creates an email with a Subject being the same as the filename which we'll attach (Ex. Store 101) 2. Looks up the first store's email address (Ex. Store 101) and uses it in the first email 3. Attaches the file titled "Store 101" from a specifc folder (where all other files are also located) 4. Includes a generic body to the email (Ex. Attached are your quarterly results) 5. Sends the email Any help is appreciated. Thanks, Moe -- Moe ------------------------------------------------------------------------ Moe's Profile: http://www.excelforum.com/member.php...o&userid=12500 View this thread: http://www.excelforum.com/showthread...hreadid=394408 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do use outlook express to send email in office 2003 | Excel Discussion (Misc queries) | |||
How can you email a macro from personal.xls | Excel Discussion (Misc queries) | |||
Macro in Outlook | Excel Discussion (Misc queries) | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) | |||
Outlook vs Outlook Express | Excel Worksheet Functions |