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 |
I forgot to mention that I would need it to loop through the whole list of Store #'s. 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 |
In , Moe told us an
interesting story. My reply to this story is at the bottom of this message. 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 You'll need this: http://www.rondebruin.nl/mail/add-in.htm -- Amedee Van Gasse |
All times are GMT +1. The time now is 10:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com