Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel to Word Macro
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel to Word Macro
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/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm If you want to skip Word and just use Excel see John Walkenbach's site. http://spreadsheetpage.com/index.php..._without_word/ But going through Word is much easier IMO. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 09:45:01 -0800, Liz J wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Word from Excel Macro. | Excel Discussion (Misc queries) | |||
Excel running Word macro | Excel Discussion (Misc queries) | |||
Need a word-count macro for excel | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Macro - Open Word with Excel macro | Excel Discussion (Misc queries) |