Word/Excel Question

oliegirl · 07-26-2005, 04:46 PM

I need to print about 200 letters, each with a different name at the top (for my son's school)...the bottom of the letter contains an order form. I created the entire thing in Excel, because it's the easiest place to create a form, but don't want to have to type in all the names...so I thought of a mail merge, but I don't think you can mail merge in excel. So is it is possible to write a letter in word and then import/insert an excel spreadsheet into the bottom of it???

Easy Mac · 07-26-2005, 04:56 PM

Yeah, just go to insert-->file and find the file. That should do it I think.

jbmagic · 07-26-2005, 05:12 PM

here a great forum for Excel

http://www.mrexcel.com/board2/index....75aca7d613b010

cartman · 07-26-2005, 05:15 PM

You should be able to do the mail merge in Word, and give it Excel as the source for the names. And you can get the file imported into the Word doc with the steps Easy Mac put.

oliegirl · 07-26-2005, 08:58 PM

Quote:

Originally Posted by Easy Mac

Yeah, just go to insert-->file and find the file. That should do it I think.

It didn't work...will only let me insert other word files, and I need to insert an excel file

I'll check that link that was posted, but in the meantime if anyone can help - please do!

cartman · 07-26-2005, 09:01 PM

Quote:

Originally Posted by oliegirl

It didn't work...will only let me insert other word files, and I need to insert an excel file

I'll check that link that was posted, but in the meantime if anyone can help - please do!

Instead of Insert -> File, try Insert -> Object (stop the snickering...). Then you should be able to select Excel Worksheet as the type of object.

Easy Mac · 07-26-2005, 09:02 PM

Insert -->Object-->Excel Worksheet

oliegirl · 07-26-2005, 09:04 PM

Cartman and Easy Mac are my heroes!!!!! I love you both

I hereby make you honorary Simpson PTA Spiritwear Chairpersons

oliegirl · 07-26-2005, 09:09 PM

UGH! Now I can't get it on one page!!!! No matter how much room I have, it keeps moving it to a second page! HELP!!!!

cartman · 07-26-2005, 09:14 PM

Quote:

Originally Posted by oliegirl

UGH! Now I can't get it on one page!!!! No matter how much room I have, it keeps moving it to a second page! HELP!!!!

Click on file -> Page Setup and there you can change the margins to give yourself more available room on the page.

oliegirl · 07-26-2005, 09:21 PM

Quote:

Originally Posted by cartman

Click on file -> Page Setup and there you can change the margins to give yourself more available room on the page.

Yeah - I got that done, my brain is not working (I blame it on spending 3 months with my 7 year old!)...but now when I print it the gray gridlines show up. Is there a way to keep that from happening?

See what happens when you get sucked into the PTA? It's a vortex, a black hole that you can't escape!!!!

cartman · 07-26-2005, 09:25 PM

Quote:

Originally Posted by oliegirl

Yeah - I got that done, my brain is not working (I blame it on spending 3 months with my 7 year old!)...but now when I print it the gray gridlines show up. Is there a way to keep that from happening?

See what happens when you get sucked into the PTA? It's a vortex, a black hole that you can't escape!!!!

Are those lines there when you print? I think they only appear on screen, not when you print.

oliegirl · 07-26-2005, 09:28 PM

Nope - radii printed one for me and they showed up

cartman · 07-26-2005, 09:44 PM

Are they only showing up in the part where you put the Excel file, or over the whole document?

oliegirl · 07-26-2005, 09:44 PM

Just where the excel document is....

cartman · 07-26-2005, 09:52 PM

Quote:

Originally Posted by oliegirl

Just where the excel document is....

Go back to Excel, and do the File -> Page Setup thing. On the Sheet tab, make sure Gridlines is unchecked.

You'll have to save the Excel file and reimport into Word, but that should fix it for ya.

oliegirl · 07-27-2005, 08:26 AM

Yeah, I did that...I actually know a lot about Excel, just not much about Word. From what I have read there is no way to get rid of the gridlines. I may try reversing the process and inserting a word doc into my spreadsheet - maybe that will do it. Thanks for all the help though!!!!

thetrilogy · 07-27-2005, 12:06 PM

If you don't plan on typing/editing the Excel portion once it is in Word.
An advanced technique could be to:

-In Excel, do a print preview. Zoom in so that you only see what you
want in the Word document.
-Hit PrintScrn
-Paste that image into Word. Crop and resize the image so it only
shows what you want to print. You can do more advance image
editing tools in Word also, so you can move it around without
moving alot of the other text.

oliegirl · 07-27-2005, 12:20 PM

Quote:

Originally Posted by thetrilogy

If you don't plan on typing/editing the Excel portion once it is in Word.
An advanced technique could be to:

-In Excel, do a print preview. Zoom in so that you only see what you
want in the Word document.
-Hit PrintScrn
-Paste that image into Word. Crop and resize the image so it only
shows what you want to print. You can do more advance image
editing tools in Word also, so you can move it around without
moving alot of the other text.

I may have to hobble up the stairs and try that...my laptop isn't connected to a printer so I can't do a print screen. If anyone knows how to easily set up a network printer - let me know

thetrilogy · 07-27-2005, 12:36 PM

Quote:

Originally Posted by oliegirl

...my laptop isn't connected to a printer so I can't do a print screen. If anyone knows how to easily set up a network printer - let me know

The PrintScrn function copies the image to the clipboard. It doesn't send it to the printer. It's so you can have more control over your Excel doc when it is in Word in terms of margins and cell borders on/off.

Good luck with this. Or send it to me and I can have it done in 1 minute.

oliegirl · 07-27-2005, 12:37 PM

Quote:

Originally Posted by thetrilogy

The PrintScrn function copies the image to the clipboard. It doesn't send it to the printer. It's so you can have more control over your Excel doc when it is in Word in terms of margins and cell borders on/off.

Good luck with this. Or send it to me and I can have it done in 1 minute.

But I can't even do a print preview

Give me your email and I'll send the thing to you

If you can fix it - I'll love you forever!!!!

07-26-2005, 05:15 PM	#4
cartman Death Herald Join Date: Nov 2000 Location: Le stelle la notte sono grandi e luminose nel cuore profondo del Texas	You should be able to do the mail merge in Word, and give it Excel as the source for the names. And you can get the file imported into the Word doc with the steps Easy Mac put. __________________ Thinkin' of a master plan 'Cuz ain't nuthin' but sweat inside my hand So I dig into my pocket, all my money is spent So I dig deeper but still comin' up with lint

07-26-2005, 09:44 PM	#14
cartman Death Herald Join Date: Nov 2000 Location: Le stelle la notte sono grandi e luminose nel cuore profondo del Texas	Are they only showing up in the part where you put the Excel file, or over the whole document? __________________ Thinkin' of a master plan 'Cuz ain't nuthin' but sweat inside my hand So I dig into my pocket, all my money is spent So I dig deeper but still comin' up with lint

07-26-2005, 04:56 PM	#2
Easy Mac Registered User Join Date: Nov 2001 Location: Here	Yeah, just go to insert-->file and find the file. That should do it I think.

07-26-2005, 05:12 PM	#3
jbmagic Pro Starter Join Date: Apr 2004	here a great forum for Excel http://www.mrexcel.com/board2/index....75aca7d613b010

07-26-2005, 09:02 PM	#7
Easy Mac Registered User Join Date: Nov 2001 Location: Here	Insert -->Object-->Excel Worksheet

07-27-2005, 12:06 PM	#18
thetrilogy Mascot Join Date: Oct 2002 Location: Ohio	If you don't plan on typing/editing the Excel portion once it is in Word. An advanced technique could be to: -In Excel, do a print preview. Zoom in so that you only see what you want in the Word document. -Hit PrintScrn -Paste that image into Word. Crop and resize the image so it only shows what you want to print. You can do more advance image editing tools in Word also, so you can move it around without moving alot of the other text.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)