Strange square symbol in Word mail merge

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 Drive[]Louisville, 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!
Senniger1Asked:
Who is Participating?
 
GrahamSkanConnect With a Mentor RetiredCommented:
I'm sorry.

That would be in the VBA Immediate window.

Open the VBA editor, by pressing Alt+F11. To show the Immediate pane in the VBA editor, press Crtl+G. There you can abbreviate the type-in:
?AscW(Selection.text)

followed by pressing the Enter key. There should be a response underneath to what was typed.

0
Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

 
Senniger1Author Commented:
Hi Sector5,

Thank you for all your suggestions, but I am really wanting to find out what that box is and how to capture it because this comes up all the time in Excel, etc. even when not doing a mail merge.

It's the box part.  Does this make sense?
0
 
GrahamSkanRetiredCommented:
If you select it and type:

Debug.print AscW(Selection.text)

You should get the character code.

Then you can put the number following a caret in a Find

e.g. Find: ^1234

However, I don't believe that you should be getting the symbol at all. Try these Word troublshooting steps:

http://support.microsoft.com/kb/921541/en-gb
0
 
Senniger1Author Commented:
I am really sorry to have to ask, but if I go into Word 2003, highlight the square, exactly where do I type "Debug.print AscW(Selection.text)"
0
 
Senniger1Author Commented:
That is exactly what I needed.  The character is 10 and now I'm able to following your instructions and use a ^10 to do a Find and Replace.

Thank you so much!
0
 
Senniger1Author Commented:
Extremely please with the information I was given.
0
All Courses

From novice to tech pro — start learning today.