Prepare a VBA subroutine.
- or -
Post a project like this2903
$$$
- Posted:
- Proposals: 8
- Remote
- #1121661
- Awarded
I am certified Microsoft Professional.. With 20 year plus experience in IT, I am expert Excel , VB and VB.net and Python programmer, Desktop Aplications & MS Office Integration and automation
Lahore
351470573552660034739889917239105071211445291201491
Description
Experience Level: Expert
General information for the business: CAD Services
Kind of development: New program from scratch
Description of requirements/functionality: I need a VBA subroutine that I can use in a Microsoft Outlook script rule.
I need the script to push text from the body of an email into an excel worksheet.
Each new email would push text to a new row of the worksheet so I can build up a record of the data contained in the emails.
The email body is formatted to contain key value pares of text such as "Project Client : Microsoft". The value part e.g. "Microsoft" would be pushed into an excel column headed with the corresponding key e.g. "Project Client". There will be about 12 such pairs to handle.
The script will be activated on email 'Send'.
The script should open an instance of Excel if it is not already running, push the data to the correct rows and columns then save and close that instance.
I am using Microsoft office version 2013.
OS requirements: Windows
Extra notes:
Kind of development: New program from scratch
Description of requirements/functionality: I need a VBA subroutine that I can use in a Microsoft Outlook script rule.
I need the script to push text from the body of an email into an excel worksheet.
Each new email would push text to a new row of the worksheet so I can build up a record of the data contained in the emails.
The email body is formatted to contain key value pares of text such as "Project Client : Microsoft". The value part e.g. "Microsoft" would be pushed into an excel column headed with the corresponding key e.g. "Project Client". There will be about 12 such pairs to handle.
The script will be activated on email 'Send'.
The script should open an instance of Excel if it is not already running, push the data to the correct rows and columns then save and close that instance.
I am using Microsoft office version 2013.
OS requirements: Windows
Extra notes:
Rob K.
100% (16)Projects Completed
22
Freelancers worked with
21
Projects awarded
38%
Last project
8 May 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies