PDA

View Full Version : 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.php?sid=0fae5f9fa878e7d83475aca7d613b010
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
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
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
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
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
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
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
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
...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
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!!!!