Reply
 
Thread Tools Display Modes
  #1   Report Post  
Pete Doonican via OfficeKB.com
 
Posts: n/a
Default Mail Merge next record in table

Hi

I've used the search function but can't find an existing thread that
answers my question, but please let me know if it is out there!

I'm using Word 2000 and have Excel 2000 as my data source.

I want to create a table where the rows are dependant on the data source.
I have tried setting up a catalogue but my header row repeats for every
instance of a row in the data source. When I just try a straight forward
'Form Letter' it requires me to enter Next Record for every row in the
spreadsheet which would be incredibly time consuming. I'm sure that I'm
just missing a very basic command but I just can't find what it is!

Any help would be greatly appreciated and if you need more info to solve
the problem please just let me know.

Thanks
Pete

--
Message posted via http://www.officekb.com
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

Create the catalog merge into a one row table. Merge to a new document then
add the header row and supplementary information in that document.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Pete Doonican via OfficeKB.com wrote:
Hi

I've used the search function but can't find an existing thread that
answers my question, but please let me know if it is out there!

I'm using Word 2000 and have Excel 2000 as my data source.

I want to create a table where the rows are dependant on the data
source. I have tried setting up a catalogue but my header row repeats
for every instance of a row in the data source. When I just try a
straight forward 'Form Letter' it requires me to enter Next Record
for every row in the spreadsheet which would be incredibly time
consuming. I'm sure that I'm just missing a very basic command but I
just can't find what it is!

Any help would be greatly appreciated and if you need more info to
solve the problem please just let me know.

Thanks
Pete



  #3   Report Post  
Pete Doonican via OfficeKB.com
 
Posts: n/a
Default

Thanks for that, worked a treat!

--
Message posted via http://www.officekb.com
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Next Record If Statement HiramPat Mailmerge 5 April 22nd 05 04:03 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Convert Table Labels to do Mail Merge? Jugglertwo Mailmerge 2 February 8th 05 01:16 AM
How to choose your own record deliminators in mail merge? GMed Mailmerge 0 January 21st 05 03:43 PM


All times are GMT +1. The time now is 08:11 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"