|
|
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.
|
|
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" <lola5375[ at ]discussions.microsoft.com> wrote in message news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
[Quoted Text] >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.
|
|
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:
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
> >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.
>
>
|
|
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" <lola5375[ at ]discussions.microsoft.com> wrote in message
news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
>> >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.
>>
>>
|
|
I just tried re-attaching my merge document with my data source.
No luck :(
"Doug Robbins - Word MVP" wrote:
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
> > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
> >> >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.
> >>
> >>
>
>
>
|
|
Also, the data source is an Excel worksheet.
All of the other merge fields are working, just not this one...
"lola5375" wrote:
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
> > >> >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.
> > >>
> > >>
> >
> >
> >
|
|
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" <lola5375[ at ]discussions.microsoft.com> wrote in message
news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com...
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
>> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
>> > >> >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.
>> > >>
>> > >>
>> >
>> >
>> >
|
|
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:
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message > news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com... > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message > >> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com... > >> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message > >> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com... > >> > >> >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. > >> > >> > >> > >> > >> > > >> > > >> > > > |
|
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" <lola5375[ at ]discussions.microsoft.com> wrote in message
news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com...
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
>> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
>> > >> >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.
>> > >>
>> > >>
>> >
>> >
>> >
|
|
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:
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com...
> > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
> >> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
> >> > >> >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.
> >> > >>
> >> > >>
> >> >
> >> >
> >> >
>
>
>
|
|
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" <lola5375[ at ]discussions.microsoft.com> wrote in message
news:568693A4-2A58-49C4-8C44-29B6F27E462B[ at ]microsoft.com...
[Quoted Text] >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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com...
>> > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> >> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
>> >> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> >> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
>> >> > >> >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.
>> >> > >>
>> >> > >>
>> >> >
>> >> >
>> >> >
>>
>>
>>
|
|
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" <lola5375[ at ]discussions.microsoft.com> wrote in message
news:89D198CD-CFD3-4ED9-8FA7-905F41CCC6EB[ at ]microsoft.com...
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message >> news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com... >> > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message >> >> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com... >> >> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message >> >> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com... >> >> > >> >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. >> >> > >> >> >> > >> >> >> > >> >> > >> >> > >> >>
|
|
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:
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> news:568693A4-2A58-49C4-8C44-29B6F27E462B[ at ]microsoft.com...
> >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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com...
> >> > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> >> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
> >> >> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> >> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
> >> >> > >> >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.
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>
>
|
|
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
"lola5375" <lola5375[ at ]discussions.microsoft.com> wrote in message
news:ECF66F89-30D9-4186-AB17-7B431236172A[ at ]microsoft.com...
[Quoted Text] > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> news:568693A4-2A58-49C4-8C44-29B6F27E462B[ at ]microsoft.com...
>> >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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> >> news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com...
>> >> > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
>> >> >> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
>> >> >> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in
>> >> >> > >> message
>> >> >> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
>> >> >> > >> >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.
>> >> >> > >>
>> >> >> > >>
>> >> >> >
>> >> >> >
>> >> >> >
>> >>
>> >>
>> >>
>>
>>
>>
|
|
It worked!! Thank you so much for your help :)
"Doug Robbins - Word MVP" wrote:
[Quoted Text] > 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
>
> "lola5375" <lola5375[ at ]discussions.microsoft.com> wrote in message
> news:ECF66F89-30D9-4186-AB17-7B431236172A[ at ]microsoft.com...
> > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> news:568693A4-2A58-49C4-8C44-29B6F27E462B[ at ]microsoft.com...
> >> >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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> >> news:4E980E76-5DE6-488C-AE44-808A7AD15347[ at ]microsoft.com...
> >> >> > 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" <lola5375[ at ]discussions.microsoft.com> wrote in message
> >> >> >> > news:F0105A02-FA97-4A12-B5E6-645A012E13F8[ at ]microsoft.com...
> >> >> >> > > 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" <lola5375[ at ]discussions.microsoft.com> wrote in
> >> >> >> > >> message
> >> >> >> > >> news:17114C86-8EF0-4E0B-ABB7-CA467E2BB7C6[ at ]microsoft.com...
> >> >> >> > >> >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.
> >> >> >> > >>
> >> >> >> > >>
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
|
|
|