+ Reply to Thread
Results 1 to 8 of 8

Documents created from mail merge won't print

  1. #1
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    391

    Documents created from mail merge won't print

    I have a series of documents created from a mail merge, and then split into individual documents. My problem is that the documents will not print - neither the original file produced from the mail merge, nor the individual ones.

    If I print to my default printer, a message pops up indicating that the document has been sent to the printer - however it says the document is one page when it is more than that. In any case, zero pages come out of the printer. I've tried on a colleagues computer (who uses a different printer) and got the same result.

    Curiously, if I print to PDF, it works fine.

    Attached is the file I've been testing with - hope someone can help!
    Attached Files Attached Files

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,531

    Re: Documents created from mail merge won't print

    Since the document 'prints' to PDF, a faulty printer and/or printer driver is the most likely problem for your 'real' printer. Try uninstalling & re-installing (preferably with the latest drivers from the maker's website).
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    391

    Re: Documents created from mail merge won't print

    I can print anything else just fine, so it's not the printer. Can you print the attached file?

    It seems to be something to do with the section breaks that the mail merge puts in. If I delete the break, it will print ok, but it also messes up the page layout.

    If you look at the file I attached in the original post, you can see this behaviour. Try printing as is and nothing happens. Delete the section break at the end of the document, and the file prints, but the whitespace at the top of the page increases for some reason. Doesn't make much difference in the attached file, but it makes a big difference in the real files I'm working with.
    Last edited by mgs73; 02-25-2016 at 10:39 PM.

  4. #4
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,531

    Re: Documents created from mail merge won't print

    I'm not sure that printing your document would prove much regarding the mailmerge. For starters, it has nothing representing a mailmerge main document or a mailmerge's output (assuming it's supposed to be a letter merge, the Section break on the 2nd page should be a 'Next page' one, but it's a 'Continuous' one instead). The reason your page layout goes awry if the Section break is deleted is because it has a different page layout to the first Section - another indicator that, at best, the mailmerge main document is poorly configured.

  5. #5
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    391

    Re: Documents created from mail merge won't print

    The mail merge output was split into individual documents, replacing the Next Page breaks with Continuous breaks to avoid a blank final page.

    The document had sensitive information in it, so it was all deleted and replaced by the dummy text in the attached document. It still displays the undesirable behaviour - at least on my PC, and a colleagues PC (different floor, different printer). To add to the mystery, on another colleagues PC on yet another floor and using yet another printer late this afternoon, it all worked ok.

    How can I make the page layout on either side of the break the same? I don't understand why they should be different in the first place, as in the original document, all that was after the section break was the next mail merge document.

  6. #6
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,531

    Re: Documents created from mail merge won't print

    They're different because you attachment is not an output document from a mailmerge; if it were, there'd be no change in layout after the Section break - which would only ever be a 'next page' one. Evidently, your mailmerge main document'spage layout isn't the same as the template being used by your 'split' process to produce the individual documents. Furthermore, the fact the output document prints on another user's printer is evidence enough the problem isn't with the document itself.

    For a better way to produce individual mailmerge output documents, see Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks thread at:
    http://www.msofficeforums.com/mail-m...ps-tricks.html
    or:
    http://windowssecrets.com/forums/sho...ips-amp-Tricks

  7. #7
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    391

    Re: Documents created from mail merge won't print

    Furthermore, the fact the output document prints on another user's printer is evidence enough the problem isn't with the document itself.
    It printed on one colleague's printer - three out of four PCs would not print.

    Happily, running out of toner has solved the mystery. After replacing the cartridge, I looked at the print queue and noticed a dozen or so documents of mine waiting to print. They still wouldn't print, and when I looked closer I found that it was trying to print using Tray 1, which is A3. I checked the printer that did print the document, and its Tray 1 was A4.

    I checked my printer settings - everything was automatic, but eventually I found the guilty setting in Page Layout - Paper. For some reason, Paper Source was set to Tray 1 - I changed it to Automatic, and now everything works as expected.

  8. #8
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,531

    Re: Documents created from mail merge won't print

    OK, it didn't occur to me ask whether you had checked the basics - like the print setup, whether there was paper/toner in the printer, etc., etc. Those kinds of things one would expect to have been checked before posting...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to split mail merge into separate documents (MAC)
    By baobei in forum Word Formatting & General
    Replies: 5
    Last Post: 10-22-2015, 07:06 PM
  2. Split Mail Merge & Save as Seperate Documents
    By timbo1957 in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2015, 12:14 AM
  3. Why must I keep reconnecting the spreadsheet for my mail merge documents?
    By reallawyer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-21-2014, 03:52 PM
  4. [SOLVED] Macro for mail merge and save as word documents
    By aganesan99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2013, 09:16 AM
  5. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  6. Mail merge - create seperate documents
    By manito2000 in forum Excel General
    Replies: 0
    Last Post: 08-03-2011, 03:06 PM
  7. how do I use mail merge in excel for word documents
    By Lisa J Duffy in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 09:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1