Excel-Excel Mail Merge Possible?

[DrB]

I have a golf score card for tournaments. Currently I have to input my hand
the tee time, handicap, and golfer name for each of four on the card and
print each one at a time. Would like to do it like with MsWord where I mail
merge data from an excel sheet into a .doc file to print many sheets with
the names, etc. Is this possible to merge data from one excel sheet into
another and print all the merged sheets?

I tried to copy the excel table into a .doc sheet and do the mail merge
thing but could not get the table to copy correctly (spacing) or if I did it
another way I could not modify the table.

Thanks for your help in advance.

 

[Gord Dibben]

It could be done in Excel only, but........

Investigate the use of Word's mailmerge feature to get Excel data to labels
and envelopes.

Doing it strictly in Excel is difficult and involves much trial and error
formatting.

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 Excel MVP

Gord Dibben Excel MVP

 

[Jenny]

I use Excel quite a lot to hold information for mail
merges. You need to activate the mail merge from Word
however. When getting your source data, just choose the
excel file that you have saved, if you have your columns
named properly, it will be easy.