[Solved] mail merge...

  • Word and I fail to agree. I have made a monster spreadsheet in Excel.
    I finally figured a way to generate a small Excel spreadsheet to use as a database for a Word mail merge. (Technically not a MAIL merge as I am making certificates).
    I have 3 certificates on a page.
    I had the idea that each one would be to a different person. Word however feels I need 3 for the same person before it moves to the next name.
    How can we get along? Is there an easy way to..well get my way?
    I am using Office 2000 and Tylenol.:(

  • The tylenol kicked in, the headache left and suddenly .... I realized I had forgotten to insert the Word field "Next Record" !! (sigh)
    Thanks anyway, this works great.
    If there is a better way lol I am ALWAYS open for help, hints and "Hello you're doing that the hard way" :wink1:

  • well, I thought it was solved.
    The merge works, and it previews fine, but when I print, no matter whether 15 or 30 rows on my Excel Spreadsheet meet the criteria in the filter or if the filter is off....it will only print 12 certificates.
    When I press the "merge preview " button it appears as correct, shows all the certificates. If I print preview or print, there is always only 12.
    Can someone help please, I am out of Tylenol:(

  • I "think" the problem begins not in my mail merge but in Word.
    Under "File", "Properties" the number of pages to print is 4. Can I change that? Or is that not my problem?
    Any ideas PLEASE

  • Hi kimberly,

    You've been having a nice conversation with yourself up to now :wink1: - so I'll butt in and see if I can lend a hand.

    Check on the File / Print dialog box and make sure the "Page Range" "ALL" radio button is checked; The "Print What" box says "Document"; and the "Print" box says "All pages in range".

    I can't find anything on my File / Properties window that refers to the number of pages to print (i'm using Word XP) - can you tell a bit more of where you are seeing that (which tab - what else in on the page, etc) - can you change the value there?


  • Quote
    Check on the File / Print dialog box and make sure the "Page Range" "ALL" radio button is checked; The "Print What" box says "Document"; and the "Print" box says "All pages in range".

    I just double checked those,and yes they are correct.
    and yes, hehe, I am talking to myself here also! But at least I quit pounding my head on the desk. sigh. I have 9 other projects that should have been difficult that I have almost completed today--piece of cake. THIS which should have been easy is now 2 days overdue.

    The File/Properties area I mentioned before seems to just be information on whatever document you are looking at. Now it seems to feel I have a 1 page document with 47 paragraphs. sigh.

  • If anyone else is still following this thread, after we examined the merged certificates with the excel data, we find that word is NOT stopping after 12 certificates, but it is actually skipping rows of data.
    In excel the first three rows of data are merged, then one row is skipped over; the next three are merged, and again one is skipped over.
    Each row is set up the same as the others, no blank spaces or anything, and yet they are being overlooked.
    Any ideas? We are close to booting our computer---right off the balcony:(

  • I have the SAME problem! Even with filters off, Word keeps skipping over data rows in Excel!
    I am really anxious to see how to fix this, we keep having to do our mail merge, then go back and search for the missed ones and put them in manually!
    What a PAIN
    we use Office 2000 and Win 98

  • This is just a suggestion.

    If you are adding a <Next Record&gt; field to the last merge field in the document then this will cause it to skip a record. As the end of the document will also perfom a built in Next record. (At least this was what I experienced when trying to test).


  • Andy Pope, you RULE!
    That is exactly what I did!
    thank you soooo much, I was afraid it was something simple (and obvious to everyone else) but I just couldn't see it.
    Thanks again!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!