Any Microsoft Office Geniuses? - TranceAddict Forums

TranceAddict Forums (www.tranceaddict.com/forums)
- Chill Out Room
-- Any Microsoft Office Geniuses?

Posted by D Dubya on Dec-01-2004 17:20:

Any Microsoft Office Geniuses?

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!

Posted by Teknikol on Dec-01-2004 17:23:

In Word > Extra > Merge Print (or something like that, i've got the dutch version)

Posted by itsTrueSonic on Dec-01-2004 17:27:

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 ..

Posted by D Dubya on Dec-01-2004 17:35:

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.

Posted by tu_face on Dec-01-2004 17:40:

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...

Posted by Boomer187 on Dec-01-2004 17:48:

figure out how to use macros. i think then you can easily do it.

Posted by Dr. Cfire on Dec-01-2004 19:13:

This problem would be better solved by using access. using reports in access you can easily create a form letter.

Posted by the-un-named on Dec-01-2004 21:56:

that or using custom written software

Posted by itsTrueSonic on Dec-01-2004 22:00:

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..

Posted by Krypton on Dec-02-2004 01:25:

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.

Posted by sym on Dec-02-2004 01:28:

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

Posted by smokeape on Dec-02-2004 02:12:

Re: Any Microsoft Office Geniuses?

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.

[[[smoke]]]

Posted by PhloTron on Dec-02-2004 02:39:

Posted by smokeape on Dec-02-2004 02:48:

[[[smoke]]]

Bluefish - Been Too Long

Posted by D Dubya on Dec-02-2004 05:15:

Yes, hindsight 20/20 I wish I had bought the Office package with Access (I bought the Small Business package), but I figured my office didn't need it. Guess I was wrong and I don't think I can buy a standalone version.

Posted by Dr. Cfire on Dec-02-2004 06:23:

[cough] link removed [/cough]

Posted by smokeape on Dec-02-2004 06:35:

quote:
Originally posted by Miss Bliss
I saw porn once where an English girl was screaming "PUT IT IN MY DIRT BOX!!!"

BWAHAHAHAAAAA!!!! Good One.

I wasn't going to aim him to the Warez sites. For pete's sake he doesn't even know how to use Excel.

[[[smoke]]]

Gwill Morris Ft Kyla - Time (Vocal)

Posted by Floorfiller on Dec-02-2004 06:35:

i was just gonna agree with the access suggestions...i mean...that is what access does hehehe

the sql is pretty simple as well...easy to learn

Posted by smokeape on Dec-02-2004 07:20:

quote:
Originally posted by Floorfiller
i was just gonna agree with the access suggestions...i mean...that is what access does hehehe

the sql is pretty simple as well...easy to learn

Big secret is Access is most powerful software in Office Suite and the least understood. Homey here has been using it since Bill Gates first pushed Access 2.0 because I was forced to switch from dBase.

[[[smoke]]]

Bluefish - Been Too Long