![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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 |
#3
|
|||
|
|||
![]()
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 |
#5
|
|||
|
|||
![]()
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 |
#6
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Global address list does not appear in mail merge | Gaspar[_2_] | Outlook - General Queries | 0 | January 17th 08 03:10 PM |
How do I merge two contact files, not mail merge | Butch[_2_] | Outlook - Using Contacts | 3 | September 20th 07 04:24 PM |
Mail Merge Wizard does not enable Merge button | Flower Gardener | Outlook - General Queries | 0 | March 10th 07 04:43 AM |
Outlook 2003 Mail Merge address book help | Steve L | Outlook - General Queries | 4 | December 10th 06 04:51 PM |
Mail Merge Company Name with Business Address Only | Heliotrope | Outlook - Using Contacts | 5 | June 5th 06 11:12 PM |