Creating report in Word from data that is in Excel

[RobM]

Hi, not sure if I should post this question in the Excel
forumn or this one but I thought I would try here first.
I would like to create a Word Doc / report based upon
vallues of data that are in an Excel Spreadsheet. I am
looking to import selected columns of data based on
criteria of the Excel Cell. Example:
the Excel document contains the following cells of data

A1 B1 C1 D1
NAME ADDRESS Contact info Status

Mickey Orlando Walt Available
Donald Orlando Walt busy

the word document needs to have the following:
Name, Contact info only if the status of the individual
is available

so my report would look like
Mickey, Walt Available

any help would be greatly appreciated
thanks again
Rob

 

[Terry]

Please let me know about any responses. I'm working on
something very similar to what you want to do.

 

[Doug Robbins - Word MVP]

Hi Rob,

Have you considered using Mail Merge with the Excel spreadsheet as the data
source?

Or, see the article "Access a database and insert into a Word document the
data that you find there" at:

http://www.mvps.org/word/FAQs/InterDev/GetDataFromDB.htm

and "Control Excel from Word" at:

http://www.mvps.org/word/FAQs/InterDev/ControlXLFromWord.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Guest]

Doug Thank you for the inofrmation, I will take a look
and attempt to achieve this and post back my results when
I complete it. thank you again