| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging from excel to word
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!!!! |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
merging from excel to word
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 "LERY616" wrote in message ... 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!!!! |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
merging from excel to word
i tried that and nothing happens
I do not get asked DDE option "Peter Jamieson" wrote: 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 "LERY616" wrote in message ... 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!!!! |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
merging from excel to word
You should see an extra dialog box after you have selected the .xls file.
(Everyone else does, as far as I know!) Peter Jamieson "LERY616" wrote in message ... i tried that and nothing happens I do not get asked DDE option "Peter Jamieson" wrote: 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 "LERY616" wrote in message ... 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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
| Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
| How to put graphics on envelopes? | Microsoft Word Help | |||
| take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
| Excel worksheet in Word linked text boxes | Page Layout | |||
Linear Mode
