Mail Merge help again

Have a golf card on a 2002 Excel sheet wanting to print many cards after
reading names and handicap from an 2002 Excel sheet. Can not find a way of
getting Excel to mail merge or print the sheets. I can mail merge using Word
but not if I paste the Excel card into Word. I tried the different ways of
pasting into Word but only way to hold the cell spacing is to use Excel
worksheet format. Can anyone point me in the right direction to do this
task?

DrB

Don't paste Excel into Word. Use Word's mailmerge with Excel as the Data
Source.

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

Gord Dibben Excel MVP


On Thu, 17 Jun 2004 13:48:55 -0700, "DrB" wrote:

Have a golf card on a 2002 Excel sheet wanting to print many cards after
reading names and handicap from an 2002 Excel sheet. Can not find a way of
getting Excel to mail merge or print the sheets. I can mail merge using Word
but not if I paste the Excel card into Word. I tried the different ways of
pasting into Word but only way to hold the cell spacing is to use Excel
worksheet format. Can anyone point me in the right direction to do this
task?

work to created another score card using Word's table. That is why I tried
to paste. Any other suggestions?


"Gord Dibben" gorddibbATshawDOTca wrote in message
...
DrB

Don't paste Excel into Word. Use Word's mailmerge with Excel as the Data
Source.

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

Gord Dibben Excel MVP


On Thu, 17 Jun 2004 13:48:55 -0700, "DrB" wrote:

Have a golf card on a 2002 Excel sheet wanting to print many cards after
reading names and handicap from an 2002 Excel sheet. Can not find a way
of
getting Excel to mail merge or print the sheets. I can mail merge using
Word
but not if I paste the Excel card into Word. I tried the different ways
of
pasting into Word but only way to hold the cell spacing is to use Excel
worksheet format. Can anyone point me in the right direction to do this
task?

If you have a scorecard that is one layout that you perhaps do
want to paste into Word perhaps modify it there for more Word stuff.
Once it is in Word you probably just want to use document from
then on as your skeleton.

But your list of names would remain in Excel and must be the
first worksheet so that Word can find it.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Dad" wrote in message ...
work to created another score card using Word's table. That is why I tried
to paste. Any other suggestions?


"Gord Dibben" gorddibbATshawDOTca wrote in message
...
DrB

Don't paste Excel into Word. Use Word's mailmerge with Excel as the Data
Source.

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

Gord Dibben Excel MVP


On Thu, 17 Jun 2004 13:48:55 -0700, "DrB" wrote:

Have a golf card on a 2002 Excel sheet wanting to print many cards after
reading names and handicap from an 2002 Excel sheet. Can not find a way
of
getting Excel to mail merge or print the sheets. I can mail merge using
Word
but not if I paste the Excel card into Word. I tried the different ways
of
pasting into Word but only way to hold the cell spacing is to use Excel
worksheet format. Can anyone point me in the right direction to do this
task?

Yes, once I add the Excel scorecard to Word I need to insert the mail merge
fields for names, index and tee time into the scorecard and print the 40
cards for a tournament. My problem is when I copy the Excel scorecard and
paste into Word, my only option is to paste as a Excel Spreadsheet Object
since I need to modify it to input the mail merge fields. Unfortunately when
I do this Word will not read the mail merge field data from the first page
in the Excel file when I look to see how it will print. How do I get around
this?

"David McRitchie" wrote in message
...
If you have a scorecard that is one layout that you perhaps do
want to paste into Word perhaps modify it there for more Word stuff.
Once it is in Word you probably just want to use document from
then on as your skeleton.

But your list of names would remain in Excel and must be the
first worksheet so that Word can find it.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Dad" wrote in message
...
work to created another score card using Word's table. That is why I
tried
to paste. Any other suggestions?


"Gord Dibben" gorddibbATshawDOTca wrote in message
...
DrB

Don't paste Excel into Word. Use Word's mailmerge with Excel as the
Data
Source.

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

Gord Dibben Excel MVP


On Thu, 17 Jun 2004 13:48:55 -0700, "DrB"
wrote:

Have a golf card on a 2002 Excel sheet wanting to print many cards
after
reading names and handicap from an 2002 Excel sheet. Can not find a
way
of
getting Excel to mail merge or print the sheets. I can mail merge
using
Word
but not if I paste the Excel card into Word. I tried the different
ways
of
pasting into Word but only way to hold the cell spacing is to use
Excel
worksheet format. Can anyone point me in the right direction to do
this
task?