Thread: Outlook forms to Excel Spreadsheet

I am trying to create a form in Outlook that will post data to an excel spreadsheet when the user sends the email.

For example:

When a customer calls into our production office, we have to send an email to the sales rep and we have to log the call into an excel spreadsheet. I would like to make it so all the user has to do is fill out a form in Outlook that will send the necessary email AND save the data to a workbook in excel. (Or vice versa).

Any help would be appreciated! If anyone has a link to a good tutorial or can provide any assistance, I would appreciate it.

Essentially, the information to be entered into the form are:

Date
Sales Rep
Company Name
Company Contact
Company Phone
Order ID
Notes

The excel workbook will (hopefully) display the same information.

Thanks,

Dan

One way (the easy way, IMO) is to simply send the email with that information written in the body, then use the Application_ItemSend Event to write the information to a worksheet.

Or you could create and publish an email post form with textboxes for those fields, and then essentially do the same thing: send out the form, and use the ItemSend Event to write the information to a worksheet.

HTH

I am trying to do a simular task. I am trying to figure out how to have information from a MS Office Outlook e-mail form (i.e combo box) update an Excel spreadsheet after the e-mail is sent. The fields are
Name
Rank
Date
Location
Action

Does anyone know how this is done?