Mail Merge formating zip code

Tutorials Win: Microsoft Windows Forum

This is a multi-part message in MIME format.

------=_NextPart_000_0034_01C3A3A7.7E733050
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am working on a Mail Merge where the data source originates from a =
different data base. and is imported into excel. If I do the Mail Merge =
from word. I believe it looks for the original formatting from the data =
that was shipped and therefore defaults to 7754 rather than 07754 taken =
from the cell format in excel.

Is there an easy fix for what I am trying to due, or should I Alt+F9 and =
format it for a Zip code. I will also need to know what that is.

Thanks

Matt
------=_NextPart_000_0034_01C3A3A7.7E733050
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>I am working on a Mail Merge where the data source originates from =
a=20
different data base.&nbsp;and is&nbsp;imported into excel. If I do the =
Mail=20
Merge from word. I believe it looks for the original formatting from the =
data=20
that was shipped and therefore defaults&nbsp; to 7754 rather than 07754 =
taken=20
from &nbsp;the cell format&nbsp;in excel.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Is there an easy fix for what I am trying to due, or should I =
Alt+F9 and=20
format it for a Zip code. I will also need to know what that is.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks</DIV>
<DIV><BR>Matt </DIV></BODY></HTML>

------=_NextPart_000_0034_01C3A3A7.7E733050--
Top

Re: Mail Merge formating zip code by Doug

Doug
Wed Nov 05 23:20:03 CST 2003

Hi Matt,

You can use a query in the database to format it, or in the mailmerge
maindocument, put the mergefield inside the following field construction

{ IF { MERGEFIELD Zipcode } > "99999" "{ MERGEFIELD Zipcode \#
"00000'-'0000" }" "{ MERGEFIELD Zipcode \# "00000" }-0000 }

That will handle both 5 and 9 digit zipcodes, appending a -0000 to the 5
digit ones.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"matt" <paramunch@hotmail.com> wrote in message
news:uDOXrF9oDHA.2064@TK2MSFTNGP11.phx.gbl...
I am working on a Mail Merge where the data source originates from a
different data base. and is imported into excel. If I do the Mail Merge from
word. I believe it looks for the original formatting from the data that was
shipped and therefore defaults to 7754 rather than 07754 taken from the
cell format in excel.

Is there an easy fix for what I am trying to due, or should I Alt+F9 and
format it for a Zip code. I will also need to know what that is.

Thanks

Matt


Top