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

Thread Tools
Display Modes


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 06:39 PM.


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