J
John Smith
Hi:
Using Outlook and Access, both 2003, I need to export new email messages
(not contacts-I have seen lots of exporting contacts but little on actual
email messages) from Outlook directly into an Access table. I really only
need the email address (not the name of the person, but the actual email
address), date and time it was received and the subject. A site with sample
code would be perfect. Sites usually explain the processes. I want to
learn, not just get the answer.
I am told my explanations are usually as clear as mud, so I will try another
method of explaining in hopes someone can understand me, lol.
In an Access form, click a command button (Command00) that will check my
email account for new messages (unread ones). If there is a new email,
extract the email into my table. Cycle thru all new emails. When there
are no more, close Outlook.
I guess it would be cool if after extracting the email, the email was moved
to the Extracted folder in Outlook, but that is gift, not a requirement for
now.
JS
TIA
Using Outlook and Access, both 2003, I need to export new email messages
(not contacts-I have seen lots of exporting contacts but little on actual
email messages) from Outlook directly into an Access table. I really only
need the email address (not the name of the person, but the actual email
address), date and time it was received and the subject. A site with sample
code would be perfect. Sites usually explain the processes. I want to
learn, not just get the answer.
I am told my explanations are usually as clear as mud, so I will try another
method of explaining in hopes someone can understand me, lol.
In an Access form, click a command button (Command00) that will check my
email account for new messages (unread ones). If there is a new email,
extract the email into my table. Cycle thru all new emails. When there
are no more, close Outlook.
I guess it would be cool if after extracting the email, the email was moved
to the Extracted folder in Outlook, but that is gift, not a requirement for
now.
JS
TIA