Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2005

Tip: Looking for answers? Try searching our database.

Mail Merge next record in table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pete Doonican - 16 Mar 2005 15:03 GMT
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
Graham Mayor - 16 Mar 2005 15:37 GMT
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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

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

> Hi
>
[quoted text clipped - 16 lines]
> Thanks
> Pete
Pete Doonican - 16 Mar 2005 17:24 GMT
Thanks for that, worked a treat!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.