Mail Merge Zip+4

R

ReneeB

Hello,

I need to do a mail merge on the back of a postcard. The only pt that's
giving me a problem is adding the +4 of the zipcode at the end. How do I do
so without cutting and pasting the +4 at the end of the zipcode field? All
suggestions are appreciated. :)

Note: I am using Publisher 2003 & the +4 is in a separate field in the
excel spreadsheet that holds the addresses.
 
M

Mary Sauer

Not sure what the problem is, when you insert the zip code aren't the four other
numbers available to insert from your data? Insert the zip code, space, insert
the four numbers. This should work unless the four numbers aren't part of the
Excel address list.
 
R

ReneeB

The four digit extention is available, but when I select Address Block as my
insertion for the merge, that extension isn't one of the options in the pull
down menu. If I add it directly after my address block, will it interfere
with the flow of my next record?
 
R

ReneeB

I Got It! Thank you for your help. :)

ReneeB said:
The four digit extention is available, but when I select Address Block as my
insertion for the merge, that extension isn't one of the options in the pull
down menu. If I add it directly after my address block, will it interfere
with the flow of my next record?
Click to expand...
 
I

iammsk

mail merge from excel, excel shows 07701 (all my zip codes are in new
jersey), but they come into msword mail merge without the first 0 -- what
should i do?
 
Top