Analyze Incoming E-Mails - Microsoft Outlook - Visual Basic - VBA - VB.NET - Macros - send .oft message - write to file


I am looking for an VBA expert to carry out this project and for a long-term business relationship with the aim to maybe further develop the current project and maybe for other projects.

If you are placing ab bid, I send you further and very detailed information. This allows you to evaluate the extent of this project very precisely.

By placing ab bid you agree to an Intellectual Property Agreement, to a NDA and to a IT Security Agreement. See more information at the end of this post.

Better view: @ details: pdf attached.

I. General intention

a. The code is supposed to analyse incoming e-mails and implement certain procedures according to the analysis.

b. We envision the code to be in VBA.

c. The code is written in English

d. The incoming e-mails are written in German. German language skills not needed.

e. In case you believe that there is a better way than VBA to reach our goals, please let us know. Thank you.

II. Summary

a. In our current project, there are 3 origins, from which incoming e-mails come from

i. We send out an initial e-mails and get a reply

ii. We send an CRM based automated e-mail, with certain readable “tags” to ourselves

iii. Unknown origin

b. Scan incoming e-mails, scan for

i. Meta Data

1. Certain from e-mail addresses / domains or parts of e-mail addresses

2. First name, last name, date sent

ii. Text

1. In header of e-mail

2. In body of e-mail

a. 100% clearly defined text (our tags)

b. 23 different kind of data by characteristics, e.g. Name, Lastname, …

c. If data is available: Scan e-mail body for 5 different sets of data of the 23 before mentioned kinds of data.

c. The scan will analyse 5 different type of e-mails.

d. Extract data from e-mail, store in variables

e. Action

i. Write extracted data to certain file (.xlsb preferred, .csv possible) AND / OR

ii. Send automatically an e-mail, if incoming e-mail meets certain criteria, according to the SCAN > II.b. e-mail should be sent from an .oft, that is saved locally e.g. C:\Users\.... Certain information (Name, Salutation) will be taken from the incoming e-mail and will be filled in the e-mail that is to be sent. AND

iii. Shift e-mail from one folder to another

III. Mode

The VBA code should be written in a way, that offers two modes in which the code can be applied to Microsoft Outlook:

a. Real-time mode for inbox. Code should scan all incoming e-mails in real-time.

b. On demand & dedicated mode. Should be able to be used for specific folders in which e-mails have been stored. VBA Code should offer possibility to process e-mails of entire folders. Should be manageable through clicking.

IV. Scope

a. The code should be written in a way that it works for several users simultaneously (with only minor changes (file locations of .ofts e.g.).

b. The code will always run locally on an endpoint.

c. An endpoint may be a laptop or personal computer.

V. Platform

a. The VBA Code should run on Microsoft Windows 10.

b. The VBA Code should run on Microsoft Outlook 2016 and all higher Versions, e.g. Microsoft Office 365 and M365.

By placing ab bid you agree to following: 1) Intellectual property Agreement. Intellectual property of the code your programming and your work with this project is transferred from you to us, granting us exclusive rights to use the code and results of your work in an unlimited way, especially in terms of time and region. 2) Non Disclosure Agreement: You agree to keep all information associated with this project and the collaboration with us confidential. Your warranty to keep the information confidential will remain after the project is finished. 3) IT Security Agreement. You guarantee your work complies to common IT security standards and you guarantee to use high professional & state of the art IT security software and solutions on the systems you are coding and only send us IT secured and tested files and code.

I am looking very much forward to your feedback / bid / engagement / creative solution / coding!

Best regards,


Skills: Visual Basic, VB.NET, Microsoft Outlook, Coding, Programming

See more: outlook visual basic xml, outlook visual basic attachments, outlook visual basic scripting support, outlook visual basic mail arrived, outlook visual basic autoresponder, automatic email sending outlook visual basic, outlook visual basic start macro automatically, outlook visual basic extract, outlook visual basic macro web service, microsoft access visual basic google apps api, extract email message outlook visual basic, read mails outlook visual basic, export outlook visual basic, drag email outlook visual basic, forwarde email script outlook visual basic, convert visual basic project vb net, convert visual basic project vb net project, auto forward incoming mail outlook visual basic, visual basic learn vb net

About the Employer:
( 4 reviews ) Berlin, Germany

Project ID: #30214164

13 freelancers are bidding on average $243 for this job


Hello, Instead of VBA, I can develop a professional .Net Outlook Addin component that will do this job. I have done many similar projects in the past. Please invite for discussion. Thank you, Usman

$450 USD in 6 days
(87 Reviews)

Hi Ben, As discussed via our chat, this project is significant in its depth. I can achieve all your requirements in VBA, but this will require a lot of development time. Please review the discussion thread and let me More

$500 USD in 21 days
(21 Reviews)

Hi, We have a team of enthusiastic and hard working [login to view URL] experience of varying from ~ 13 years to ~5 years in providing solutions for plugins,add-ons for all the Microsoft office products(Office , excel More

$285 USD in 7 days
(52 Reviews)

Dear Client, I'm expert in VBA and I can achieve your goal with above functionality. Let’s have a quick chat to discuss this project. Regards, Ritika Keshri

$550 USD in 7 days
(5 Reviews)

Hi there, I have fully read and reviewed the attachments that you have provided. I am well experienced and able to work on your project. I am well experienced in skills such as VBA, MS Outlook, and programming. Please More

$120 USD in 7 days
(18 Reviews)
(4 Reviews)

Hi I have good experience in Excel and Excel VBA and outlook VBA. We can help you meeting your requirement. We agree with your terms. Please initiate chat to discuss in detail to understand your requirement clearly.

$67 USD in 2 days
(9 Reviews)

Hi There, Greetings! I have read the project requirement very carefully and I am very skilled in it. With 9+ years of experience in Excel, VBA, VB.NET, SQL/PLSQL, I can deliver the project with 100% quality on t More

$166 USD in 10 days
(1 Review)

Dear Client ; Thanks for inviting this project for me. i am working with over 10 years of Experian software developing. Kindly message me for your project details. thank you.

$94 USD in 10 days
(3 Reviews)

Hello I have gone through the pdf thoroughly and am applying thereafter as per our discussion. Please let me know your thoughts and when to start working from.

$150 USD in 14 days
(1 Review)

Hi, I can do that in VBA but if you have a business licence for office 365 that maybe it would be better to do it in power automate. waiting for more details?

$111 USD in 5 days
(1 Review)

MASTERS SOFTWARE ARCHITECTURE EXPERT IN THE NAMED SKILLS HELLO, I have read the instructions keenly and understood your specifications for the task. I have over 7 years’ experience in this field and have adverse exp More

$85 USD in 2 days
(1 Review)

Hello, Ben! Thank you for inviting me. I've researched your project. So, i did the similair project at my office, and i can do the same for you. I will need about two weeks for coding and testing.

$550 USD in 14 days
(0 Reviews)