Hi,
I was recently put in charge of an excel database that contains a list of contributors to our foundation. THe databse contains information such as the date and amount someone donated to our foundation and their total amount of donations. What we want to do is send a form letter via e-mail to each person who has donated to our foundation that thanks them for their donations and gives them a history of all thier previous donations to our foundation. I have no idea how to do this. Am I going to have to do this by hand or is there a much simpler way?

No, this can be done, through VBA in Excel. I will look through some references where this is spelled out in detail.

Okay, try this:

http://www.mrexcel.com/board2/viewto...03d08640a9719e

thanks for the help!

Shades,

Just curious... any advantage to using scripting vs VBA and the Outlook object model? Reason I ask is I've been doing a lot of mass-mailing tools in VBA for a client and we've had to skip through hoops because of Microsoft Outlook security patches. Does scripting bypass that hurdle?

Thanks for a great post.

Joe G

I would say that XL-Dennis might be a better source to answer that. I will try to locate him again and send him to this question.

Hi guys,

Outlooks security-message activates when any external call is made to it.

There exist some workarounds based on thirdpart-tools.

You may take a look on redemption here:
http://www.dimastr.com/redemption/

However I've been doing some projects where we skip the e-mailclient and use the SMPTP only. You may find this free tool (or buy the latest version for $10.00) interesting:

http://www.xwebware.com/products/commail/index.html

Kind regards,
Dennis

Dennis, thank you for the quick response.

Joe G