Small MS Access database to import emails from outlook
$30-100 USD
Inaendelea
Imechapishwa over 12 years ago
$30-100 USD
Kulipwa wakati wa kufikishwa
Hi, I'm after someone to develop a small access application which will loop through an outlook inbox for a specified account and
find any email with an email subject that starts with "STE" and import it as a new record into a table in the database provided.
The email will be in the format of
Subject: STE 123456 John Doe
Body: sample text
tblInquiryJobUpdateNotes will get populated with this information.
I need 123456 (job number) to go into the InquiryID field. John Doe to go into fldOperator and the body into the Notes field.
If possible I would also like the date the email was sent to go into the NoteDate and the time to go into the NoteTime field.
fldStatusType will get populated by looking up tblStatusLog and retrieving the latest status for the job entered.
Once the email is processed I need it to be moved from the inbox to a specified folder called 'Processed Notes'
Error Handling:
If someone enteres a job number which isn't in the inquiry table it won't get imported but I need an email automatically to be sent back to the senders address saying the "Job number" & ##### & "isn't in the inquiry system"
I understand Outlook redemption may need to be installed in order to do this.