Exporting emails

[Tony Cannizzo]

Exporting emails to an external file does not provide the date/time
sent/recieved.
Is there any way to get this information incorporated into the export?

Thanks.
TC

 

[Arvin Meyer [MVP]]

Exporting emails to an external file does not provide the date/time
sent/recieved.
Is there any way to get this information incorporated into the export?

Saving an email as either an email or as text preserves the header
information. If you are still having problems, I suggest you find a
newsgroup that's dedicated to your email program. This newsgroup is
dedicated to the Microsoft Access database product.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Tony Cannizzo]

Yeah, sorry about that. I deleted my message as soon as I realized I was on
the wrong board. But I am trying to synch Outlook and Access.

Perhaps I can ask the question from an Access perspective:

My Access database is my CRM. It is function-rich.
Accounts
Individuals
Notes

I would like to incorporate my correspondence with Individuals and create a
separate Notes record for each email to/from the Individual.

The Notes record would basically contain
IndividualID, Date, Text
The Text is usually some notation that I have entered from a phone call,
meeting, etc.

I am currently putting correspondence into my Notes tbl by manually opening
one email at a time and copy from Outlook and paste into Access.

Are there any recommendations on how to better integrate Access with
Outlook?

Asking the same question on the Outlook board.

Thanks
tc

 

[Arvin Meyer [MVP]]

You might try building your email form in Access with all the fields set up
the same as in Outlook, you can use the code on my website to create and
send the email:

http://www.datastrat.com/Code/OutlookEmail.txt

Here's a snippet of that code and how you would use it to read the email
from the Access form:

With objEmail
.To = Me.cboTo
.Subject = Me.txtSubject
.body = Me.txtMessage
.Send
End With

cboTo is a combobox and txtSubject and txtMessage would be text boxes on the
Access form. This way you only have to type the data once and the combo
would lookup the email address from your Access table. You can add more
fields to store a timestamp and any other data you want from the email.
Additionally, you can add other notes which are not part of the email, but
you'd store for internal use.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Tony Cannizzo]

Thought I would post this for anyone's future reference

In Access, File>Get External Data>Import>File Type=Outlook()
This brings up the Exchange/Outlook Import Wizard
It browses your entire Outlook Folder structure
Pick a folder and it gets Imported into an Access table

You get everything as separate fields in each record for each email
Recieved (date/time)
From
To
Cc/Bcc
Subject
Body (memo field)
Message size
Whether it had attachments or not
and about 20 other cool fields.