Help!

How do I format a zip code in a mail merge

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Catalog Printing  
Author Message
SV1964
External


Since: Jun 02, 2005
Posts: 2



PostPosted: Thu Jun 02, 2005 6:47 pm    Post subject: How do I format a zip code in a mail merge
Archived from groups: microsoft>public>publisher (more info?)

When using mail merge, how do I format a ZIP Code that starts with 0 (zero)
from an Excel File, so that when it comes into MS Word, it will not display a
0, but the entire ZIP Code (i.e. 02487). When it is merged, it is displayed
as 0, not 02487. I tried changing the format to TEXT, instead of number, but
it does not work. In other words, it doesn't like the leading 0.
Back to top
Brian Kvalheim [MSFT MVP]
External


Since: Jun 02, 2005
Posts: 460



PostPosted: Thu Jun 02, 2005 9:02 pm    Post subject: Re: How do I format a zip code in a mail merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

See if the following kb addresses your issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;320473
--
Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com

This posting is provided "AS IS" with no warranties, and
confers no rights.
"SV1964" wrote in message

> When using mail merge, how do I format a ZIP Code that starts with 0
> (zero)
> from an Excel File, so that when it comes into MS Word, it will not
> display a
> 0, but the entire ZIP Code (i.e. 02487). When it is merged, it is
> displayed
> as 0, not 02487. I tried changing the format to TEXT, instead of number,
> but
> it does not work. In other words, it doesn't like the leading 0.
Back to top
SV1964
External


Since: Jun 02, 2005
Posts: 2



PostPosted: Fri Jun 03, 2005 2:41 pm    Post subject: Re: How do I format a zip code in a mail merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

IT SURE DID......THANKS VERY MUCH FOR YOUR HELP BRIAN !!!!

"Brian Kvalheim [MSFT MVP]" wrote:

> See if the following kb addresses your issue:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;320473
> --
> Brian Kvalheim
> Microsoft Publisher MVP
> http://www.publishermvps.com
>
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
> "SV1964" wrote in message
>
> > When using mail merge, how do I format a ZIP Code that starts with 0
> > (zero)
> > from an Excel File, so that when it comes into MS Word, it will not
> > display a
> > 0, but the entire ZIP Code (i.e. 02487). When it is merged, it is
> > displayed
> > as 0, not 02487. I tried changing the format to TEXT, instead of number,
> > but
> > it does not work. In other words, it doesn't like the leading 0.
>
>
>
Back to top
Karl H
External


Since: Jan 19, 2005
Posts: 37



PostPosted: Mon Sep 04, 2006 3:54 pm    Post subject: Re: How do I format a zip code in a mail merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This doesn't seem to work for a Publisher merge document. Is there a
different technique for those files? Opening a publisher file in Word doesn't
show text that is readable.
Karl

"Brian Kvalheim [MSFT MVP]" wrote:

> See if the following kb addresses your issue:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;320473
> --
> Brian Kvalheim
> Microsoft Publisher MVP
> http://www.publishermvps.com
>
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
> "SV1964" wrote in message
>
> > When using mail merge, how do I format a ZIP Code that starts with 0
> > (zero)
> > from an Excel File, so that when it comes into MS Word, it will not
> > display a
> > 0, but the entire ZIP Code (i.e. 02487). When it is merged, it is
> > displayed
> > as 0, not 02487. I tried changing the format to TEXT, instead of number,
> > but
> > it does not work. In other words, it doesn't like the leading 0.
>
>
>
Back to top
Chuck Davis
External


Since: Feb 25, 2005
Posts: 723



PostPosted: Mon Sep 04, 2006 4:15 pm    Post subject: Re: How do I format a zip code in a mail merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Karl,

In the cell that contains the offending zip code preceed the 02487 with the
single apostrophy, as: '02487 The apostrophy will not print.
"Karl H" wrote in message

> This doesn't seem to work for a Publisher merge document. Is there a
> different technique for those files? Opening a publisher file in Word
> doesn't
> show text that is readable.
> Karl
>
> "Brian Kvalheim [MSFT MVP]" wrote:
>
>> See if the following kb addresses your issue:
>>
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;320473
>> --
>> Brian Kvalheim
>> Microsoft Publisher MVP
>> http://www.publishermvps.com
>>
>> This posting is provided "AS IS" with no warranties, and
>> confers no rights.
>> "SV1964" wrote in message
>>
>> > When using mail merge, how do I format a ZIP Code that starts with 0
>> > (zero)
>> > from an Excel File, so that when it comes into MS Word, it will not
>> > display a
>> > 0, but the entire ZIP Code (i.e. 02487). When it is merged, it is
>> > displayed
>> > as 0, not 02487. I tried changing the format to TEXT, instead of
>> > number,
>> > but
>> > it does not work. In other words, it doesn't like the leading 0.
>>
>>
>>
Back to top
Karl H
External


Since: Jan 19, 2005
Posts: 37



PostPosted: Mon Sep 04, 2006 4:35 pm    Post subject: Re: How do I format a zip code in a mail merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks for responding, Chuck.
My problem is a little different...& maybe I responded in the wrong thread,
but I am not having a problem with the leading zero not printing, but rather
gettting MS Publisher to pick up the format from Zip + 4 and bring it into
Publisher retaining that format. It eliminates the hyphen.

Karl

"Chuck Davis" wrote:

> Karl,
>
> In the cell that contains the offending zip code preceed the 02487 with the
> single apostrophy, as: '02487 The apostrophy will not print.
> "Karl H" wrote in message
>
> > This doesn't seem to work for a Publisher merge document. Is there a
> > different technique for those files? Opening a publisher file in Word
> > doesn't
> > show text that is readable.
> > Karl
> >
> > "Brian Kvalheim [MSFT MVP]" wrote:
> >
> >> See if the following kb addresses your issue:
> >>
> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;320473
> >> --
> >> Brian Kvalheim
> >> Microsoft Publisher MVP
> >> http://www.publishermvps.com
> >>
> >> This posting is provided "AS IS" with no warranties, and
> >> confers no rights.
> >> "SV1964" wrote in message
> >>
> >> > When using mail merge, how do I format a ZIP Code that starts with 0
> >> > (zero)
> >> > from an Excel File, so that when it comes into MS Word, it will not
> >> > display a
> >> > 0, but the entire ZIP Code (i.e. 02487). When it is merged, it is
> >> > displayed
> >> > as 0, not 02487. I tried changing the format to TEXT, instead of
> >> > number,
> >> > but
> >> > it does not work. In other words, it doesn't like the leading 0.
> >>
> >>
> >>
>
>
>
Back to top
Amanda
External


Since: Jan 05, 2007
Posts: 2



PostPosted: Fri Jan 05, 2007 1:30 pm    Post subject: Re: How do I format a zip code in a mail merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I need to know how to get the 9 digit zip to merge in publisher. ZIP field
is picking up a 5 digit zip but not the 9 digit zip. it is putting a 0 in
the merge result. Can you help?

"Karl H" wrote:

> Thanks for responding, Chuck.
> My problem is a little different...& maybe I responded in the wrong thread,
> but I am not having a problem with the leading zero not printing, but rather
> gettting MS Publisher to pick up the format from Zip + 4 and bring it into
> Publisher retaining that format. It eliminates the hyphen.
>
> Karl
>
> "Chuck Davis" wrote:
>
> > Karl,
> >
> > In the cell that contains the offending zip code preceed the 02487 with the
> > single apostrophy, as: '02487 The apostrophy will not print.
> > "Karl H" wrote in message
> >
> > > This doesn't seem to work for a Publisher merge document. Is there a
> > > different technique for those files? Opening a publisher file in Word
> > > doesn't
> > > show text that is readable.
> > > Karl
> > >
> > > "Brian Kvalheim [MSFT MVP]" wrote:
> > >
> > >> See if the following kb addresses your issue:
> > >>
> > >> http://support.microsoft.com/default.aspx?scid=kb;en-us;320473
> > >> --
> > >> Brian Kvalheim
> > >> Microsoft Publisher MVP
> > >> http://www.publishermvps.com
> > >>
> > >> This posting is provided "AS IS" with no warranties, and
> > >> confers no rights.
> > >> "SV1964" wrote in message
> > >>
> > >> > When using mail merge, how do I format a ZIP Code that starts with 0
> > >> > (zero)
> > >> > from an Excel File, so that when it comes into MS Word, it will not
> > >> > display a
> > >> > 0, but the entire ZIP Code (i.e. 02487). When it is merged, it is
> > >> > displayed
> > >> > as 0, not 02487. I tried changing the format to TEXT, instead of
> > >> > number,
> > >> > but
> > >> > it does not work. In other words, it doesn't like the leading 0.
> > >>
> > >>
> > >>
> >
> >
> >
Back to top
Mary Sauer
External


Since: Mar 25, 2006
Posts: 3845



PostPosted: Fri Jan 05, 2007 5:12 pm    Post subject: Re: How do I format a zip code in a mail merge [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Format the zip code field as text.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Amanda" wrote in message

>I need to know how to get the 9 digit zip to merge in publisher. ZIP field
> is picking up a 5 digit zip but not the 9 digit zip. it is putting a 0 in
> the merge result. Can you help?
>
> "Karl H" wrote:
>
>> Thanks for responding, Chuck.
>> My problem is a little different...& maybe I responded in the wrong thread,
>> but I am not having a problem with the leading zero not printing, but rather
>> gettting MS Publisher to pick up the format from Zip + 4 and bring it into
>> Publisher retaining that format. It eliminates the hyphen.
>>
>> Karl
>>
>> "Chuck Davis" wrote:
>>
>> > Karl,
>> >
>> > In the cell that contains the offending zip code preceed the 02487 with the
>> > single apostrophy, as: '02487 The apostrophy will not print.
>> > "Karl H" wrote in message
>> >
>> > > This doesn't seem to work for a Publisher merge document. Is there a
>> > > different technique for those files? Opening a publisher file in Word
>> > > doesn't
>> > > show text that is readable.
>> > > Karl
>> > >
>> > > "Brian Kvalheim [MSFT MVP]" wrote:
>> > >
>> > >> See if the following kb addresses your issue:
>> > >>
>> > >> http://support.microsoft.com/default.aspx?scid=kb;en-us;320473
>> > >> --
>> > >> Brian Kvalheim
>> > >> Microsoft Publisher MVP
>> > >> http://www.publishermvps.com
>> > >>
>> > >> This posting is provided "AS IS" with no warranties, and
>> > >> confers no rights.
>> > >> "SV1964" wrote in message
>> > >>
>> > >> > When using mail merge, how do I format a ZIP Code that starts with 0
>> > >> > (zero)
>> > >> > from an Excel File, so that when it comes into MS Word, it will not
>> > >> > display a
>> > >> > 0, but the entire ZIP Code (i.e. 02487). When it is merged, it is
>> > >> > displayed
>> > >> > as 0, not 02487. I tried changing the format to TEXT, instead of
>> > >> > number,
>> > >> > but
>> > >> > it does not work. In other words, it doesn't like the leading 0.
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum