merging from excel to word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LERY616 - 19 Jul 2006 16:21 GMT

I am merging from excel to word using mail merge but one of the fields
comes back as 0 if the number has letters .
example 4120 comes in as 4120 but if I put as 4120C it comes in at 0
aslo i have one that is .0075 and it comes in at 7.49999999997e-3 what is
up with that. the field beside it is .023 and it works fine!!!
HELP!!!!

Reply to this Message

Peter Jamieson - 19 Jul 2006 19:21 GMT

In this case your best bet is probably to change the way Word connects to
Excel - in Word, check Tools|Options|General|"Confirm conversions at open",
then go through through the process of connecting to Excel again and choose
the "DDE" option when it is offered.

Peter Jamieson

>I am merging from excel to word using mail merge but one of the fields
> comes back as 0 if the number has letters .
[quoted text clipped - 3 lines]
> up with that. the field beside it is .023 and it works fine!!!
> HELP!!!!

Reply to this Message

LERY616 - 19 Jul 2006 19:46 GMT

i tried that and nothing happens
I do not get asked DDE option

> In this case your best bet is probably to change the way Word connects to
> Excel - in Word, check Tools|Options|General|"Confirm conversions at open",
[quoted text clipped - 10 lines]
> > up with that. the field beside it is .023 and it works fine!!!
> > HELP!!!!

Reply to this Message

Peter Jamieson - 19 Jul 2006 20:00 GMT

You should see an extra dialog box after you have selected the .xls file.

(Everyone else does, as far as I know!)

Peter Jamieson

>i tried that and nothing happens
> I do not get asked DDE option
[quoted text clipped - 15 lines]
>> > up with that. the field beside it is .023 and it works fine!!!
>> > HELP!!!!

Reply to this Message