using excel instead of word mail merge

[charmingCanadian]

Hello!

I'm so glad I found this site and I'm really hoping someone can help me! For the past 2 years I've created a large spreadsheet of data in excel at work, each row for a single person, then done a mail merge into word and have been left with 500+ pages with individual data. For me this is fine, but I am now abroad and the people at home who need to use this document can't find the original word document and have no clue how to do mail merge. My question is, is there a way to have the same effect in Excel so I can create an excel document that has all the pages they need including one that will pull the data from another page? There will be about 500 rows of data that need to be put in specific places on a page but I don't want to have to make 500 layout pages.... can I just make it multiply for the number of rows there are?

I hope I'm making sense and someone can help me!

Thanks in advance!

 

[hkaplan2]

It would be simpler to have them send you the Word doc they want to merge data into, and just set it up for them.

It is possible to create a Word-like document in Excel and create a macro to fill in the data one record at a time and print, but you will start to have other issues if you want to generate those 500 pages in Excel. You can't have 500 tabs (I believe) and it would be clumbsy to create the pages in a single sheet.

Or send them instructions on how to merge. It is pretty easy as you know.

 

[NdNoviceHlp]

Welcome to the Board CharmingCanadian! Why not just make 1 Word template and send the XL info to it? After you put the individual info in the .dot template file, you then make a .doc file from the template... and so on for all the individuals. If you need summary data, again make a summary Word template, do your math in XL and then send the result info to the .dot file and then make a summary.doc from the template. HTH. Dave

 

[ndendrinos]

Maybe this will help.
http://www.box.net/shared/ebvh7v2oae