Copying excel tables into word document Pat Gurgdiel 04.08.2006 20:11:02 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?

Re: Copying excel tables into word document Cindy M -WordMVP- <C.Meister-C[ at ]hispeed.ch> 05.08.2006 09:17:28 Hi =?Utf-8?B?UGF0IEd1cmdkaWVs?=, [Quoted Text] > 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? > 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 :-)

Re: Copying excel tables into word document CyberTaz <onlygeneraltaz1[ at ]com.cast.net> 05.08.2006 14:22:19 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 07E7F5BF-6A6B-464C-B08F-F7B2BB2B06D4[ at ]microsoft.com, "Pat Gurgdiel" <Pat Gurgdiel[ at ]discussions.microsoft.com> wrote: [Quoted Text] > 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?

Re: Copying excel tables into word document Pat Gurgdiel 07.08.2006 12:40:01 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? "CyberTaz" wrote: [Quoted Text] > 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 > 07E7F5BF-6A6B-464C-B08F-F7B2BB2B06D4[ at ]microsoft.com, "Pat Gurgdiel" <Pat > Gurgdiel[ at ]discussions.microsoft.com> wrote: > > > 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? > >

Re: Copying excel tables into word document Pat Gurgdiel 07.08.2006 12:54:01 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 "CyberTaz" wrote: [Quoted Text] > 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 > 07E7F5BF-6A6B-464C-B08F-F7B2BB2B06D4[ at ]microsoft.com, "Pat Gurgdiel" <Pat > Gurgdiel[ at ]discussions.microsoft.com> wrote: > > > 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? > >

Re: Copying excel tables into word document Cindy M. <C.Meister-C[ at ]hispeed.ch> 07.08.2006 14:01:12 Hi =?Utf-8?B?UGF0IEd1cmdkaWVs?=, [Quoted Text] > 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. > 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. > 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 :-)