Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44

    Angry Unanswered: Setting up Access or Word for a Mail Merge. I am having problems!!!

    Hello again,

    I want to use Mail Merge to take my Access Database and email a customer when their order has been confirmed. Here is how my data is stored:

    Customer#___ Customer Name___ Order#___ Part#___ Price
    1234567___ John Smith___ 987654___ part123___ $50.95
    1234567___ John Smith___ 987654___ part678___ $23.95
    6789101___ Sam Peters___ 766543___ part500___ $99.95
    6789101___ Sam Peters___ 766543___ part901___ $101.00


    I want it to show up in records for an email Mail Merge like this:

    Dear John Smith,

    Your order, 987654, has been confirmed. Here are the parts you purchased:

    part123 $50.95
    part678 $23.95


    Thank you


    Can this be done? How can you tell mail merge to group off of a criteria like name or customer number? Right now, if someone ordered 15 parts, they will get 15 emails, confirming those 15 parts. That is BAD... Any help???

    Thank you!

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Where will you be calling this function from? Will you be sending one email at a time or several emails to multiple customers?

  3. #3
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44
    On average, I would say about 200 emails a day, but broken down into a few time frames each day (i.e. 12am-7am, 7am-10am, 10am-1pm, 1pm-4pm, 4pm-7pm, 7pm-12am)

    I will be taking the list of users (email addresses) from access, as well as the info, so I will run the function out of Access I believe.

    I am sketchy due to the cross between Word, Access, and Outlook. I am unsure how to automate all of it.

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Use the Outlook Mail Item from Access.

    Use a nested loop to create the email. The outer loop to pick up the customer name, email, order number, and send the email. The inner loop will pick up your order detail.

  5. #5
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44
    In Access? I run 2007. Would it be located under External Data - Collect Data - Create E-Mail?

Posting Permissions

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