 |
 | 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 / Outlook / Contacts / June 2006Mail Merge Company Name with Business Address Only
The mailing addresses in my contacts are a mix of home and business addresses. I want to do a mail merge that includes the company name only when the business address is the mailing address. Using Outllook 2003 SP2. Is this easy and I've just missed it? Doable with coding or 3rd party tool? Thanks in advance! Not easy to do. This is a Word question, not an Outlook question. Post there on instructions for how to construct a merge using fields that will be populated conditionally, suppress blank lines if a field is empty, etc.  SignatureRuss Valentine [MVP-Outlook] > The mailing addresses in my contacts are a mix of home and business > addresses. I want to do a mail merge that includes the company name only [quoted text clipped - 4 lines] > in > advance! I'm sorry, I must be missing something, or perhaps I didn't make the problem clear. I've never seen merge fields that tell me whether the "Mailing Address" is Business or Home, and of course many contacts have both. So what condition(s) would I check for? The absence or presence of the Company Name does not tell me which is the mailing address. > Not easy to do. This is a Word question, not an Outlook question. Post there > on instructions for how to construct a merge using fields that will be [quoted text clipped - 7 lines] > > in > > advance! My suggestion remains unchanged. You are not asking Outlook questions here. What you specify as the mailing address in Outlook is of no consequence when it comes to constructing the complex merge you described. The Mailing Address is a derived field in Outlook. You would not use a derived field for a merge in Word under the circumstances you require. You would use the individual address elements which comprise them. And you would need to set the conditions for which field is used and what to do if that field is not populated--all Word questions. SignatureRuss Valentine [MVP-Outlook] > I'm sorry, I must be missing something, or perhaps I didn't make the > problem [quoted text clipped - 20 lines] >> > in >> > advance! Sorry if I'm persisting too much, but I still think there's an Outlook issue here: How does Outlook expose the value in the contacts checkbox "This is the mailing address?" The closest I can find is "Mailng Address Indicator" - but it always comes up blank. Without the information in that checkbox, no condition can be tested, and I've simply never seen it in either an export or a Merge Field list. Thanks for your patience! > My suggestion remains unchanged. You are not asking Outlook questions here. > What you specify as the mailing address in Outlook is of no consequence when [quoted text clipped - 28 lines] > >> > in > >> > advance! When you start a merge from Outlook, then Outlook's fields will be available to you for a simple merge, including its derived fields such as "Mailing Address." However, if you described accurately what you wanted to do, that would not serve your needs. You described a complex merge based on conditions (note your phrase "only when" in your post). That's a much tougher nut to crack. You must use Word's "Insert Word Field" function which will permit conditional merges and construct your merge layout very carefully so you can suppress blank lines when a field is not populated. There are not Outlook questions. Read Word's Help pages. Read Word's KB. Post in a Word group to see if anyone there knows how to do this. SignatureRuss Valentine [MVP-Outlook] > Sorry if I'm persisting too much, but I still think there's an Outlook > issue [quoted text clipped - 48 lines] >> >> > in >> >> > advance! |
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
|
©2009 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.