Automate Outlook

Hi guys I am looking to create a solution to have Outlook automatically send an email message to contacts. I have come across a few things while googling but not sure whats the best approach.

The contacts are in an excel sheet and I found some code that will automate email from excel quite nicely, the only downside is formatting the message seems a bit tricky. I can obviously import the contacts to outlook if necessary

I feel there should be a better solution but have never worked with VBA in outlook before.

I basically just want the same message to go to all the contacts but not at the same time as this creates problems with isp thinking its spam

So rather then sit here at my computer and send 10 at a time i would like to program outlook to just send one at a time every few seconds or whatever interval I program in.

Does anyone have any solutions or ideas, I am sure this has been done but I cant seem to find anything on internet other then emailing an excel or access sheet

Again I want to send the same outlook message one at a time to group of contacts

Thanks

It's possible using both VBA-Excel and VBA-Outlook. Which one do you actually want?

Quote:

---

Originally Posted by koolsid

It's possible using both VBA-Excel and VBA-Outlook. Which one do you actually want?

---

Whatever one you thinkn is better and or easier to implement
perhaps both since I may just have contacts in excel and not outlook

see this link, lot of examples to send mail from excel.

Quote:

---

Originally Posted by seenu_1st

see this link, lot of examples to send mail from excel.

---

Thanks I have been there already and using some of those
I was looking for something without excel
just automate Outlook but i think there is enough there for me to work with and tweak