Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
I am trying to insert a paragraph into a Word document through a merge. When
I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
Hi lola,
Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
Yes, it is a merge field. I chose the merge field from the list, so it
matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
Have you added to field to the data source? What is the data source? Have
you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
I just tried re-attaching my merge document with my data source.
No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
Have a look at http://tips.pjmsn.me.uk/t0003.htm - the DDE option is
probably the simplest if it works. -- Peter Jamieson http://tips.pjmsn.me.uk "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
No, the DDE option does not work either.
I think I will just type the text directly into the merge documents. Thanks for the help. "Peter Jamieson" wrote: Have a look at http://tips.pjmsn.me.uk/t0003.htm - the DDE option is probably the simplest if it works. -- Peter Jamieson http://tips.pjmsn.me.uk "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
Is there a named range in the worksheet that is being used as the data
source? Possibly, the new data appears in a column that is outside of the named range. -- Hope 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 "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
I don't think so, but where would I find that?
When I connected to the data source, it just said "Sheet1$", but no cell range was listed there... "Doug Robbins - Word MVP" wrote: Is there a named range in the worksheet that is being used as the data source? Possibly, the new data appears in a column that is outside of the named range. -- Hope 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 "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
OK, that seems to have been blind alley. How about if you insert a column
in the middle of the existing data and populate that column with the text that you want to use. -- Hope 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 "lola5375" wrote in message ... I don't think so, but where would I find that? When I connected to the data source, it just said "Sheet1$", but no cell range was listed there... "Doug Robbins - Word MVP" wrote: Is there a named range in the worksheet that is being used as the data source? Possibly, the new data appears in a column that is outside of the named range. -- Hope 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 "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#12
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
If inserting the text manually is good enough, fine. Otherwise,
a. you can try copying/pasting the entire Excel sheet into a new Word document, and using that as the data source: however, if you have more columns in the worksheet than Word allows in a table, this may not work either. b. what, roughly speaking, is in the first 8 rows of the column that's causing the problem? Are there cells with numbers? -- Peter Jamieson http://tips.pjmsn.me.uk "lola5375" wrote in message ... No, the DDE option does not work either. I think I will just type the text directly into the merge documents. Thanks for the help. "Peter Jamieson" wrote: Have a look at http://tips.pjmsn.me.uk/t0003.htm - the DDE option is probably the simplest if it works. -- Peter Jamieson http://tips.pjmsn.me.uk "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#13
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
I've tried that too. I went back and tried the DDE option again and I got
that to work, but now I have a new issue... Using the DDE option, my VLOOKUP formulas don't seem to work. Is there a way around that? "Doug Robbins - Word MVP" wrote: OK, that seems to have been blind alley. How about if you insert a column in the middle of the existing data and populate that column with the text that you want to use. -- Hope 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 "lola5375" wrote in message ... I don't think so, but where would I find that? When I connected to the data source, it just said "Sheet1$", but no cell range was listed there... "Doug Robbins - Word MVP" wrote: Is there a named range in the worksheet that is being used as the data source? Possibly, the new data appears in a column that is outside of the named range. -- Hope 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 "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#14
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
Select the cells that contain the VLOOKUP formulae and use CopyPaste
SpecialValues to convert the data to ordinary text. -- Hope 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 "lola5375" wrote in message ... I've tried that too. I went back and tried the DDE option again and I got that to work, but now I have a new issue... Using the DDE option, my VLOOKUP formulas don't seem to work. Is there a way around that? "Doug Robbins - Word MVP" wrote: OK, that seems to have been blind alley. How about if you insert a column in the middle of the existing data and populate that column with the text that you want to use. -- Hope 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 "lola5375" wrote in message ... I don't think so, but where would I find that? When I connected to the data source, it just said "Sheet1$", but no cell range was listed there... "Doug Robbins - Word MVP" wrote: Is there a named range in the worksheet that is being used as the data source? Possibly, the new data appears in a column that is outside of the named range. -- Hope 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 "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
#15
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Text displays as ZERO
It worked!! Thank you so much for your help
"Doug Robbins - Word MVP" wrote: Select the cells that contain the VLOOKUP formulae and use CopyPaste SpecialValues to convert the data to ordinary text. -- Hope 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 "lola5375" wrote in message ... I've tried that too. I went back and tried the DDE option again and I got that to work, but now I have a new issue... Using the DDE option, my VLOOKUP formulas don't seem to work. Is there a way around that? "Doug Robbins - Word MVP" wrote: OK, that seems to have been blind alley. How about if you insert a column in the middle of the existing data and populate that column with the text that you want to use. -- Hope 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 "lola5375" wrote in message ... I don't think so, but where would I find that? When I connected to the data source, it just said "Sheet1$", but no cell range was listed there... "Doug Robbins - Word MVP" wrote: Is there a named range in the worksheet that is being used as the data source? Possibly, the new data appears in a column that is outside of the named range. -- Hope 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 "lola5375" wrote in message ... Also, the data source is an Excel worksheet. All of the other merge fields are working, just not this one... "lola5375" wrote: I just tried re-attaching my merge document with my data source. No luck "Doug Robbins - Word MVP" wrote: Have you added to field to the data source? What is the data source? Have you tried re-attaching the modified data source to the mail merge main document? -- Hope 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 "lola5375" wrote in message ... Yes, it is a merge field. I chose the merge field from the list, so it matches the source file, and I have checked that the text exists in the correct spot in the source file. Both the merge document and the source file were created in 2003 and I am using 2007. Would this cause a problem? Thanks, Lola "macropod" wrote: Hi lola, Whar type of field are you using to add the text? If it's a mergefield, have you named the data field correctly and does the necessary text exist in the corresponding field for each record in the source file? -- Cheers macropod [MVP - Microsoft Word] "lola5375" wrote in message ... I am trying to insert a paragraph into a Word document through a merge. When I insert the merge field into the document, the text I have entered displays as a zero. I should say that I did not create this merged document, I am simply trying to add a field to it. Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 all text displays as squares? | Microsoft Word Help | |||
Text displays as small squares | Microsoft Word Help | |||
Text box displays but won't print. | Page Layout | |||
Header of Tables displays correctly, body of table displays in foo | Tables | |||
Excel text displays incorrectly | Microsoft Word Help |