Mail Merge won't print


    Sponsored Links


  • 1. Merge Field With Underlines
    I am doing a mailmerge out of an Access database. One of the fields is True/False. When the value is True, I would like the mailmerge field to contain three underlines with a capitol X in the middle. When the value is False, I would like the mailmerge field to just contain three underlines. How do I setup the merge field to do this? Thanks! Steve
  • 2. Adding data to the data source!
    I have a word document with a header file(Merge fields), and I have a disconnected recordset with the data for those fields. What is the best way to get the data into the document for later merging. Is there a way to past data to the data source without actually being connected to a database(using the disconnected recordset)?
  • 3. Labels to Form Letters
    We were sent a file formated for mailing labels that we would like to use as data for a mail merge. Is it possible to take data from address labels and merge them into form letters?
  • 4. Date/Time format problem merging EXCEL or Access info
    Word 2002, EXCEL 2002 and Access 2002 problem: When I merge an EXCEL table or an Access table to a Word document, the date and time formats on the source date are not carried into the merged Word document. I need to have July 30, 2003 (in either table) repeated in my doc, not 7/30/2003. Any suggestions? Thanks...
  • 5. If...then...or skip mergefields
    Hi, I am creating a document with several mergefields. One particular mergefield may not be populated in the final documents, and I need a way to have that line or space removed from the final document. The document is a letter and it looks like this: Date Field2 Field3 Field4 Field5 Field6 - this the field that may be populated in some documents but not others Dear Field7 and so on... Do I need to add a skip field code? How do I get it to detect if there is data, and if there isn't to skip to next field or remove that field? TIA, Jason

Mail Merge won't print

Postby U2hlaWxh » Thu, 20 Nov 2003 01:11:28 GMT

VBA Application on an XP with a merge to create form letters.  About a month ago this was working fine with no problems what so ever.  Two weeks ago the process decided not to work.  The Word document is created just fine but when you get to the print window and hit okay to print it pretty much comes to a stand still.  It spools about 1 byte per minute (network printer).  Anyone help would be greatly appreciated.

Re: Mail Merge won't print

Postby Doug Robbins - Word MVP » Thu, 20 Nov 2003 09:54:37 GMT

Hi Sheila,

Without seeing the code, there's not much chance.  Paste it into a message
that you post back here and it might provide a few clues.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

month ago this was working fine with no problems what so ever.  Two weeks
ago the process decided not to work.  The Word document is created just fine
but when you get to the print window and hit okay to print it pretty much
comes to a stand still.  It spools about 1 byte per minute (network
printer).  Anyone help would be greatly appreciated.

Mail Merge won't print

Postby Pam » Fri, 22 Jul 2005 03:17:23 GMT

I have Microsoft Word 2002 on XP pro and have not been able to 'print' a
merged document of labels - I can open up a file and print - or choose new
and type test on it and then print perfectly fine...but it just won't print
the labels. I have a HP lazerjet 5mp . Every time I choose print on the
labels, the printer goes to the error light - it ONCE printed a bunch of
numbers straight across a page with a partial adress:

44 50 72 25 89 28 28 28 39 25 25 89 72 25 50 50 50 50 01xs 1113 2090 M

and then on the 2nd page it printed:

%% [Page: 41%%) -

%%BoundingBox: 13 13 599 70
%%+font Times-Roman
%%+ procset Pscript-WinNT ErrorHandler 5.00
%%+ procset Pscript_FatalError 5.0
%%+ procset Pscript_WinBasic 5.00
%%+ procset Pscript_Win_Utils_Ls 5.00
%%+ procset Pscript_Text 5.00
%%+ procset Pscript_Encoding256 5.00
%%+ procset Pscript_Win_Euro_L2 5.00
ehsave restore
%%Pages: 4
(%%[LastPage]%%) =

can anyone make any sense of the above or tell me how to get the labels to


Re: Mail Merge won't print

Postby Doug Robbins » Fri, 22 Jul 2005 07:04:20 GMT

What happens if you execute the merge to a document and then print that? 
Labels are only tables.

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my 
services on a paid consulting basis.

Doug Robbins - Word MVP

Re: Mail Merge won't print

Postby Peter Jamieson » Fri, 22 Jul 2005 07:24:03 GMT

Well, the stuff you are seeing is the sort of PostScript code that would be 
output when you print a file using the PostScript driver for the 5mp. I 
don't have a 5mp here so cannot test this particular problem, but
 a. do you always use the same printer name when printing to this printer? 
(i.e. does the very same printer normally work OK?)
 b. there are two different drivers for the 5mp - a non-PostScript one 
called HP LaserJet 5MP and a PostScript one called HP LaserJet 5P/5MP 
Postscript. If you have the other driver, try that as a workaround.
 c. You could also try outputting your labels to a new document, then 
printing that document (maybe you have already done that, but if so, try 
opening that document, then checking Word Tools|Options|Compatibility 
Options|"Print body text before header/footer" and printing a page or two. 
All it does is to alter the sequence that Word outputs data to a PostScript 
printer but maybe it will make a difference in this case.

Peter Jamieson

mail merge won't print

Postby bm90dmVyeXRlY2h5 » Thu, 03 Jan 2008 18:46:00 GMT

I have been using mail merge for years to create mailing labels for a 
membership database. Now all of a sudden it will not print. I've tried to 
send it as an attachment, looks as though it is all there but it is blank. 
main document won't copy into notepad. I can work on the main document, add 
to it, etc.. all seems fine until I print or attach. I need to send out 400 
labels for a conference and am panicking

Re: mail merge won't print

Postby Peter Jamieson » Thu, 03 Jan 2008 20:21:57 GMT

Which version of Word?

It isn't completely clear what is happening - if you merge to a new 
document, can you see anything in the new document?

What are you trying to do at this point?

Are you actually doing the merge (sorry to ask since you're obviously used 
to mail merge!)

Peter Jamieson

Re: mail merge won't print

Postby bm90dmVyeXRlY2h5 » Thu, 03 Jan 2008 22:27:01 GMT

Re: mail merge won't print

Postby Peter Jamieson » Thu, 03 Jan 2008 23:37:46 GMT

>> I'm not sure which version of word, I started the document in 2005.

Look in Word Help|About for verion info. From what you say I will guess Word 
XP (2002) or Word 2003.

With your mail merge main document open,
 a. can you see the table gridlines (the labels are laid out using a Word 
table)? Try Table|Show gridlines if necessary.
 b. If so, press Alt-F9. Can you see some word Field codes in curly braces, 
e.g. { NEXT } ? Can you see any other fields, e.g. { MERGEFIELD something }? 
If not, then you need to insert the fields you want from the data source and 
"propagate labels".

When you merge, merge to a new document. You should get a new document with 
all the labels. You should be able to print that, or attach it. You should 
need to mess around with notepad.

I just have a feeling you may have forgotten something in your usual 
process. But yes, something could be corrupt, in which case I suggest you 
try the steps in the page at  http://www.**--****.com/ 
even though the title does not describe your issue precisely.

Alternatively, Graham Mayor's page at 
process: see where what you are doing differs from that.

Peter Jamieson

Re: mail merge won't print

Postby RWxpemFiZXRo » Thu, 10 Jan 2008 00:33:01 GMT

have a Word document set up with merge codes, merging from an Excel file.
The trouble I am having is that when the Appt_Date and Appt_Time fields have
text other than a date and time or they are blank, the merge process is
filling in the merge fields with the current date and time of 12:00 AM.
How can I setup the merge codes to give a result of the text from the Excel
file or leave blank if there is no text?

Interviewer: Interviewer
Appointment Date: Appt_Date
January 7, 2008 Appointment Time: Appt_Time

First_NameSpouse_Name Client_Last_Name
City, State Zip_Code


"Peter Jamieson" wrote:

Similar Threads:

1.HELP!!! Mail Merge won't print

Here's a stange problem.  I have for years been using a mail merge
application to produce a catalogue.  The application extracts data
from an Access database and dumps it into a Word document.  It was
originally created when I was running Windows 95 and earlier versions
of Word and Access.  Since than I have upgraded to Office 2000 and
Windows XP.
The mail merge routine still runs fine, the problem is when I send it
to the printer it will not print.  When the printer is reset it then
prints a few pages of garbage.
I tried creating a new master document and got the same result.
Where's the problem Word or Access oor both?  Can anyone provide some
ansers?  Thanks.

2.Mail merge won't print correctly

When I attempt to do a mail merge from Excel to Word (both 2003) on Avery 
label 7160 the print preview is fine, but in the actual print the labels just 
do not line up.
Any ideas would be greatfully received.

3.mail merge won't print blanks

A workaround is to change the way Word connects to the Excel file - check
Word Tools|Options|General|"confirm conversions at open", reconnect to the
spreadsheet, and selec tthe "Excel via DDE" method. This requires that Excel
is installed on your system and results in an Excel window popping up, but
is probably the simplest way to solve this one.

"paula" < XXXX@XXXXX.COM > wrote in message
news:06c201c3793f$89a75010$ XXXX@XXXXX.COM ...
> my merged document prints zeros when the mergefield is
> blank.  I would like it to print nothing and leave the
> lines/spacing there.  Im using Word 2002 and the data
> source is an excel file.

4.mail merge won't print different name on each label

I'm trying to merge a mailing list to labels.  When I merge it prints one 
name multiple times on first and second page then the next name on every 
label third and forth page.  Word help has been no help.

5.Mail Merge to Word - Zip Codes won't print

I'm doing a mail merge from Outlook, discriminating by 
catagory, and printing onto a letter that's already been 

All works fine.  The letters print on the printer, the 
address section fills in fine, the Dear "so and so" is 
all there.  The only problem is that the zip code won't 

Along with this, is there any way to customize the 
Dear "so and so" -- because it prints the full name, 
rather than just a first name -  I want just first names 
on some, and full on others or maybe "Mr. Doe."

Also, once I get the zip code to print (assuming you 
folks can help me), is there a way to get the letters to 
print in zip code order?

Thanks so much for this site.


6. problem w/ word won't save documents or mail/print merge

7. mail merge label text won't print as seen on screen

8. Printing a mail merge doc, merge fields print with grey background

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 92 guest