Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

open email from ms access

Status
Not open for further replies.

abenitez77

IS-IT--Management
Oct 18, 2007
147
US
I have an ms access application that connects to sql server. I have a column that contains email with attachments (varbinary(max) column). I want to open the email with the attachment in outlook from my ms access application and if i can open it in my form it would be great if not then within outlook outside of ms access is fine.
 
What format are the emails stored in?

I would suggest you extract the file to a temp file, using a version of BlobToFile, then use ShellExecute to open the file in the registered application.

If it's an html message, then you may be able to play with the web control, but that would still require extracting to a temp file.

hth

Ben

----------------------------------------------
Ben O'Hara
David W. Fenton said:
We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top