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.
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
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
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
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.
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.
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!
Bu iş için 13 freelancer ortalamada $243 teklif veriyor
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
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
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.
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.
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.
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?
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.