I am trying to create a form in Outlook that will post data to an excel spreadsheet when the user sends the email.
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.
Sorry for the delay in responding. This is a newly added forum. Can you provide more details about what information will be entered into this form and what will be placed into the Excel workbook? I am assuming you are talking about a VBA UserForm in Outlook as a user interface, is that correct?
Last edited by Leith Ross; 12-26-2008 at 11:49 PM.
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.
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