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.
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.
Welcome to the Forum!
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.
Essentially, the information to be entered into the form are:
The excel workbook will (hopefully) display the same information.
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.
Outlook form to Excel spreadsheet
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
Does anyone know how this is done?
Why not use excel to create the message & store the data after sending the email?
Try this workbook.
Fill in the details on the Form sheet
Click the button to send the message & save the details
Re: Outlook forms to Excel Spreadsheet
Ive tried this (thinking of borrowing the concept)
But I get the error message attached.
Can anyone help?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1