 |
 | 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 / April 2004Address Fields
Any thoughts on creating a mail merge form document for labels consisting of contacts from Outlook and their mailing addresses and including the Company name if it's a business address, but not if it's a home address? Thanks, Cathy If you are merging from Word (as opposed to from Outlook) then you can use the postal address field. You can then add the company field to all records. If this leaves a space, use a conditional field to place the company field ie {IF {Mergefield Company} <> "" "{Mergefield Company} "} (note the line break within the field) If you are merging from Outlook, I think you'll find the field is called MailingAddress  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Any thoughts on creating a mail merge form document for labels > consisting of contacts from Outlook and their mailing addresses and [quoted text clipped - 3 lines] > Thanks, > Cathy Right. Thanks, Graham. My question should have been when merging from Outlook and having selected Mailing Address for the merge field(s), is there a way to have it leave out Company Name and Title when the Mailing Address is the Home Address, but not when the Maling Address is the Business Address? Thanks. > If you are merging from Word (as opposed to from Outlook) then you can use > the postal address field. You can then add the company field to all records. [quoted text clipped - 16 lines] > > Thanks, > > Cathy I had covered that for the Company name by using a conditional field which only inserts the Company name and its following line feed when the Company name has content. You can do the same for the Title field {IF {Mergefield Title} <> "" "{Mergefield Title} "} The problem is going to be when you have a company name but no business address or both a business address and a company name, but you use the home address as the mailing address. A solution might be to make better use of categories. Set up a category to accommodate your odd addresses and incorporate it in your conditional field. Off the top of my head, I don't think there is a field included to indicate which address is used as mailing address - but I may be mistaken. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Right. Thanks, Graham. My question should have been when merging from > Outlook and having selected Mailing Address for the merge field(s), [quoted text clipped - 32 lines] >>> Thanks, >>> Cathy Well, that won't work because it's not an issue of content or not. There may very well be content, but we don't want to send it to Mr. John Smith, President, IBM Corp. at his home. See the dilemma? > I had covered that for the Company name by using a conditional field which > only inserts the Company name and its following line feed when the Company [quoted text clipped - 47 lines] > >>> Thanks, > >>> Cathy The dilemma was anticipated which is why I wrote the last paragraph in my previous reply. I have checked and there does not appear to be an obvious method of discerning whether the postal address is the business address or the home address, so you would have to create a method - categories would do it, but you would have to create a category and use it on the problematic addresses. The alternative would be to have separate merge documents and merge selected records. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Well, that won't work because it's not an issue of content or not. > There may very well be content, but we don't want to send it to Mr. [quoted text clipped - 61 lines] >>>>> Thanks, >>>>> Cathy |
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.