Saving Outlook Email As Text File Extract

Status
Not open for further replies.
R

Rich Locus

Hello Outlook Group:

I'm normally an Access and Excel VBA programmer, but my client wants me to

scrape the text from a select email address and insert it into an Access memo

column.

Does anyone know how to configure Outlook (VBA approach would be fine) so

that when an email is received in a selected account, the message would also

be extracted to a directory as a text file and then the Outlook message would

be moved to some history folder.

Once the text file exists in a predefined folder , I will just have Access

periodically check the folder for files, grab the text, insert it into the

column, and delete the text file).

Ideas?

Thanks,

Rich Locus

Logicwurks, LLC
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Here's an example:

http://www.vboffice.net/en/developers/save-emails-to-file-system

Best regards

Michael Bauer

Am Wed, 5 May 2010 17:37:01 -0700 schrieb Rich Locus:


> Hello Outlook Group:

> I'm normally an Access and Excel VBA programmer, but my client wants me to
> scrape the text from a select email address and insert it into an Access


memo
> column.

> Does anyone know how to configure Outlook (VBA approach would be fine) so
> that when an email is received in a selected account, the message would


also
> be extracted to a directory as a text file and then the Outlook message


would
> be moved to some history folder.

> Once the text file exists in a predefined folder , I will just have Access
> periodically check the folder for files, grab the text, insert it into the
> column, and delete the text file).

> Ideas?

> Thanks,
 
R

Rich Locus

Excellent Solution!!!

Thanks very much for taking the time.

Rich Locus

Logicwurks, LLC

"Michael Bauer " wrote:



> Here's an example:
> http://www.vboffice.net/en/developers/save-emails-to-file-system

> > Best regards
> Michael Bauer
> Category Manager -

> SAM - The Sending Account Manager:
>

> Am Wed, 5 May 2010 17:37:01 -0700 schrieb Rich Locus:
>
> > Hello Outlook Group:
> > I'm normally an Access and Excel VBA programmer, but my client wants me to
> > scrape the text from a select email address and insert it into an Access

> memo
> > column.
> > Does anyone know how to configure Outlook (VBA approach would be fine) so
> > that when an email is received in a selected account, the message would

> also
> > be extracted to a directory as a text file and then the Outlook message

> would
> > be moved to some history folder.
> > Once the text file exists in a predefined folder , I will just have Access
> > periodically check the folder for files, grab the text, insert it into the
> > column, and delete the text file).
> > Ideas?
> > Thanks,

> .
>
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
T Saving Outlook 2010 email with attachments but read the email without Outlook Using Outlook 2
J Saving Incoming & Outgoing Outlook 2010 Email Locally with IMAP Using Outlook 2
W I have outlook 2007, and it is not saving my contacts when I send an email, please help! Using Outlook 2
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
N Saving And Deleting Outlook Attachments with Unknown Error Message Outlook VBA and Custom Forms 1
V Saving attachment from outlook in My Documents Outlook VBA and Custom Forms 14
C Saving Outlook attachments and links to attachments with VBA Outlook VBA and Custom Forms 2
R Outlook 2010 Modify Style "Do not check spelling or grammar" not saving Outlook VBA and Custom Forms 0
R Outlook Office 365 not saving addresses Using Outlook 0
e_a_g_l_e_p_i question about saving my .pst so I can import it to my Outlook after I build a new system Using Outlook 10
J Outlook 2013 crashes saving VBA & clicking tools | digital signature Outlook VBA and Custom Forms 1
L Outlook DST (Daylight Saving Time) problem Using Outlook 0
F Using Outlook 2007 as an IMAP Mail Station Without Saving Data Locally Using Outlook 2
D File Lock issue when saving message from Outlook to new folder Using Outlook 1
K Printing & Saving Outlook Contacts Using Outlook 3
S trouble with Outlook 2010 saving sent emails Using Outlook 2
D Saving outlook emails in html and attachments Using Outlook 4
R Outlook 2007 QAT buttons not saving Using Outlook 2
C Exchange 2003 - Outlook 2003 - Calendar entries saving over each other Using Outlook 2
J Saving Published Outlook Form as msg Using Outlook 1
T Outlook 2007 alters date when saving attachments, windows 7. Using Outlook 5
T Merging contacts from Live to Outlook 2003, and saving saved emails from live Using Outlook 4
O Outlook Today Customization not saving in Outlook 2010 32-bit Using Outlook 9
C Saving Entourage 2004 for Mac files to Outlook 2011 for Mac Using Outlook 1
R Does not prompt for saving or opening attachments when downloading attachment in Outlook 2007. Using Outlook 3
J Outlook 2010 Saving Changes Issue Using Outlook 1
B outlook 2010 is not saving sent mail in sent items folder and sometimes after appearing in sent item Using Outlook 1
G Comcast Server is not saving my Mail due to Outlook Using Outlook 26
S Saving Outlook 2010 calendar as a web page... Using Outlook 1
T Saving Sent Messages in Outlook 2010 Using Outlook 1
A Outlook - saving sent messages Using Outlook 1
L Outlook 2010 not saving messages to sent items Using Outlook 2
J Saving emails from Outlook web access Using Outlook 5
J Saving emails via Outlook Web Access Using Outlook 1
I Saving and importing personal folders inside Outlook. Using Outlook 1
J Outlook Not Saving Passwords Using Outlook 2
D Opening & saving an Outlook 2010 Calendar attachment Using Outlook 4
B Error while creating/saving a new appointment in Outlook web access 2003 'You don't have permission to modify this item'. Using Outlook 1
T Problems saving appoinment on Outlook Using Outlook 1
A My Outlook stopped saving my sent emails to the Sent Items folder Using Outlook 3
F OUTLOOK 2010 SAVING SENT EMAILS ON EXCHANGE SERVER Using Outlook 2
D Outlook 2003 Saving into a textbox when form closes Outlook VBA and Custom Forms 3
T Saving Embedded Images in Outlook 2007 Outlook VBA and Custom Forms 3
D Outlook 2003 saving option button Outlook VBA and Custom Forms 1
B Outlook is not saving sent items Using Outlook 5
I Saving attachments from multiple emails and updating file name Outlook VBA and Custom Forms 0
M Adding Subject to this Link-Saving VBA Outlook VBA and Custom Forms 5
L Attachment saving and tracking - PLEASE help! Outlook VBA and Custom Forms 5
D Saving Selected Emails as PDF and saving Attachments Outlook VBA and Custom Forms 6
B Saving items under a folder Using Outlook 3
Similar threads


















































Top