Text displays as ZERO

[lola5375]

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.

 

[macropod]

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?

 

[lola5375]

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

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]

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.

 

[Doug Robbins - Word MVP]

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

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

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]

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.

 

[lola5375]

I just tried re-attaching my merge document with my data source.
No luck

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

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

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]


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.

 

[lola5375]

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

I just tried re-attaching my merge document with my data source.
No luck

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

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

:

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]


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.

 

[Peter Jamieson]

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

I just tried re-attaching my merge document with my data source.
No luck

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

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

:

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]


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.

 

[lola5375]

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.

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

I just tried re-attaching my merge document with my data source.
No luck

:

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

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

:

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]


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.

 

[Doug Robbins - Word MVP]

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

I just tried re-attaching my merge document with my data source.
No luck

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

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

:

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]


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.

 

[lola5375]

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...

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

I just tried re-attaching my merge document with my data source.
No luck

:

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

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

:

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]


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.

 

[Doug Robbins - Word MVP]

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

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...

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

:

I just tried re-attaching my merge document with my data source.
No luck

:

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

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

:

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]


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.

 

[Peter Jamieson]

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

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.

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

:

I just tried re-attaching my merge document with my data source.
No luck

:

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

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

:

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]


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.

 

[lola5375]

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?

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

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...

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

:

I just tried re-attaching my merge document with my data source.
No luck

:

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

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

:

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]


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.

 

[Doug Robbins - Word MVP]

Select the cells that contain the VLOOKUP formulae and use Copy>Paste
Special>Values 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

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?

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

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...

:

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

:

I just tried re-attaching my merge document with my data source.
No luck

:

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

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

:

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]


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.

 

[lola5375]

It worked!! Thank you so much for your help

Select the cells that contain the VLOOKUP formulae and use Copy>Paste
Special>Values 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

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?

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

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...

:

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

Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...

:

I just tried re-attaching my merge document with my data source.
No luck

:

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

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

:

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]


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.