Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: need help, mass e-mail and excel

    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?

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    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
    Last edited by shades; 12-30-03 at 10:25.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    Originally posted by shades
    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!

  4. #4
    Join Date
    Dec 2003
    Posts
    172
    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

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  6. #6
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    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
    Kind regards,
    Dennis

  7. #7
    Join Date
    Dec 2003
    Posts
    172
    Dennis, thank you for the quick response.

    Joe G

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •