Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Still Waiting 4 Help - Access/Word (2000)

    You might put text boxes in the mail merge document, put the mail merge fields in the text boxes, and set the border of the text boxes to transparent.

    Another idea:

    Have you considered creating a report in Access instead of a mail merge document in Word?

    In a report, you can specify that a text box is always the same size, irrespective of the contents, by setting the CanGrow and CanShrink properties to False.

  2. #2
    New Lounger
    Join Date
    Apr 2002
    Location
    TN
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Still Waiting 4 Help - Access/Word (2000)

    I am still waiting for someone to help me with the following problem: I HAVE posted it, but no one has responded with a solution.....Please, if it can be done show me how!

    MY QUESTION / PROBLEM IS:
    I work at a Funeral Home and I am currently using MS Access & WORD 2000, and I have a database of records I want to print certain fields onto a Pre-Printed form....namely a Death Certificate.

    I thought I had it all figured out after lining up the fields to print the SSN, Sex, Name, date of Death etc., onto the pre-printed-form. It worked fine with the "one name I was playing with", the problem came when I decided to print another Death Certificate with a new record I have in the Database.
    The name, or new record, of course had different information and different "lengths" of a name, etc.

    The "Mail Merge document" I had created using the "one name" to practice with, didn't work when I Merged "any other name" onto it....the Fields Moved on the Merge document.....the info wouldn't place in the same boxes each time, etc.

    The same thing happened when I had someone in the database that didn't have a middle name.

    Below are some of the Fields I have in my Access Database:

    FName for First Name
    MName for Middle Name
    LName for Last Name

    Is there a way to place my Fields on a Mail Merge document and have them remain in ONE PLACE no matter "what data" I have in the Access Database??????

    I sure hope you can help me on this.

    Sincerely,

    E. Ray Austin, MSG, (US Army Retired), Photographer

    Visit my Web Site for details about my Photography business.
    www.eaglescovephotography.com
    ALL of my emails are screened with
    Norton AntiVirus when going out.
    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    Edited by Charlotte to remove email request

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Still Waiting 4 Help - Access/Word (2000)

    Please do not request email responses. This is a violation of <!rule=10>Rule 10<!/rule>. Offlist responses do not benefit other Lounge members who might have the same questions.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Still Waiting 4 Help - Access/Word (2000)

    If you are using a pre-printed form and the fields must fit into specific areas, it would seem that you need to account for the largest entry and adjust the font size in those portions of the document to ensure they will fit in that area. Since each table field has a data length, create a dummy record using the full length of each merged field and test against that.

    I didn't understand what you meant by the lack of a middle initial causing a problem. If First-MiddleInitial-LastName need to go in one text box, trim and concatenate them into one field before the merge.

    Addressing pre-printed forms can be tedious, but if you account for the largest entry and use the text boxes as Hans suggested you should be able to accomplish it.

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Still Waiting 4 Help - Access/Word (2000)

    My suggestion is, when you create your mail merge document or template in Word, use a TABLE to keep your mail merge fields in place. Click in a cell and insert the merge field. I use this technique all the time when exporting data to Word with positive results; before using tables to hold merge fields, had all kinds of problems. You can set table row heights to a fixed value so they don't "grow". After you get everything lined up so it prints correctly on the pre-printed form, select entire table and change borders setting to "NONE" so table & cell borders won't print out, the cells & data will still be lined up correctly, you just won't see the borders. The borders can always be restored if you need to make changes.

    Other option as suggested create report in Access, on Page Setup you can specifiy Print Data Only.
    HTH

Posting Permissions

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