ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   merging workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/36737-merging-workbooks.html)

Ria

merging workbooks
 
I am a teacher. I have to enter all my students grades into a form, I then
have to merge that document with the report template in order to quickly
print all the reports for my students without having to enter all the details
on each individual report.

How do I do this?

Thanx
Ria

Bryan Hessey


This sounds like a job for MS Word's 'mail merge' (or Form Letter), for
which Excel has a Help under 'Mail Merge'


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=389562


Dave Peterson

And just some references...

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

Ria wrote:

I am a teacher. I have to enter all my students grades into a form, I then
have to merge that document with the report template in order to quickly
print all the reports for my students without having to enter all the details
on each individual report.

How do I do this?

Thanx
Ria


--

Dave Peterson


All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com