 |
 | 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 / May 2007Greeting Line Problems in Word 2007
I am doing a small mail merge using a word doc and an excel spreadsheet as my data source. The first and last names are separate columns in the spreadsheet. When I create the address block, it properly aligns the first and last name. When I try to to the greeting line, I specify the foramt as Dear Mr. 'Lastname' but word refuses to just use the last name. It will constantly overwrite it with first and last name. I don't understand why when the data fields for first and last name are separate. Any help please? If you press Alt+F9 to toggle on the display of the field codes in the mailmerge main document, what do you see?  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP >I am doing a small mail merge using a word doc and an excel spreadsheet as >my [quoted text clipped - 7 lines] > when the data fields for first and last name are separate. Any help > please? {GREETINGLINE\f"<<BEFORE_Dear>><<TITLE0_>><<_LAST_>> <<_AFTER_,>>"\1 1033 \e Dear Sir or Madam,"} I would assume I just remove the <<_LAST_>> to fix it? Question is, why is it putting it in there in the first place. Also, when I choose to use just the last name and not the first, it works fine. I think maybe something that needs to be fixed by MS? > If you press Alt+F9 to toggle on the display of the field codes in the > mailmerge main document, what do you see? [quoted text clipped - 10 lines] > > when the data fields for first and last name are separate. Any help > > please? Strike my comment about remove the "<<_LAST_>>" from there. > {GREETINGLINE\f"<<BEFORE_Dear>><<TITLE0_>><<_LAST_>> <<_AFTER_,>>"\1 1033 \e > Dear Sir or Madam,"} [quoted text clipped - 18 lines] > > > when the data fields for first and last name are separate. Any help > > > please? Don't use the GREETING LINE thing, or the ADDRESSBLOCK for that matter. Just insert the merge fields that YOU want in the configuration that YOU want them. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Strike my comment about remove the "<<_LAST_>>" from there. > [quoted text clipped - 28 lines] >> > > when the data fields for first and last name are separate. Any help >> > > please? Doesn't make much sense not to use a feature Microsoft inteneded to make life easier but anyway.... The reason why it is not working is because word had no way of determining if the addressee was a Mr. or a Mrs. Once I added a field for Gender and matched it to the Courtesy Title, it worked just fine. Thanks for the help! > Don't use the GREETING LINE thing, or the ADDRESSBLOCK for that matter. > Just insert the merge fields that YOU want in the configuration that YOU [quoted text clipped - 32 lines] > >> > > when the data fields for first and last name are separate. Any help > >> > > please? You will find the recommendation not to use the AddressBlock is given very frequently in this newsgroup. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Doesn't make much sense not to use a feature Microsoft inteneded to make > life [quoted text clipped - 49 lines] >> >> > > help >> >> > > please?
|
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.