(Msg. 1) Posted: Wed Sep 10, 2008 12:47 pm
Post subject: Using Excel values in Word Mail Merge Archived from groups: microsoft>public>excel>misc (more info?)
Hi all,
I'm trying to use the rounded values in an excel spreadsheet as fields in my
mail merge. The merge pulls up the original number with many decimal places.
How do I get the merge to show the rounded value?
(Msg. 2) Posted: Wed Sep 10, 2008 4:23 pm
Post subject: Re: Using Excel values in Word Mail Merge [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you:
==========
I often cheat instead of racking my brain.
I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.
(Cheating doesn't bother me anymore <vbg>.)
dory a wrote:
>
> Hi all,
>
> I'm trying to use the rounded values in an excel spreadsheet as fields in my
> mail merge. The merge pulls up the original number with many decimal places.
> How do I get the merge to show the rounded value?
>
> Thanks for your help!
>
> Dory
(Msg. 3) Posted: Wed Sep 10, 2008 11:44 pm
Post subject: Re: Using Excel values in Word Mail Merge [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
In article <48C83AD0.8FF3406C.RemoveThis@verizonXSPAM.net>, petersod.RemoveThis@verizonXSPAM.net wrote:
>Debra Dalgleish posted this:
>
>There's an article on the Microsoft web site that might help you:
>
>Answer Box: Numbers don't merge right in Word
> http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx >
>And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
>has instructions here:
>
> http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm >
>about half way down the page.
>
>==========
>I often cheat instead of racking my brain.
>
>I'll insert another column (probably hidden!) and use:
>=text(a2,"ddmmyy")
>or
>=text(a2,"mm:ss.0")
>or
>=text(a2,"00000")
>(or whatever format I want)
>and use that field in the mailmerge.
>
>(Cheating doesn't bother me anymore <vbg>.)
It's not cheating, it's an alternative way of doing something.
I've had format problems when mail merging before. Fixed them by choosing
the ...
MS Excel worksheets via DDE (*.xls)
option when getting the data. Suddenly, I got what I expected again.
(Msg. 4) Posted: Thu Sep 11, 2008 6:07 am
Post subject: Re: Using Excel values in Word Mail Merge [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you Dave and Bruce. It worked great!!!!
"Dave Peterson" wrote:
> Debra Dalgleish posted this:
>
> There's an article on the Microsoft web site that might help you:
>
> Answer Box: Numbers don't merge right in Word
> http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx >
> And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
> has instructions here:
>
> http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm >
> about half way down the page.
>
> ==========
> I often cheat instead of racking my brain.
>
> I'll insert another column (probably hidden!) and use:
> =text(a2,"ddmmyy")
> or
> =text(a2,"mm:ss.0")
> or
> =text(a2,"00000")
> (or whatever format I want)
> and use that field in the mailmerge.
>
> (Cheating doesn't bother me anymore <vbg>.)
>
> dory a wrote:
> >
> > Hi all,
> >
> > I'm trying to use the rounded values in an excel spreadsheet as fields in my
> > mail merge. The merge pulls up the original number with many decimal places.
> > How do I get the merge to show the rounded value?
> >
> > Thanks for your help!
> >
> > Dory
>
> --
>
> Dave Peterson
>
All times are: Eastern Time (US & Canada) (change)
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
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office