Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2012, 09:30 PM
smahale smahale is offline Export Outlook emails to Access & parse certain text elements Windows XP Export Outlook emails to Access & parse certain text elements Office 2010 32bit
Novice
Export Outlook emails to Access & parse certain text elements
 
Join Date: Jan 2012
Posts: 1
smahale is on a distinguished road
Default Export Outlook emails to Access & parse certain text elements

Hello,



I am a newbie.

I have a task ahead of me, where I need to automate a process such that certain elements from incoming emails get populated as columns in a database.

An example email is as follows:

Date: Tue, 17 Jan 2012 11:56:03 -0600
Subject: [MySystem -XYZ] – Error obtaining data from EDHJ <<1010109090
Team,

There is some text here. About two or three lines.

Reminder =
New Employee Name = Doe , John
New Employee Login = JII8990

Environment = TEST

I need to extract only the following elements from the email & populate a database:
Tue, 17 Jan 2012 11:56:03 -0600
Error obtaining data from EDHJ
1010109090
Doe , John
JII8990

Any ideas how I could do this? Your help is very, very appreciated.
Thanks.

Sandra
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Outlook emails to Access &amp; parse certain text elements Export Data from Ms project to Ms access using VBA virencm Project 4 02-08-2012 03:18 PM
Export Outlook emails to Access &amp; parse certain text elements Import and Export of emails JiminSA Outlook 2 07-21-2011 04:22 AM
Objective: Automatically export email text,attachment text to DB friendly format SilentLee Outlook 0 11-14-2010 02:45 PM
Create a Custome Form and export data to Access ashleybyrdnc Office 0 03-05-2010 09:41 AM
export outlook express emails to an account within outlook 2003 zillah Outlook 0 11-23-2009 03:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft