If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail Merge
Hi, i'm trying to merge a word document with infomation from an excel
worksheet.I have completed the mail merge, however, the original document appears in the scroll after each merged document i.e. original doc/merged data/original doc/merged data/original doc,ect ect.Can anyone help ? |
#2
|
|||
|
|||
Mail Merge
That is unusual. I don't suppose you have something like an INCLUDETEXT
field that is including the mail merge main document? the scroll ? Are you merging directly to a printer, or to an output document? What type of merge (I assume it is Letters/Form Letters)? Which version of Word? What if you create a new, very simple mail merge document that uses the same data? -- Peter Jamieson http://tips.pjmsn.me.uk "spinball" wrote in message ... Hi, i'm trying to merge a word document with infomation from an excel worksheet.I have completed the mail merge, however, the original document appears in the scroll after each merged document i.e. original doc/merged data/original doc/merged data/original doc,ect ect.Can anyone help ? |
#3
|
|||
|
|||
Mail Merge
Are you saying that you get a document that contains as many copies of the
original document as there are records in your data source with each of those copies containing the data from an individual record in that data source. If so, that is the expected result if a letter type mail merge main document is executed to a new document. If you want to create individual documents for each record in the data source, see the "Individual Merge Letters" item on fellow MVP Graham Mayor's website at: http://www.gmayor.com/individual_merge_letters.htm If you are using Word XP or later, the "Add-in to Merge Letters to Separate Files" that I have written and that can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field in the data source with a minimum of fuss. -- 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 "spinball" wrote in message ... Hi, i'm trying to merge a word document with infomation from an excel worksheet.I have completed the mail merge, however, the original document appears in the scroll after each merged document i.e. original doc/merged data/original doc/merged data/original doc,ect ect.Can anyone help ? |
#4
|
|||
|
|||
Mail Merge
no! i've solved it!.when merging with excel you must not leave blank lines in
the spread sheet.you must take the ticks out of the blank lines on the preview screen.Then all is o.k. DONT LEAVE BLANK LINES WHEN MERGING! "Peter Jamieson" wrote: That is unusual. I don't suppose you have something like an INCLUDETEXT field that is including the mail merge main document? the scroll ? Are you merging directly to a printer, or to an output document? What type of merge (I assume it is Letters/Form Letters)? Which version of Word? What if you create a new, very simple mail merge document that uses the same data? -- Peter Jamieson http://tips.pjmsn.me.uk "spinball" wrote in message ... Hi, i'm trying to merge a word document with infomation from an excel worksheet.I have completed the mail merge, however, the original document appears in the scroll after each merged document i.e. original doc/merged data/original doc/merged data/original doc,ect ect.Can anyone help ? |
#5
|
|||
|
|||
Mail Merge
"Peter Jamieson" wrote: That is unusual. I don't suppose you have something like an INCLUDETEXT field that is including the mail merge main document? the scroll no! i've solved it!.when merging with excel you must not leave blank lines in the spread sheet.you must take the ticks out of the blank lines on the preview screen.Then all is o.k. DONT LEAVE BLANK LINES WHEN MERGING! thanks anyway! ? Are you merging directly to a printer, or to an output document? What type of merge (I assume it is Letters/Form Letters)? Which version of Word? What if you create a new, very simple mail merge document that uses the same data? -- Peter Jamieson http://tips.pjmsn.me.uk "spinball" wrote in message ... Hi, i'm trying to merge a word document with infomation from an excel worksheet.I have completed the mail merge, however, the original document appears in the scroll after each merged document i.e. original doc/merged data/original doc/merged data/original doc,ect ect.Can anyone help ? |
#6
|
|||
|
|||
Mail Merge
Well done - thanks for letting us know.
Peter Jamieson http://tips.pjmsn.me.uk spinball wrote: "Peter Jamieson" wrote: That is unusual. I don't suppose you have something like an INCLUDETEXT field that is including the mail merge main document? the scroll no! i've solved it!.when merging with excel you must not leave blank lines in the spread sheet.you must take the ticks out of the blank lines on the preview screen.Then all is o.k. DONT LEAVE BLANK LINES WHEN MERGING! thanks anyway! ? Are you merging directly to a printer, or to an output document? What type of merge (I assume it is Letters/Form Letters)? Which version of Word? What if you create a new, very simple mail merge document that uses the same data? -- Peter Jamieson http://tips.pjmsn.me.uk "spinball" wrote in message ... Hi, i'm trying to merge a word document with infomation from an excel worksheet.I have completed the mail merge, however, the original document appears in the scroll after each merged document i.e. original doc/merged data/original doc/merged data/original doc,ect ect.Can anyone help ? |
Thread Tools | |
Display Modes | |
|
|