Mail merge word/excel 2003

[dkotschess]

I didn't have any luck on this on some other groups, so I'm re-trying
here:


I have an issue occuring with word and excel 2003 that did not seem to
happen with office 2000. It appears possibly buggy, but we're not sure
at thispoint.

When doing a mail merge, the excel document is formatted so that
certain cells are in zip code format. It appears to look as it should.
But when importing the information into the mail merge document, the
formatting of the column gets lost. Sometimes 0's are dropped off.How
can we save the formatting of the zip code field so that it will not
be lost when imported into the merge document?

Thanks,

-DaveK

 

[Tom Porterfield]

I didn't have any luck on this on some other groups, so I'm re-trying
here:


I have an issue occuring with word and excel 2003 that did not seem to
happen with office 2000. It appears possibly buggy, but we're not sure
at thispoint.

When doing a mail merge, the excel document is formatted so that
certain cells are in zip code format. It appears to look as it should.
But when importing the information into the mail merge document, the
formatting of the column gets lost. Sometimes 0's are dropped off.How
can we save the formatting of the zip code field so that it will not
be lost when imported into the merge document?

You might try posting this in one of the office groups. My guess would be
that Excel is treating the cells that contain the zip is numeric types. And
while you can format a number to display leading zeros within Excel, the
underlying type is still numeric and numbers do not get stored with leading
zeros. The correct thing to do would be to modify the cells in Excel to
store the data as string rather than numbers.
--
Tom Porterfield
MS-MVP Windows
http://support.telop.org

Please post all follow-ups to the newsgroup only.

 

[Jim Macklin]

Try an Office newsgroup
|I didn't have any luck on this on some other groups, so I'm
re-trying
| here:
|
|
| I have an issue occuring with word and excel 2003 that did
not seem to
| happen with office 2000. It appears possibly buggy, but
we're not sure
| at thispoint.
|
| When doing a mail merge, the excel document is formatted
so that
| certain cells are in zip code format. It appears to look
as it should.
| But when importing the information into the mail merge
document, the
| formatting of the column gets lost. Sometimes 0's are
dropped off.How
| can we save the formatting of the zip code field so that
it will not
| be lost when imported into the merge document?
|
| Thanks,
|
| -DaveK
|

 

[dkotschess]

The "other groups" I referred to were office groups .

Specifically "Microsoft Office 2003" (actually a google group) and
"microsoft.public.office."

There are still quite a few groups out there, so if anyone knows of a
more appropriate one please let me know. I posted to these first and
had no replies whatever.

 

[Jim Macklin]

Replies are not mandatory since these groups are strictly
volunteer-based.
To increase your chances of getting a reply you should
clearly state your problem, state what you have tried and
the result.
A description of your hardware and software profile is
useful, including names and version numbers.

Then it can take 24-48 hours before you will get a reply
because not everybody checks the groups hourly or even
daily. The choice of your subject line is important because
the person who knows the answer may never see your question
if the subject line is poorly written or insulting.

There are several ways to do mail merge. Some people think
mail merge is just making mailings with names and addresses
in the letter and on the envelope or label. Others want to
have customized letters with altered content, depending on
criteria in the letter or address.
Here is what Google returned
"Results 1 - 10 of about 53,200 English pages for Mail merge
word/excel"


--
The people think the Constitution protects their rights;
But government sees it as an obstacle to be overcome.


| The "other groups" I referred to were office groups .
|
| Specifically "Microsoft Office 2003" (actually a google
group) and
| "microsoft.public.office."
|
| There are still quite a few groups out there, so if anyone
knows of a
| more appropriate one please let me know. I posted to
these first and
| had no replies whatever.
|

 

[dkotschess]

Replies are not mandatory since these groups are strictly
volunteer-based.

I know of no-one who believes otherwise.

To increase your chances of getting a reply you should
clearly state your problem, state what you have tried and
the result.
A description of your hardware and software profile is
useful, including names and version numbers.

Then it can take 24-48 hours before you will get a reply
because not everybody checks the groups hourly or even
daily. The choice of your subject line is important because
the person who knows the answer may never see your question
if the subject line is poorly written or insulting.

Also a given.

There are several ways to do mail merge. Some people think
mail merge is just making mailings with names and addresses
in the letter and on the envelope or label. Others want to
have customized letters with altered content, depending on
criteria in the letter or address.
Here is what Google returned

I didn't ask how to do a mail merge, I asked about a specific problem,
stating exactly what was happening, the version numbers, etc.