I recently recievced a Bulk email supposedly from yahoo, did anyone else get one?
- March 10th, 2010
- Write comment
So how or why does Yahoo! not deliver simple, non-Spammy mail that I have requested? There is no notice to me or the sender. The inference with a bulk mail folder is that I still am in control of my mail. The senders are not on any Spam list. They have not been reported to Yahoo. What gives!
With help in the past I’ve been able to grow my excel VBA knowledge widely.
I’ve been able to create new workbooks and save them out according to a company name in cell “E2″ and a date in cell “G2″.
So I now have a list of 40+ excel workbooks uniquely named by ‘Company’ and date and saved in the companies folder on a network drive that need to be emailed to each of the unique companies each month.
What I need to do to save me time is to automate the bulk emails and attachments.
I’ve found links and codes for sending an email for one attachment or email for the active workbook, what I can’t seem to find are suggestions for sending out emails according to a list of addresses (from excel) then have a pop up saying:
“
and have a dialogue box for you to get the attachment.
then loop to the next company name and address with a standard body text for each email.
Then Send all the emails out.
Any help would be GREATLY appreciated.