Mail Merge on Word 2004 for Mac

[sym b]

I'm merging data from an Excel Worksheet on to a Word document. The first
line of the address needs to have <Title> <Firstname> <Surname> (with a space
in between each entry) but the Excel Worksheet does not always have an entry
in the title or first name field.

I simply can't work out how to use the rules to ensure that I don't get a
space where there is no data to show. For example, if there is no title in
the data, I currently see a space and then the firstname at the start of the
address.

I've tried a few suggested actions that I've found on-line but my version of
word doesn't seem to display the { } symbols that make things happen!

HELP

 

[John McGhie]

Here's a reference to one of our oldest articles (because this is one of our
oldest problems... ) This stuff is not very intuitive.

You need to surround the fields with IF statements that test the values of
the fields.

Hope this helps


On 11/03/10 8:24 AM, in article
(e-mail address removed), "sym b" <sym

I'm merging data from an Excel Worksheet on to a Word document. The first
line of the address needs to have <Title> <Firstname> <Surname> (with a space
in between each entry) but the Excel Worksheet does not always have an entry
in the title or first name field.

I simply can't work out how to use the rules to ensure that I don't get a
space where there is no data to show. For example, if there is no title in
the data, I currently see a space and then the firstname at the start of the
address.

I've tried a few suggested actions that I've found on-line but my version of
word doesn't seem to display the { } symbols that make things happen!

HELP

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

 

[Peter Jamieson]

I've tried a few suggested actions that I've found on-line but my
version of

word doesn't seem to display the { } symbols that make things happen!

The keys can be different in Mac Word for one reason and another:

http://word.mvps.org/mac/fieldsinmacword.html

may help.

You can use

{ IF "{ MERGEFIELD Title }" <> "" "{ MERGEFIELD Title } "
}{ IF "{ MERGEFIELD Firstname }" <> "" "{ MERGEFIELD Firstname } " }


Peter Jamieson

http://tips.pjmsn.me.uk