Senniger1
asked on
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!
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!
ASKER
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?
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?
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
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
ASKER
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)"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
Thank you so much!
ASKER
Extremely please with the information I was given.
Have alook at this:
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
http://www.gmayor.com/mailmerge_from_outlook.htm