sending & retrieving excel data in body of outlook email

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mismarple - 21 Sep 2005 12:09 GMT

I have a handed down assignment to collect weekly employee whereabouts of
300+ in a spreadsheet. Currently the spreadsheet is updated each week by
sending out an e-mail asking for state, city, client, and contact # (example:
PA, Glenside, Rohm Haas, 555-555-5555). When the info is received by me I
must cut and paste the info from the e-mail into an excel spreadsheet per
that employee's name. There has got to be a better way. I am not a programmer
but I am application savvy. HELP This takes way to much time the way it is
done currently.

Reply to this Message

Ron de Bruin - 21 Sep 2005 16:24 GMT

Hi mismarple

See Dick's site
http://www.dicks-clicks.com/excel/olRetrieving.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>I have a handed down assignment to collect weekly employee whereabouts of
> 300+ in a spreadsheet. Currently the spreadsheet is updated each week by
[quoted text clipped - 4 lines]
> but I am application savvy. HELP This takes way to much time the way it is
> done currently.

Reply to this Message

mismarple - 22 Sep 2005 15:55 GMT

Thank you for the information. It sounds like it could be very helpful in
streamlining the project. I am NOT a programmer and know very little about
creating macros, etc. In order to use the information given I think I would
need a more hands-on source to walk me through it.

I should have included in my question that I cannot program and I am looking
for a intermediate solution rather than an advanced one.

Thank you for your time and knowledge! It is much appreciated.

> I have a handed down assignment to collect weekly employee whereabouts of
> 300+ in a spreadsheet. Currently the spreadsheet is updated each week by
[quoted text clipped - 4 lines]
> but I am application savvy. HELP This takes way to much time the way it is
> done currently.

Reply to this Message