What’s an email blast?
- July 23rd, 2010
- Write comment
Archive for the ‘Programming & Design’ Category
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.
Dim objMail
Set objMail = CreateObject(”CDONTS.NewMail”)
ObjMail.Send “erikbays@yahoo.com”, “marketing@republiccapitalgroup.com”, “Subject”, “This is the body.”
Set objMail = Nothing
it is very basic; straight off of the Microsoft web site in fact. Executing this script does not give me an error. The resulting page displays normally. I just don’t ever get an email. I have checked my bulk bin. My server is running VBScript version 5. Without an error message I can’t figure out what the problem is.
How do I prevent my account from being blocked?
What are the limits on sending bulk emails?
Who decides that an account is being used for spam? The ISP or the hosting company that hosts the mailbox?
I KNOW, price may VARY. But I’d like to know if you had estimated software cost before? If yes, what do you think?
Do you have examples, how much particular piece of software would run?
What about hiring offshore freelance company? how safe would that be? Are there any companies which can be 100% trusted (estimated software cost vs NO CODE/IDEAS slipping out)?
I’m not interested in ready solution and not interested in free/open source solutions.