 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2007how 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...... 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.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > 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...... 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"} Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Don't use the addressblock field. > Do you have separate fields that contain FirstName, LastName, Suffix, [quoted text clipped - 17 lines] >> have tried selecting the fields and not using address but I must not >> be doing it right...... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.