Excel to Word Macro

[Liz J]

I am doing end of the year statements for people who have donated to my
organization. I'd like to create macro that takes a total amount by person
from Excel and then inputs the donor's name and total giving amount into a
Thank you note in a Word document. Any ideas as to how I go about doing this?

Thank you for your time and help!

 

[Gord Dibben]

I would use a mailmerge in Word.

Create your thank you note in Word and populate it from Excel.

Assuming you are using Word for the mailmerge and Excel for the source 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

If you want to skip Word and just use Excel see John Walkenbach's site.

http://spreadsheetpage.com/index.php/tip/mail_merge_without_word/

But going through Word is much easier IMO.


Gord Dibben MS Excel MVP