Copying excel tables into word document

P

Pat Gurgdiel

I have some documents laid out in excel spreadsheets that I would like to
move over to a word document for a mail merge. The tables are set-up to fit
to one page, but when I try to copy them to word, the table overflows the
word document. Is there an easy way to resize the information to a single
page in word?
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?UGF0IEd1cmdkaWVs?=,
I have some documents laid out in excel spreadsheets that I would like to
move over to a word document for a mail merge. The tables are set-up to fit
to one page, but when I try to copy them to word, the table overflows the
word document. Is there an easy way to resize the information to a single
page in word?
Click to expand...
Word should be able to merge directly to the Excel tables?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :)
 
C

CyberTaz

Hi Pat -

Can you be more clear about what you have to work with and what you are
trying to do with it? Version information would also be helpful.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 8/4/06 4:11 PM, in article
[email protected], "Pat Gurgdiel" <Pat
 
P

Pat Gurgdiel

I'm using word 2003 and excel 2003. I think I've figured out some of the
issue (which may lead to a different question).

In excel the document is reduced to 69% of it's original size so that it
fits on a single page. If there any way to make the same sort of reduction
in word?
 
P

Pat Gurgdiel

He're some more info that may help.
I have a templete in excel that is printed and mailed (kind of like a bill).
The information is set in excel with several different font sizes, merged
cells, and formatting. When I try to copy the table to word, it overflows a
single word page to the right and to the bottom.

My goal is to get the info on the sheet scaled down to 1 page in word (and
then add 2 other sheets the same way) so that all the information fits 1
table per page.

My end goal is that I'm trying to get already made document moved to Word so
that I can make some adjustments and do a mail merge without having to
reconstruct the original documents.

Thanks
 
C

Cindy M.

Hi =?Utf-8?B?UGF0IEd1cmdkaWVs?=,
I have a templete in excel that is printed and mailed (kind of like a bill).
The information is set in excel with several different font sizes, merged
cells, and formatting. When I try to copy the table to word, it overflows a
single word page to the right and to the bottom.
Click to expand...
What exact steps are you following to "copy the table to word"?
My goal is to get the info on the sheet scaled down to 1 page in word (and
then add 2 other sheets the same way) so that all the information fits 1
table per page.

My end goal is that I'm trying to get already made document moved to Word so
that I can make some adjustments and do a mail merge without having to
reconstruct the original documents.
Click to expand...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :)
 
Top