|
-
Mar 10th, 2004, 02:36 PM
#1
Thread Starter
Lively Member
Getting email body/from address....
I want to have a Macro in Outlook 2k2 that'll......
When new mail arrives, get me the from address, and the body of the email.
Once I can get the data I can do the rest of the coding, but I'm stuck with this part.
I found sample code on MSDN, but don't understand fully what is going on, and would rather not use it until I understand it.
I altered it so far to:
Private Sub Application_NewMail()
Dim objItem As Outlook.MailItem
Dim objMailItem As Outlook.MailItem
Dim sEmailAddress As String
Dim sSubject As String
Dim sBody As String
Dim fromAddress As String
Set objItem = Application.GetNamespace("MAPI").GetDefaultFolder(olFolderInbox).Items(1)
sBody = objItem.Body
MsgBox (sBody)
End Sub
I don't get the whole OutLook.Mailitem stuff, etc., why it's being declared, what the heck it is, etc.
And, I don't know how to get the sender email address, I can get the name, but not sure what else to do......
Thanks a lot.....
10k
I know where Mulder is.....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|