copying info from one workbook to another one

[Mago]

I'm working on a spreadsheet with all employee names and their annual
deductions. I need to send them a letter, addressed to each employee with
the specific deductions that each has. How can I copy the info from my
spreadsheet to my letter either using microsoft office or microsoft excell
(not sure which one would be easier). I'm not too familiar with all the
funtions of excell, I only know the very basic on the formulas. Please help,
I've spent so much time trying to look it up but no luck. thanks

 

[Gord Dibben]

I would suggest utilizing the excellent mail merging features of MS Word
which is part of MS Office.

Open Word and go to Tools>MailMerge.

Use Excel as the source for the mailmerge.

See these sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP