Labels and zipcodes

captpicky

New Member
Joined
Dec 1, 2005
Messages
3
When I try and merge my spreadsheet into Word to create mailing labels, i have a problem with the zip code. When i merge the field shows up with a M_66061. I cant get rid of the M_ I have tried different formats including text and zip code
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Where is the "M_" coming from? Is it in the Excel file along with the zipcode number?
 

captpicky

New Member
Joined
Dec 1, 2005
Messages
3
The "M_" dosen't show up in the excel cell but when i mail merge it into word..it shows up as part of zip code.
 

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
Then in your Word document you have some stray characters. From menu go to:

Tools / Options

In the Options pane, choose the View tab. Enable all the various hidden codes so that you see exactly what is in the document. Once you've corrected the problem, go back & restore the normal state.
 

captpicky

New Member
Joined
Dec 1, 2005
Messages
3
still having problems...word will not even import the zip code. It shows up in the merge window that you use to select what fields you want to merge, but then nothing shows up in the final product.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,915
Messages
5,575,018
Members
412,634
Latest member
Sumanmathew
Top