I have an Excel data file that I use as a master list for merges.  Recently,
I added a last name with an apostrophe (e.g., O'Donnell).  Word comes back
during a merge with the message, "Word could not parse your query options
into a valid SQL string."

Hi group.
I am using the MailMergeBeforeRecordMerge event during a merge, and I
am inspecting the data. Everything works fine until I hit a record I
don't want to merge, so I set Cancel = True and it stops the entire

If I calculate a date in excel I can format it as dddd d mmmm yyyy (for
example)
(I want to calculate the date, at three weeks before a date entered for
example).

Hi, when you are doing a mail merge for labels, after you import one data
source, can you import another data source in the same document?  Mindy

I am trying to merge a word 2002 document where I actually do want blank
lines when a merge field is empty.  In older versions of word we use to have
the option to either select or not select "Don't print blank line when data
fields are empty".  In word 2002 I can't find this ...

Renamed a field in the datasource, when in the existing main document &
clicking on "insert a field" icon, the old name of the field appears. There
are macros involved in the document but I don't believe it has anything to do
with merge. Any ideas?

I have Word 2003.  I copied/pasted an Excel range into word as my data file
for a mail merge.  There are over 100 labels I am to print.
When I went through the process of the mail merge it worked...for only 1
page of data...I did not try to print but when I previewed the labels it ...

Hi again, sorry but I have another question that is related to my first
question.  I thought there was a way to delete records before it was imported
into the document but I can't remember how to do it.  Mindy

I would like to insert a blank label so I can type a new address into it and
it will be in the correct alpha order, but I can't figure out how.  Tab does
not work, neither does the enter key.... How do I do this?

I've seen postings on this going back as far as 2002, but never found a
efinitive answer. Microsoft doesn't seem to address this in their
knowledge base, yet this appears to be an old problem. Here's the
scoop...

How do I Turnoff the Mail Mege wizard so that it does not appear everytime I
do a mailmerge.  I do not need the wizard on and prefer to use the icons on
the menu bar but I have been unable to find a way to turn off the Wizard.
My main document is in word and my source data is an ...

Mailmerge keeps changing date format to American format.  I can't get it to
keep to English. ie: 26/01/2005.  
Version 5.1.2600 Service Pack 2 Build 2600.  Microsoft Windows XP Professional

I am using MS-Word 2003 (11.5604.5606) with Excel 2003 (11.5612.5606) to do a
mail merge which includes a date from the spreadsheet.  In previous versions
of Word and Excel, the resultant mail merge file displayed the date in the
format used to display the date in Excel.  In the ...

I have a word document with mailmerge.
The data source is a msquery through system dsn (odbc)
and data are stored in sql server.
The problem is date format:

When I do a mail merge with Word 2003 I have formatting issues with foreign
addresses, especially Japan/Asia addresses.  Word will put the addresses in
upside down.  This is completely frustrating since I have had to do several
mail merges with domestic and oversees addresses ...