|
| 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
October 3rd 07, 01:51 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Populate Access Table with Email Data & Save attchment as pdf or t
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. 
|
|
#2
October 5th 07, 05:44 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Populate Access Table with Email Data & Save attchment as pdf or t
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: 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.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| UserForm Listbox with Access Database Table data | RobLo | Outlook - Using Forms | 4 | March 9th 07 03:47 PM |
| Export Outlook 2003 Email Message To Access 2003 Table | Gwhit | Outlook and VBA | 1 | May 30th 06 04:36 PM |
| How do I import email addresses from an Access table? | Chris | Outlook - Using Contacts | 1 | April 7th 06 01:58 PM |
| Populate Form with Outlook Contact Data | Seagull Ng | Outlook - Using Contacts | 1 | March 1st 06 01:56 PM |
| Can custom form data populate access database | jbtempe | Outlook - Using Forms | 1 | January 20th 06 03:02 PM |
Hybrid Mode
