Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing to Excel from an Outlook Form
Hi all.
I'm posting the solution to this problem incase anyone runs into this in the future. My problem was that I needed to import the data from TextBoxes in a form in an email generated by an Outlook template. The solution is as follows: For Each pMail In Fldr.Items If InStr(olMail.Subject, "Subject Title to Search for here") 0 Then Set objItem = pMail.GetInspector.ModifiedFormPages("NAME OF FORM PAGE HERE") ActiveSheet.Cells(i, 1).Value = objItem.TextBox1 ActiveSheet.Cells(i, 2).Value = objItem.TextBox2 ActiveSheet.Cells(i, 3).Value = objItem.TextBox3 i = i + 1 End If Next pMail where objItem is declared as an object and pMail as a Variant. References: Microsoft Outlook 9.0 Oject Library and Microsoft Forms 2.0 Object Library have to be installed. Thanks to Bob Phillips for pointing me in the direction of this solution. Semiaza. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Text from Outlook into Excel | Excel Discussion (Misc queries) | |||
Importing Excel via Outlook | Excel Discussion (Misc queries) | |||
How to set up reminders in Outlook when importing from Excel? | Excel Discussion (Misc queries) | |||
Importing from Excel in to outlook | Excel Discussion (Misc queries) | |||
Importing Excel -> Outlook Calendar | Excel Discussion (Misc queries) |