Substituting one field for another

K

Kathleen Badeaux

We are trying to personalize a mail merge and I was
wondering if either is possible.

To have a field on the salutation line that would prompt
you to enter a name on each letter without changing all
the merged letters to reflect the same name.

or

Have two fields in the salutation line and if field a is
empty then to automatically enter field b in its place.
 
G

Graham Mayor

Your second proposal is by far the more elegant solution of the two. You can
use a conditional field construction, which you must enter by hand,
substituting your own fieldnames and using CTRL+F9 to set the field boundary
pairs.

{IF{Mergefield Field1} <> "" "{Mergefield Field1}" "{Mergefield Field2}"}


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
K

Koji Kanazawa

Did you ever get an answer
I'd like to insert a field into MS Outlook contacts so that we can enter a salutation
Then when we do a mail merge - can pick up from there rather than first or last name

----- Kathleen Badeaux wrote: ----

We are trying to personalize a mail merge and I was
wondering if either is possible

To have a field on the salutation line that would prompt
you to enter a name on each letter without changing all
the merged letters to reflect the same name

or

Have two fields in the salutation line and if field a is
empty then to automatically enter field b in its place
 
G

Graham Mayor

You can certainly create custom fields in Outlook and if you initiate the
merge from Outlook, the fields will be available to your merge.
If you don't know how to create custom fields in Outlook, please continue
this in an Outlook newsgroup.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top