Mail Merge won't print

MS WORD

    Sponsored Links

    Next

  • 1. SQL, merge fields, and other mysteries
    Setting the scene... I have inherited a Filemaker database (Recruitment Agency). Part of its job is to export (Candidate) data to a .MER format (called 'Candidate.mer') A .DOT CV template in Word was created ages ago (by a previous employee, not trackable) that is nicely formatted, and holds all the relevant fieldnames that match the .MER file fields. On opening this .dot template, a dialogue box is displayed: "OPening this docuement will run the following SQL command: Select * from C:\Desktop\Candidate.mer". On selecting 'Yes', it goes ahead and inserts the related merge field data from my Filemaker exported file Candidate.mer, into a new unsaved document. That's all OK. But now I want to save this document in plain Word format. So I removed the fields, then save the file and close it. But no matter what I do, on re-opening the document (now saved with the name of the Candidate eg Alvarez.doc etc) it keeps displaying the dialogue box on opening that asks if I want to run the SQL command. I am not an SQL expert by any stretch and am stumped. Here's what I have tried.... Selecting all the text, then removing fields (CTRL + SHIFT + F9) (that does work, but doesn't take away the dialogue box on opening). So while I have removed the fields, there must be some SQL command embedded in the document that needs to be de-activated in the saved document. But where? TIA, Geri
  • 2. How do I put a picture into a mail merge as part of the data to b.
  • 3. HOW DO I ASSIGN A MERGEFIELD DATA RESULT DIRECTLY INTO A VARIABLE.
    I am trying to get Word to extract data from my clinical database (.DBF format) so I can produce personalised (referral) letters for clients. I can extract the data into my letter template using a mailmerge feature involving {MERGEFIELD fieldname} but would then like to assign the result to a variable for use in a macro so I can manipulate the data and get the macro to run on opening the template. For example - my database contains my patient's date of birth - {MAILMERGE birthdate} returns 08-09-1958 as text - I need to manipulate this data to convert the date of birth to an age value to include in the referral letter. - I was planning on doing this via an autostart macro but need to get the macro to recognise the result of {MAILMERGE birthdate} as a variable unless there is a better way of achieving the same result. Any HELP / suggestions gratefully received
  • 4. If... Then... Else and MergeFields
    You mean the field delimiters { }? You must use Ctrl+F9 to insert them. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "AmberTheAdmin" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ... > Well, I think I've figured part of it out, but now the issue seems to be > that > Word is not recognizing my brackets as part of the If statement, it sees > it > only as a character... > > Any help out there? > > Amber > > > > "AmberTheAdmin" wrote: > >> Help! I used to consider myself and expert and I know I've done this >> before, >> but I need help! >> >> I have a database where some folks have spouses and other's dont. I need >> to >> create lables that effectively show this fact. >> >> I need something like the following formula: >> "If {MergeField LastName} = {MergeField SpouseLastName} "and" >> "{MergeField >> LastName}" >> >> I've got it showing the "and" correctly in my merge, but when the fields >> are >> equal, I can only get the text of {MergeField LastName} >> >> Any help is really appreciated
  • 5. Email merge HTML
    In word2002 and outlook2002 installed performing an email merge if I choose HTML format to send emails it does not work. However, if I choose attachment or plaintext it does work. Is this a bug?

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
(Denise

and then on the 2nd page it printed:

%% [Page: 41%%) -
%%PageTrailer

%%Trailer
%%BoundingBox: 13 13 599 70
%%DocumentNeededResources;
%%+font Times-Roman
%%DocumentSuppliedResources:
%%+ 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]%%) =
%%EOF

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

thanks!
Pam



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
 http://www.**--****.com/ 







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 
 http://www.**--****.com/ 
process: see where what you are doing differs from that.

-- 
Peter Jamieson
 http://www.**--****.com/ 











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
Street
City, State Zip_Code



--
Elizabeth


"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 
created.

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 
print.

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.

dave

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 6 guest