mailmerge in excel

[Guest]

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
thanks

 

[David McRitchie]

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.

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