Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how do create diff address and greeting
how can i address a letter to "John Smith, MD" and and create a greeting for
"Dear Dr. Smith:". I can not make the 2 things happen at the same time, I can make either one happen but not both. I am mergeing from access and I have all the fields set up to do this. I have tried selecting the fields and not using address but I must not be doing it right...... |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how do create diff address and greeting
Don't use the addressblock field.
Do you have separate fields that contain FirstName, LastName, Suffix, and Salutation? If not you cannot derive them using parts of fields. You *may* be able to derive them using conditional fields, but much depends on what information is in your data records. If you have the full information, it is simply a matter of inserting the correct fields eg {Mergefield FirstName} {Mergefield LastName}{If {Mergefield Suffix} "" ", {Mergefield Suffix}"} and Dear {IF {Mergefield Title} "" "{Mergefield Title} {Mergefield LastName}" "Sir/Madam"} All brackets {} are inserted with CTRL+F9 and the fieldnames must be exactly the names in your data file. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Ellen wrote: how can i address a letter to "John Smith, MD" and and create a greeting for "Dear Dr. Smith:". I can not make the 2 things happen at the same time, I can make either one happen but not both. I am mergeing from access and I have all the fields set up to do this. I have tried selecting the fields and not using address but I must not be doing it right...... |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
how do create diff address and greeting
Oops! I have used Title and Salutation to convey the same thing. The second
example should have read Dear {IF {Mergefield Salutation} "" "{Mergefield Salutation} {Mergefield LastName}" "Sir/Madam"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Graham Mayor wrote: Don't use the addressblock field. Do you have separate fields that contain FirstName, LastName, Suffix, and Salutation? If not you cannot derive them using parts of fields. You *may* be able to derive them using conditional fields, but much depends on what information is in your data records. If you have the full information, it is simply a matter of inserting the correct fields eg {Mergefield FirstName} {Mergefield LastName}{If {Mergefield Suffix} "" ", {Mergefield Suffix}"} and Dear {IF {Mergefield Title} "" "{Mergefield Title} {Mergefield LastName}" "Sir/Madam"} All brackets {} are inserted with CTRL+F9 and the fieldnames must be exactly the names in your data file. Ellen wrote: how can i address a letter to "John Smith, MD" and and create a greeting for "Dear Dr. Smith:". I can not make the 2 things happen at the same time, I can make either one happen but not both. I am mergeing from access and I have all the fields set up to do this. I have tried selecting the fields and not using address but I must not be doing it right...... |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I create greeting cards in word | Microsoft Word Help | |||
Mail merge, how can I set dif. case for address block &greeting | Mailmerge | |||
How to create a template to type avery labels; diff on each label | New Users | |||
HOW DO I REMOVE ADDED GREETING FROM AN ENVELOPE RETURN ADDRESS | Microsoft Word Help | |||
How do I create a digital photo greeting card? | Microsoft Word Help |