 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2008Word 2003 Mail Merge is generating zero values.
Ugh, in order to stream line a tedious process I am trying to merge data from excel into word. All fields are entered in the data source (excel) and when they merge 2 of my imputed fields are coming up ZERO? Why? They are entered. This small problem is making what would otherwise save us from a huge time suck... HELP HELP HELP. What data is in the fields? From the Tools menu in Word, select Options and go to the General tab and check the box against the "Confifm conversions at open" item. Then when you attach the data source to the mail merge main document, try using the DDE option that you can select in the dialog that will appear.  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Ugh, in order to stream line a tedious process I am trying to merge data > from excel into word. All fields are entered in the data source (excel) > and when they merge 2 of my imputed fields are coming up ZERO? Why? > They are entered. This small problem is making what would otherwise > save us from a huge time suck... HELP HELP HELP. So sorry I couldn't reply, I had an emergency family situation and had to take time off work unexpectedly. The data is phone numbers and general text field describing an alternatvie rental car company. ANd I checked the general tab in the tools menu and I didn't see that particular tab, can I do this in word 2003? > What data is in the fields? > [quoted text clipped - 8 lines] > > They are entered. This small problem is making what would otherwise > > save us from a huge time suck... HELP HELP HELP. The instructions that I gave you were for Word 2003. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > So sorry I couldn't reply, I had an emergency family situation and had to > take time off work unexpectedly. The data is phone numbers and general [quoted text clipped - 18 lines] >> > They are entered. This small problem is making what would otherwise >> > save us from a huge time suck... HELP HELP HELP. Is this the long term fix you recommend for this problem? I am having the same issue with my mailmerge -- two text fields come up as '0', even though others work. > The instructions that I gave you were for Word 2003. > [quoted text clipped - 20 lines] > >> > They are entered. This small problem is making what would otherwise > >> > save us from a huge time suck... HELP HELP HELP. The origin of these problems is described in http://tips.pjmsn.me.uk/t0003.htm. As for longer term fixes, a. I would always consider the possibility of not using Excel to store data (particularly if you have a lot of it) - these days you can keep data in various free databases, using Excel as a user interface if you prefer. But then you get your data directly from that database for Word merges. Otherwise you end up having to use Excel with more caution than is normally necessary purely to get around problems in the ODBC/OLE DB providers. b. other than changing to DDE, for this particular case I think the only simple option in Excel is to select the column and set the cell format to Text /before/ you enter any data, or follow the section on "Format a column as text via Data|Text to Columns..." in the abovementioned article. Dealing with ZIPs and dates is somewhat trickier. SignaturePeter Jamieson http://tips.pjmsn.me.uk > Is this the long term fix you recommend for this problem? I am having the > same issue with my mailmerge -- two text fields come up as '0', even [quoted text clipped - 30 lines] >> >> > They are entered. This small problem is making what would otherwise >> >> > save us from a huge time suck... HELP HELP HELP. It is the fourth item in tools > options > general? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > So sorry I couldn't reply, I had an emergency family situation and > had to take time off work unexpectedly. The data is phone numbers [quoted text clipped - 25 lines] >>> what would otherwise save us from a huge time suck... HELP HELP >>> HELP. For the "why", see http://tips.pjmsn.me.uk/t0003.htm (you will need a bit of time :-) ). SignaturePeter Jamieson http://tips.pjmsn.me.uk > Ugh, in order to stream line a tedious process I am trying to merge data > from excel into word. All fields are entered in the data source (excel) > and when they merge 2 of my imputed fields are coming up ZERO? Why? > They are entered. This small problem is making what would otherwise > save us from a huge time suck... HELP HELP HELP. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.