Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mailmerge
how does one insert a comma that will print between the lastname and suffix
fields in a mailmerge; eg John Jones, B.Sc.? I'm using Word and Excel for the database. all other functions are OK, including a coma between fields for city and state, eg Syracuse, New York. I can't get the comma to print between last name and suffix. |
#2
|
|||
|
|||
You should start a new thread for a new topic, however what you need here is
a conditional field. {Mergefield LastName}{IF {Mergefield Suffix} "" ", {Mergefield Suffix}"} should do the trick (change the field names to reflect your data). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org CHES wrote: how does one insert a comma that will print between the lastname and suffix fields in a mailmerge; eg John Jones, B.Sc.? I'm using Word and Excel for the database. all other functions are OK, including a coma between fields for city and state, eg Syracuse, New York. I can't get the comma to print between last name and suffix. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get multiple Access records into a single mailmerge lett. | Mailmerge | |||
How to update envelop mailmerge input from outlook | Mailmerge | |||
Using MAILMERGE fields within HYPERLINK fields for Merge to Email | Mailmerge | |||
mailmerge wizard locator | Mailmerge | |||
Mailmerge from EXCEL, custom format problem | Mailmerge |