Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Location
    USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello,

    I am trying to create a mail merge letter with an Access database that shows multiple records on one page. However I only need certain fields to appear only once.


    An example letter should look like this:

    John Doe (These are fields)
    1 Main Street (These are fields)

    Dear John,

    You have ordered the following items
    Tie
    Hat
    Bike

    Thank you,
    Sally


    John Doe appears in each record of the database but I only need it to appear once for the letter but the items need to be listed from each record. If I choose directory I get multiple records to appear on a single page but the address also lists multiple times.

    For example:
    John Doe
    1 Main Street

    Dear John,

    You have ordered the following items
    Tie

    Thank you,
    Sally

    John Doe
    1 Main Street

    Dear John,

    You have ordered the following items
    Hat

    Thank you,
    Sally

    John Doe
    1 Main Street

    Dear John,

    You have ordered the following items
    Bike

    Thank you,
    Sally


    Hopefully the two examples makes sense.

    Thanks for your suggestions.
    Steve

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Our moderator macropod has written a tutorial for this type of mail merge, with sample files. You can download it from Word 97-2007 Mailmerge Tutorial: Create Sorted Listings (v1.52). Please read the tutorial document carefully - this is far from trivial stuff!

  3. #3
    Star Lounger
    Join Date
    Nov 2002
    Location
    USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Hans for your reply. This will be very helpful.

Posting Permissions

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