|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
May 6th 10, 02:37 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Saving Outlook Email As Text File Extract
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 
|
| Ads |
|
#2
May 6th 10, 08:44 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Saving Outlook Email As Text File Extract
Here's an example: http://www.vboffice.net/sample.html?...7&cmd=showitem -- Best regards Michael Bauer - MVP Outlook Category Manager - Manage and share your categories: SAM - The Sending Account Manager: http://www.vboffice.net/product.html?lang=en 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,
|
|
#3
May 6th 10, 11:13 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Saving Outlook Email As Text File Extract
Excellent Solution!!!
Thanks very much for taking the time. -- Rich Locus Logicwurks, LLC "Michael Bauer [MVP - Outlook]" wrote: Here's an example: http://www.vboffice.net/sample.html?...7&cmd=showitem -- Best regards Michael Bauer - MVP Outlook Category Manager - Manage and share your categories: SAM - The Sending Account Manager: http://www.vboffice.net/product.html?lang=en 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, .
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| extract data from the Outlook.NK2 file | Sue | Outlook - Using Contacts | 6 | November 26th 08 03:46 PM |
| SAVING A DISTRIBUTION LIST AS A TEXT FILE | CSFS, Inc. | Outlook - Using Contacts | 1 | November 1st 08 08:27 PM |
| Saving email messages as raw text | [email protected] | Outlook - General Queries | 1 | May 27th 07 03:09 PM |
| Saving an email in .txt file | Maggie Helton | Outlook and VBA | 1 | August 23rd 06 06:54 AM |
| extract all the text from a email in outlook | .·:m·a·r·l·a:·. | Outlook - General Queries | 4 | August 19th 06 08:50 PM |
Linear Mode
