Populate Access Table with Email Data & Save attchment as pdf or t

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We receive work instructions via email.
The Subject, From, Date, fields contain valuable data.
Attached to the email is a pdf.
I want to click a buttonin OL to accept the current email as a new job.
Its data should be parsed and entered into a new record in access.
Its pdf should be saved as "c:/workorders/job" & [autonum] & ".pdf"

Please point me the right direction to get Access 2003 & Outlook 2003
working together like this.
 
You might start with parsing the data. You can either access one item via
Application.ActiveInspector.CurrentItem (for an opened item) or
Application.Selection(1) for one in a folder selected item.

The data is in the item's Body property. You can use the Instr function to
find any text positions in it and the Mid function to read parts of the body
into a variable.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Wed, 3 Oct 2007 05:51:00 -0700 schrieb Gavski:
 
Back
Top