MS Access VBA Outlook Automation

In Progress

I have developed a database in MS Access 2002 for handling projects. I need to link the projects in this database to email in Outlook 2002. I have already developed the database to send emails using outlook. When an email is sent, the project number is placed in the subject line along with the subject. If a reply is received, the project number will still be in the subject line.

I have a button on my projects form in my database which needs to look at the project number, then open the Inbox in Outlook, then filter the Inbox to only show emails where the subject contains the project number.

This needs to work in the same way for another button to show sent messages for the project.

I will also need a button in Outlook that when pressed will run a macro I have created in Access. This macro creates a new project number, then opens the project form and displays the project number. After the macro has run I need code which will copy the new project number on the form to the beginning of the subject of the selected email in the Inbox.

For developing purposes I would ask that you create a dummy projects form named frmProjectDetails with 2 buttons named cmdReceivedEmail and cmdSentEmail. Also the form should contain a field to display a project number named ProjectNumber. Also create a simple macro named mcrCreateNewProjectFromEmail which opens the frmProjectDetails and adds a number to the project number. With this you should be able to test your code without having to use my database. Once you have completed this project and I have received it, I will copy the code back into my current Database.

Skills: Visual Basic

See more: vba outlook automation, access vba outlook, access vba automation, vba outlook access, vba access open outlook, outlook received subject access, access outlook automation vba, outlook automation vba, vba work, vba with, ms project test, ms access work, open outlook access vba, open outlook access macro, access vba open outlook, access outlook vba, outlook automation access, outlook automation database, access vba subject contains, outlook macro subject contains, access vba buttons outlook, access 2007 vba outlook automation, send emails access vba, vba outlook subject contains, vba outlook automation receiving

Project ID: #193681

3 freelancers are bidding on average $157 for this job

crajeshbe

Hello sir, This is Rajesh. I have sound experience in Access-excel-vba programming .Please feel free to pm me for more details Thank you Rajesh

$100 USD in 3 days
(8 Reviews)
4.1
rothvin

I am an expert VBA programmer and I have done work for Bank of America, GM, Caterpillar Financial and others. I also have experience integrating Outlook with Access and Excel. I would expect payment upon delivery of More

$250 USD in 3 days
(0 Reviews)
0.0
sanathpt

Write us.. we are engaged in doing these kind of things. You'll be provided with project along with the source code

$120 USD in 2 days
(0 Reviews)
0.0