|
|
Physical Address and Mail Merge
I notice a problem in Outlook 2003 where when multiple lines are entered for
the street address, Word 2003 messes up the merge. I would have something like this: Street: XYZ Office 555 XYZ Street City: Anytown State: MD Zip: 55555 On the address field in the contact "card" it looks like this (as expected): XYZ Office 555 XYZ Street Anytown, MD 55555 However, when mail merged, Word gets confused and does this: Name XYZ Office 555 XYZ Street Anytown, MD 55555 Is there a workaround?? Thanks!! The address "looks" correct in the |
Physical Address and Mail Merge
Construct your merge correctly.
-- Russ Valentine [MVP-Outlook] "Levi" wrote in message ... I notice a problem in Outlook 2003 where when multiple lines are entered for the street address, Word 2003 messes up the merge. I would have something like this: Street: XYZ Office 555 XYZ Street City: Anytown State: MD Zip: 55555 On the address field in the contact "card" it looks like this (as expected): XYZ Office 555 XYZ Street Anytown, MD 55555 However, when mail merged, Word gets confused and does this: Name XYZ Office 555 XYZ Street Anytown, MD 55555 Is there a workaround?? Thanks!! The address "looks" correct in the |
Physical Address and Mail Merge
I think I've tried everything I can think of in the merge to correct the
problem. However, all addresses with two or more lines end up with an additional return after the last line of the "street". Perhaps you might have an idea where I would be screwing it up?? What confuses me is that the street address ends up in a single field when contacts are exported to a file. Can they be entered into separate fields...ie, BusinessStreet, BusinessStreet2, BusinessStreet3? Thanks! "Russ Valentine [MVP-Outlook]" wrote: Construct your merge correctly. -- Russ Valentine [MVP-Outlook] "Levi" wrote in message ... I notice a problem in Outlook 2003 where when multiple lines are entered for the street address, Word 2003 messes up the merge. I would have something like this: Street: XYZ Office 555 XYZ Street City: Anytown State: MD Zip: 55555 On the address field in the contact "card" it looks like this (as expected): XYZ Office 555 XYZ Street Anytown, MD 55555 However, when mail merged, Word gets confused and does this: Name XYZ Office 555 XYZ Street Anytown, MD 55555 Is there a workaround?? Thanks!! The address "looks" correct in the |
Physical Address and Mail Merge
Thanks for the help! I can get it to work now with a manual address block,
but I'm afraid others would have the same problem with our global contact list. I wonder if there is a way to get this to work with the address block option... The "Street_Address" field looks like this in the Word "select recipients box" when the merge is made from Outlook: XYZ Office[][]555 XYZ Street[][] not with brackets but squares.....a return I assume.... There are no extra returns after the second line in Outlook. A single line address would look like this: 555 XYZ Street "Diane Poremsky [MVP]" wrote: if you use the individual address parts and tell word to ignore blank lines, it will. don't use the address block option. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: "Levi" wrote in message ... I think I've tried everything I can think of in the merge to correct the problem. However, all addresses with two or more lines end up with an additional return after the last line of the "street". Perhaps you might have an idea where I would be screwing it up?? What confuses me is that the street address ends up in a single field when contacts are exported to a file. Can they be entered into separate fields...ie, BusinessStreet, BusinessStreet2, BusinessStreet3? Thanks! "Russ Valentine [MVP-Outlook]" wrote: Construct your merge correctly. -- Russ Valentine [MVP-Outlook] "Levi" wrote in message ... I notice a problem in Outlook 2003 where when multiple lines are entered for the street address, Word 2003 messes up the merge. I would have something like this: Street: XYZ Office 555 XYZ Street City: Anytown State: MD Zip: 55555 On the address field in the contact "card" it looks like this (as expected): XYZ Office 555 XYZ Street Anytown, MD 55555 However, when mail merged, Word gets confused and does this: Name XYZ Office 555 XYZ Street Anytown, MD 55555 Is there a workaround?? Thanks!! The address "looks" correct in the |
Physical Address and Mail Merge
Word is not confused. Word only does what you tell it to. You must provide
accurate instructions for Word. Never use a pre-determined address block. Use the individual address elements as the merge fields and use the appropriate codes to suppress blank lines. You will find all of those instructions in Word or on Word sites: http://www.slipstick.com/contacts/insword.htm http://support.microsoft.com/default...;en-us;q134901 http://www.gmayor.com/Macrobutton.htm -- Russ Valentine [MVP-Outlook] "Levi" wrote in message ... I think I've tried everything I can think of in the merge to correct the problem. However, all addresses with two or more lines end up with an additional return after the last line of the "street". Perhaps you might have an idea where I would be screwing it up?? What confuses me is that the street address ends up in a single field when contacts are exported to a file. Can they be entered into separate fields...ie, BusinessStreet, BusinessStreet2, BusinessStreet3? Thanks! "Russ Valentine [MVP-Outlook]" wrote: Construct your merge correctly. -- Russ Valentine [MVP-Outlook] "Levi" wrote in message ... I notice a problem in Outlook 2003 where when multiple lines are entered for the street address, Word 2003 messes up the merge. I would have something like this: Street: XYZ Office 555 XYZ Street City: Anytown State: MD Zip: 55555 On the address field in the contact "card" it looks like this (as expected): XYZ Office 555 XYZ Street Anytown, MD 55555 However, when mail merged, Word gets confused and does this: Name XYZ Office 555 XYZ Street Anytown, MD 55555 Is there a workaround?? Thanks!! The address "looks" correct in the |
| All times are GMT +1. The time now is 08:01 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com