Mail Merge spinball 11/12/2008 4:26:10 PM 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 ?

Re: Mail Merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 11/12/2008 6:04:03 PM That is unusual. I don't suppose you have something like an INCLUDETEXT field that is including the mail merge main document? [Quoted Text] > 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" <spinball[ at ]discussions.microsoft.com> wrote in message news:3055593A-2D16-4DCB-ABBD-B35972FB6B98[ at ]microsoft.com... > 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 ?

Re: Mail Merge "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/12/2008 7:12:42 PM 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" <spinball[ at ]discussions.microsoft.com> wrote in message news:3055593A-2D16-4DCB-ABBD-B35972FB6B98[ at ]microsoft.com... [Quoted Text] > 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 ?

Re: Mail Merge spinball 11/14/2008 10:12:00 AM 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: [Quoted Text] > 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" <spinball[ at ]discussions.microsoft.com> wrote in message > news:3055593A-2D16-4DCB-ABBD-B35972FB6B98[ at ]microsoft.com... > > 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 ? > >

Re: Mail Merge spinball 11/14/2008 11:41:02 AM "Peter Jamieson" wrote: [Quoted Text] > 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" <spinball[ at ]discussions.microsoft.com> wrote in message > news:3055593A-2D16-4DCB-ABBD-B35972FB6B98[ at ]microsoft.com... > > 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 ? > >

Re: Mail Merge Peter Jamieson <pjj[ at ]KillMAPSpjjnet.demon.co.uk> 11/14/2008 11:50:18 AM Well done - thanks for letting us know. Peter Jamieson http://tips.pjmsn.me.uk spinball wrote: [Quoted Text] > > "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" <spinball[ at ]discussions.microsoft.com> wrote in message >> news:3055593A-2D16-4DCB-ABBD-B35972FB6B98[ at ]microsoft.com... >>> 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 ? >>