Experts only need read please ;

  • Thread starter Thread starter Antoine
  • Start date Start date
A

Antoine

Hi,

Here's a tough one:

How do you programmatically read an email that was copied into a folder on
the hard drive (C:\MyEmailArchives) and populate a textbox (in an Access
2003 form hosted on XPPSP2 and hosting Office 2003 SP2) with the email's body?

Thank you,

Antoine
Xerox Canada, NTSG
 
I can't give you specifics, because I've never actually done something like
this, but my first thought would be to use Redemption
(http://www.dimaster.com/redemption), to open the saved e-mail. Outlook
*might* be able to do it as well, but for some reason, I'm thinking it can't.

Then once you've got that, populating the textbox with the body is as easy
as looking at the .Body property of the e-mail.



Rob
 
Antoine said:
How do you programmatically read an email that was copied into a folder on
the hard drive (C:\MyEmailArchives) and populate a textbox (in an Access
2003 form hosted on XPPSP2 and hosting Office 2003 SP2) with the email's body?
Click to expand...

In another posting you state it's an Outlook email. Then I'd suggest
asking in an Outlook newsgroup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Hi Tony,

I am using Access to store the contents of the emails that I archive on my
computer by copy pasting them into a folder at the root. However I guess you
are right, this is really an Outlook VBA question...

I'll go over there now,

Antoine Dubuc
Xerox Canada, NTSG
 
Warning!

this Chris guy is not credible.
He does not know the basics of MS Access.

-Aaron



In that case, save your email messages in a folder within Outlook, then just
link your Access 2003 database table to the Outlook folder.  Run a querythat
appends all of the rows in the linked Outlook table to an archive table
within Access.  Delete the items in the Outlook folder after they've been
archived.

Chris
Microsoft MVP




Hi Tony,
Click to expand...
I am using Access to store the contents of the emails that I archive on my
computer by copy pasting them into a folder at the root. However I guess you
are right, this is really an Outlook VBA question...
Click to expand...
I'll go over there now,
Click to expand...
Antoine Dubuc
Xerox Canada, NTSG
How do you programmatically read an email that was copied into a folder on
the hard drive (C:\MyEmailArchives)  and populate a textbox (in an Access
Click to expand...
[quoted text clipped - 4 lines]
Tony
Click to expand...
Click to expand...
Click to expand...
 
Warning!

this Chris guy is not credible.
He does not know the basics of MS Access.

-Aaron
Click to expand...


However, in this case he has the right solution.

Cheers,
Jason Lepack
 
Back
Top