The reason I did that is because without it, I get an extra hard return
before my data result and if I delete the hard return, the data result
is deleted as well.
Peter Jamieson Wrote:

I am trying to merge from Excel into Word.  One of the columns contains date
format data which is generated by a forumal.  The same column also contains
some records which return "N/A" and is in text format, manually imputted.
The merge instruction within Word is:

I don't seem to be able to merge to e-mail.  We use Lotus Notes (uggh).
Everything is set up as it should be.
Can anyone please suggest a fix?

Word 2002 SP3
I copied from IE6 a picture for testing in a document with the following
HYPERLINK:
{ HYPERLINK

My data source is an Excel spreadsheet and there are blank fields.  How do I
tell it skip the field, not print a 0 (zero) move to next field?

I am trying to create a mail merge directory in Word 2002 from an access data
source. I didn't like the templates available in word, so I stuck out on my
own. I made a table with the headings desired. In the first row, I placed in
the merge fields. On the second row, I entered ...

I'm using a spreadsheet as my data source and I want put information from
each row onto one merged document. Can anyone tell me how to do this?

I have a .csv file that I use as my datasource for my MailMerge.  We recently
got upgraded from Word '97 to 2000.  In my text file I have a date fields
i.e.....
01-01-2005.  When I merge my text file in Word it puts a datestamp on this

I'm using Word 2003. My data source is an Oracle database.  My SQL
statement looks like this:
{MERGEFIELD {DATABASE  \d “c:\\mydatasource.odc” \c “connection string”
\s “SELECT \“TITLE\” FROM \“TABLE_NAME\” WHERE ((\“ID\” =

I am using the 'if.. then ...else' to put values into the word letter. Works
fine when the value is there, but it also puts the value in when the
condition is not true??
Also I would like to next this capability I have 10 codes to replace with

Hiya,
I'm trying to do a mailmerge from within Word (from Outlook isn't an open as
we use a document management system).
I have two people's contact lists in my Outlook view, I have permission as a

can someone help me, I have collated a mail merge directory via word, tools
mail merge etc, but unable to print it out on a sheet of paper and not as
labels.  I am using windows xp microsoft office 2003

I have a Word VB script and template .doc file that works fine
with Word 97 & Word 2000, but not with Word 2003. I am running Windows
XP SP1. Word 2003 is version 11.6359.6408 SP1
I get:

The UK post office now has Smart Stamp, Microsoft should add this to their
electronic postage feature (basically the same as US solution) for a fully
integrated solution for the UK.
This would same myself and a lot of other users hassle when printing

I have an access database that uses a module to call word to do a merge.
When i call the merge the datasource is not pulling up.  This worked fine in
2002 and previous versions of Word and Access.  Now it wants me to map the
fields out every time even though I have gone in and ...