Results 1 to 2 of 2
  1. #1
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,863

    Creating Report using Word Mail Merge

    I have an Access database, where I have created multiple queries to get the data I need down to two queries (or one query, which works better) in order to do a mailing.



    One query contains client information (client id, address, main contact, etc). Client ID is a unique field in this query (no repeats). This is to be used for the mailing address (one letter for each record).

    The second query contains various contacts for each client (client id, contact name, contact email address, etc). This is to be used for the body of the letter.
    There is a one-to-many relationship between query one and query two. For each client id, all the contacts for that particular client id should appear on a single letter.

    Now, I know how to do this in Access reports (can use grouping or subforms). However, Access reports are not quite pretty enough for this mailing, so we would like to do a mail merge to Word instead. I have only ever done a "one record to one letter" type merge in Word, never these "one-to-many" type merges.

    Can anyone provide any pointers on how to do this?

    Thanks
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,863
    In researching it, I could not find an easy way to do this. Here is one of the links I found: http://homepage.swissonline.ch/cindy...r/MergFram.htm

    So I ended up creating the Report in Access after all. May not look quite as nice as it would in Word, but I think it will do.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Mail Merge in Microsoft Word
    By imintrouble in forum Misc
    Replies: 0
    Last Post: 12-02-2011, 03:48 PM
  2. Help needed with mail merge to Word
    By mhart in forum Import/Export Data
    Replies: 1
    Last Post: 08-12-2011, 12:22 PM
  3. Mail merge with word
    By alexc333 in forum Access
    Replies: 0
    Last Post: 07-26-2011, 12:06 PM
  4. Mail merge from from Access to Word
    By williamgladstone in forum Access
    Replies: 1
    Last Post: 03-22-2011, 12:00 PM
  5. Mail Merge from Access to Word
    By Rachelkm2 in forum Programming
    Replies: 1
    Last Post: 05-29-2009, 02:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums