Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    18

    Unanswered: Help with Mail Merge

    All:

    I have a Microsoft Access 97 database with 700 entries in it. I need to take each entry and put it into a formatted document. I have no freedom on the format of this document, I have to use exactly what they give me. it is a MS Word document.

    Once the documents are done, I need to put each document into a separate folder (which already exists)

    Example file structure:

    Names\
    Bill\
    Personal\
    Bill.doc

    Fred\
    Personal\
    Fred.doc
    Mary\
    Personal\
    Mary.doc


    I can make a mail merge move around the data into the shell document, but I then end up with a single 1400 page document, instead of 700 seperate documents. I cannot simply cut & paste the 2 pages at a time into new documents, because selecting the data only takes the data, not the formatting of the document.

    Am I asking too much?

    Is there a better tool?

    Thanks for the ideas!

    Robert Hembrook
    Motorola Global Software Group

  2. #2
    Join Date
    Feb 2002
    Posts
    64
    See the attachment and reply from the other thread, it will give you a good start at solving your problem.

  3. #3
    Join Date
    Sep 2002
    Location
    New york
    Posts
    4

    Mail Merge

    Have you tried going to tools in the Word document clicking on Mailmerge then
    1.Create - form letter - active window
    2.Get data -open data source - use existing
    3.Merge data
    Then go back to Word document and insert the "merge fields" in the proper place in the document and then print them to file.

Posting Permissions

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