Merge Only Using Excel

[raeleanne]

I have two documents (although they could be used as two sheets in one workbook). One is a form and the other is a list of data that needs to be populated into the form and printed.

Similar to a mail merge only my form and my data are both in excel.

There are 5 different sets of information that need to be populated, NAME, POSITION, HIRE DATE, SUPERVISOR and DEPARTMENT (columns A - E) to be populated into cells C5, C7, C9, C11 and C13 on the form.

Thanks

 

[raeleanne]

Add In?

I found this add in but it will only work for 12 merges...

http://www.ukww.net/patools/excel/mm.htm