Mail merge is in MS Word and is not going to populate an Excel worksheet.
You could use a macro in Excel to use a template and to copy
to selected cells, or to replace cell content based on value form
another worksheet.
Part of whether this is feasible or what you want might be are you planning
on keeping the generated worksheets or is it only for printing like you
would use Mail Merge for.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
reno said:
using excel to set up forms since layout is so easy. now that xp office has so easy mail merge, is it possible to personalize or
populate excel worksheets with other excel data? lookups will work, but mail merge would seem to be easier, by selecting the
addressees and let 'r rip
