ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing from Outlook (https://www.excelbanter.com/excel-programming/318515-importing-outlook.html)

semiaza

Importing from Outlook
 
Hi folks - wondering if someone can put me right:

I receive emails generated by an Outlook Template. The email has a 1
page form (p.2) and that form contains three textboxes (textbox1,
textbox2 etc). I'm trying to get Excel to access the data in these
textboxes and import it into a worksheet but for the life of me I can't
figure out how. Best I've been able to do is copy the body of the email
(not what I need). Here's the vba I need to work on:

For Each pMail In Fldr.Items
If InStr(pMail.Subject, "Test") 0 Then
ActiveSheet.Cells(i, 1).Value = ????
i = i + 1
End If
Next pMail

Where ???? is the code I need help with. I've looked everywhere I can
find but can't find any information on importing from forms. Anybody
got any clues at all?

TIA

Semiaza.



All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com