need help merging a directory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenn - 19 Jan 2004 19:47 GMT

I have an online registration form, which automatically updates a CSV file
when a user enters their registration information.

I'd like to be able to create a sign-in sheet based on that information.

I want the sign in sheet to have a header at the top of the page.

I've tried doing mail merge / directory and have met with limited success.

When I perform the merge, the header information appears before every
record.

For example, I want to get this:

Workshop Sign-in Sheet
Name Signature
John Doe
Jane Smith
Lou Wong

Instead, I am getting this:

Workshop Sign-in Sheet
Name Signature
John Doe
Workshop Sign-in Sheet
Name Signature
Jane Smith
Workshop Sign-in Sheet
Name Signature
Lou Wong

Can someone please help me out with this?
Thanks.

Reply to this Message

Graham Mayor - 20 Jan 2004 07:51 GMT

With a directory merge, whatever you put on the text area is repeated on
every page. Put the title and column headers in the page header/footer view
and only the name fields and dotted tab leader for the signature etc in the
text area.

Also checkout Cindy's web page article on special merges
http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#ComplexMerg

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I have an online registration form, which automatically updates a CSV
> file when a user enters their registration information.
[quoted text clipped - 32 lines]
> Can someone please help me out with this?
> Thanks.

Reply to this Message