I'm having an issue when merging addresses from Excel to Microsoft Word. A zip codes that starts with the number 0 will not show up on the mail merge. For example of 08701 will show up as 8701.In the Excel sheet I tried to right-click the table and click on zip code but it did not help me
I know this is really old and you found a solution. I had the same issue recently this fixed it for me
Or put an apostrophe before the zip code (in excel) to force it to format as text
Not if you are pasting
Then you could sort, add a formula column that concats apostrophe with the value in the column, copy and paste values back to the original column.Or format it as text and hope it doesn't get switched back but in my experiences sometimes it does and then you have to re-add all the zeroes
I am trying to do a mail merge, I am using "custom" size for envelopes. On the preview everything looks good and centered but when I actually print th envelopes the addresses are coming out towards the left. Please help. Thanks!