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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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
GrahamSkanRetiredCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.