How to make outlook communicate with excel file

[Guest]

I work for an internet company that sells around 4000 products. Our
inventory is currently in an excel file. Whenever an order comes in via
email, we must go in and manually remove the items from the inventory. We
are looking for a way to have the inventory reduced automatically when the
email comes into our computer system. Do you know if excel is capable of
performing this function? Any suggestions would be greatly appreciated.
Will the excel file that we currently have our inventory in interface with
any shopping cart that you are aware of?
Roberta Wuerth

 

[Roady [MVP]]

Excel is not meant to be used for such actions. You might want to consider
using a database solution.

 

[J Blessing]

Robert is of course correct. It would be far better in a simple database.
You would then need some script in the Outlook Application_NewMail event to
process the email. Which needs a programmer.

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

Excel is not meant to be used for such actions. You might want to consider
using a database solution.

--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003


-----

I work for an internet company that sells around 4000 products. Our
inventory is currently in an excel file. Whenever an order comes in via
email, we must go in and manually remove the items from the inventory.
We
are looking for a way to have the inventory reduced automatically when
the
email comes into our computer system. Do you know if excel is capable of
performing this function? Any suggestions would be greatly appreciated.
Will the excel file that we currently have our inventory in interface
with
any shopping cart that you are aware of?
Roberta Wuerth