B
Brad Pears
On our website (not hosted in-house), users can order some marketing
material from us. The web designer set it up so that once the customers
personal info and credit card info has been entered and they click "Submit
Order" (we are using SSL) she generates an email to our general mailbox (we
are using Exchange and Outlook clients). A person monitoring the general
mailbox at this end then forwards the email to the apporpriate department
for processing of the credit card info and shipment of the order. As well,
customers data is entered into our customer db (exlcuding the credit card
info).
I winder if someone might have some ideas as to how I can maybe customize
the outlook client so that when one of these emails comes in, the user could
simply click on a button which would run code to do the following...
Extract the data from the body of the message and place it in the customer
db automatically (access DB), notify the appropriate department that an
order needs to be entered etc...
I have never customized anything in Outlook but do program in VB and Access
so am familiar with those languages.
How would one go adding a custom button to a particular users Outlook client
that would run code to ...
- extract data from the body of the message (each data item currently is
frontended with the field name and a ":" ie Name: Some One - where Name is
the fieldname and "Some One" is the actual customer name) and then have it
entered into the db - I would have to attach to the cust db and insert an
record using an SQL statement).
- I'd also want to automatically forward the email to the appropriate
department....
If someone could point me in the right direction that woudl be great!!!
Thanks,
Brad
material from us. The web designer set it up so that once the customers
personal info and credit card info has been entered and they click "Submit
Order" (we are using SSL) she generates an email to our general mailbox (we
are using Exchange and Outlook clients). A person monitoring the general
mailbox at this end then forwards the email to the apporpriate department
for processing of the credit card info and shipment of the order. As well,
customers data is entered into our customer db (exlcuding the credit card
info).
I winder if someone might have some ideas as to how I can maybe customize
the outlook client so that when one of these emails comes in, the user could
simply click on a button which would run code to do the following...
Extract the data from the body of the message and place it in the customer
db automatically (access DB), notify the appropriate department that an
order needs to be entered etc...
I have never customized anything in Outlook but do program in VB and Access
so am familiar with those languages.
How would one go adding a custom button to a particular users Outlook client
that would run code to ...
- extract data from the body of the message (each data item currently is
frontended with the field name and a ":" ie Name: Some One - where Name is
the fieldname and "Some One" is the actual customer name) and then have it
entered into the db - I would have to attach to the cust db and insert an
record using an SQL statement).
- I'd also want to automatically forward the email to the appropriate
department....
If someone could point me in the right direction that woudl be great!!!
Thanks,
Brad