We have Microsoft Word 2003 and Outlook 2003.
When I mailmerge for envelopes from an Outlook contact list, the output in Word for any address in the Street field with more than one line shows a square symbol instead of a return character.
Basically from a blank Word 2003 document I select Tools, Letters and Mailings, Mail Merge. I select Envelopes and when I select recipients, I choose "Select from Outlook contacts".
Our Outlook contacts are entered properly using the Address field. The problem is the Street field. If there are two lines of text in the Street field, after the mail merge it is two lines with a square in between.
In other Words, what should covert over as this...
11 Forest Drive
Louisville, KY 63101
Comes over as this...
11 Forest DriveLouisville, KY 63101
Note: The actual symbol is NOT two square brackets but an actual square.
If possible I'd like to write a Word Macro to do a Find and Replace to remove the square and replace with a paragraph mark, but I can't seem to capture the square to do the Find and Replace.
I'm sure I could come up with alternate solutions for this, but this has come up before in other areas when copying from Excel and Notepad too so I'd really like to know how to address it.
Thanks in advance!