forms, data import excel, generate multiple pages

[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.

 

[Lisa Wilke-Thissen]

Hi,

[MS Word & Excel 2010, Window 7]

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?

have a look at this Website:
http://www.gmayor.com/individual_merge_letters.htm

 

[tntgalx10]

Hi,

[MS Word & Excel 2010, Window 7]

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?

have a look at this Website:http://www.gmayor.com/individual_merge_letters.htm

Thank you, working thru this.