forms, data import excel, generate multiple pages

T

tntgalx10

Hi All... using MS Word & Excel 2010, Window 7.

I am wanting to have a form that I create in Word, where I import the
field data from an excel spreadsheet.

I know how to do the typical mail merge letter to get this done,
however the twist is, I need the merge to not result in ONE word file
with several hundred pages (1 page for each client on the excel
data). I need it to generate separate files for each page/client?
Ideally it would draw on a cell in the data to name the files?... (is
that asking too much?)

The excel data is a typical spreadsheet, where the rows are the
clients, and the columns are the subsequent data for each client.

Please advise... pulling my hair out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top