Excel Mail Merge?

geerdad · Oct 13, 2009

Is there a way to create multiple worksheets (or workbooks) with certain
cells being auto-filled from a data source, similar to what MS Word calls a
Mail Merge?

JP · Oct 14, 2009

Yes, but you'd need to provide far more details if you want any
semblance of sample VBA code.

--JP

Mix.G · Oct 15, 2009

I'm not too sure if this helps, but if your data source is another excel
worksheet you can use a VLOOKUP formular. The link to the 'instructions' is
below:
http://office.microsoft.com/en-us/excel/HA010563201033.aspx?pid=CL100570551033

Excel Mail Merge?

geerdad

JP

Mix.G