|
Any Microsoft Office Geniuses?
|
View this Thread in Original format
| Dirk W. |
I am trying to export microsoft excel data into a microsoft word file.
I need it to take quantities ordered from an excel spreadsheet and throw them into a word document.
One line from excel is:
Customer Name QTY1 QTY2 QTY3 Total Price
I want it to take that data and make a word document for each customer name that says:
Hey, Customer Name, you ordered:
QTY1
QTY2
QTY3
and this is your Total Price: Total Price
Make sense? Any help would be appreciated! |
|
|
| Teknikol |
| In Word > Extra > Merge Print (or something like that, i've got the dutch version) |
|
|
| itsTrueSonic |
| well .. if you want to export the whole Excel spreadsheet from a different excel file, then you can do a Paste Special under Edit menu .. |
|
|
| Dirk W. |
| I pretty much need this to be an automated process where it takes each customer name and plugs in these numbers from an Excel spreadsheet onto one page. Then, makes a new page for the next customer name and so on. Each customer is receiving a letter and instead of having to plug in these numbers manually and taking A LONG TIME, I need it to plug these numbers in for me and create a customized letter for each person. |
|
|
| tu_face |
i aint no genius, but have you tried the on-screen help thing in office? its one of the few things microsoft have done well IMO..
tools>letters & mailings>mail merge, it should bring up the thing on the right hand side... |
|
|
| Boomer187 |
| figure out how to use macros. i think then you can easily do it. |
|
|
| Dr. Cfire |
| This problem would be better solved by using access. using reports in access you can easily create a form letter. |
|
|
| the-un-named |
| that or using custom written software :D |
|
|
| itsTrueSonic |
| quote: | Originally posted by Dr. Cfire
This problem would be better solved by using access. using reports in access you can easily create a form letter. |
ditto.. was going to say that.. |
|
|
| ::TranceVanDyk:: |
im did that just today. do this
1. Have the word document AND excell worksheet open at the same time.
2. Highlight the cells you want to copy. (make sure they'll fit on the word document page.
3. On the toolbar, click the copy button.
4. go to the word document.
5. put the insertion point where u want the spreadsheet cells to go.
6. on the toolbar, click the paste button.
BOOM, its there. |
|
|
| sym |
| quote: | Originally posted by ::TranceVanDyk::
im did that just today. do this
1. Have the word document AND excell worksheet open at the same time.
2. Highlight the cells you want to copy. (make sure they'll fit on the word document page.
3. On the toolbar, click the copy button.
4. go to the word document.
5. put the insertion point where u want the spreadsheet cells to go.
6. on the toolbar, click the paste button.
BOOM, its there. |
I think he wanted it totally automated.
And yea, access would have been much better for this :) |
|
|
| smokeape |
| quote: | Originally posted by Dirk W.
I am trying to export microsoft excel data into a microsoft word file.
I need it to take quantities ordered from an excel spreadsheet and throw them into a word document.
One line from excel is:
Customer Name QTY1 QTY2 QTY3 Total Price
I want it to take that data and make a word document for each customer name that says:
Hey, Customer Name, you ordered:
QTY1
QTY2
QTY3
and this is your Total Price: Total Price
Make sense? Any help would be appreciated! |
Read the Mail Merge tutorial in Word if you want to create something of the sort. I use Access to drive linked data fields in Word on a few routine memos. Excel is nothing more than glorified Word Processing and if you highlight and cut and paste into Word you get nothing more than a Word table.
:p
[[[smoke]]] |
|
|
|
|
