Find Jobs
Hire Freelancers

Develop basic Word Macro(s) in VBA to implement document workflow

$30-250 USD

Cancelled
Posted almost 7 years ago

$30-250 USD

Paid on delivery
I need a series of MSWord (2016) templates developed for office forms - e.g. Leave Application, Expense Claim, etc - that have workflow functionality by means of VBA macros. I want to start with a simple template that can then be used as a basis for other templates. We need a document value, 'ApprovalStatus' that needs to be initially set to '0' (not yet submitted). The form must have a field: 'Name', and a field 'Email Address'. At the bottom, we need a drop down list that will be manually populated in the code, with a label: 'Request Approval From:'. This drop down list needs to store 2 values for each row: name and email address. Like this: General Manager gm @ [login to view URL] Branch Manager bm @ [login to view URL] HR Manager hr @ [login to view URL] etc. But the email address does not need displaying. Next to that list a button labelled "Submit". This button must only be displayed if the document value ApprovalStatus = 0. We also need another button that is initially hidden, labelled "Approve". This must only be displayed if the document value ApprovalStatus = 1. The actions of the buttons need to be: SUBMIT: when this button is clicked the document value ApprovalStatus needs to be set to '1' and saved in the document to indicate that the form has been submitted for approval. The document also needs to store the requestors email addressThen the form needs to be emailed to the recipient selected in the 'Request Approval From" list. Obviously, the form will need to be in a .docx (macro enabled) filetype. The email subject needs to be: "REQUEST: Approval needed; form attached", and the body: "please find attached a form for your approval". APPROVE: when this button is clicked we need to add text to the document at the bottom that says "Approved on: <insert current date and time>, by <insert windows username>". Then the form is emailed back to the originator - we stored their email address previously - and a pre-determined email address we will store in the code. The email subject needs to be: "APPROVED: form attached", and the body: "please find attached the approved form." I have attached a basic Word template with the fields in place, except the drop down list has no data.
Project ID: 14056519

About the project

8 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
we have expertise in Word, Excel - VBA , Data processing. Client satisfaction is our main motto for long term relationship.
$150 USD in 2 days
4.8 (4 reviews)
3.0
3.0
8 freelancers are bidding on average $183 USD for this job
User Avatar
Hi, I am good at Word document and building useful scripts for my clients. I would like to know about the "Approval Status" part. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$125 USD in 2 days
5.0 (234 reviews)
6.7
6.7
User Avatar
Hello, My name is Chris. As you can see from my profile, I have 16+ years experience working with Word/VBA (among other Office apps) and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chris (chriskerpini)
$130 USD in 2 days
4.9 (44 reviews)
6.5
6.5
User Avatar
Hello Sir, I have reviewed the details and I would like to work on this Macro for Word. Please open chat to discuss more about this. Thanks Aanvik
$235 USD in 3 days
5.0 (22 reviews)
5.6
5.6
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can create Drop Down with multiple column and access the values as per requirements. I will also create word add-ins program to send email through Outlook by using VBA Programming. I will use all logic and conditions which you described in your project details. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. So, I can do this job nicely. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra
$200 USD in 3 days
4.7 (38 reviews)
5.0
5.0
User Avatar
Hello, I am proficient with MS Office and VBA and would love to help you with this project. Most of my projects were based on VBA in Excel, but I have done some projects with macros in Word too. I am sure I could do what you need. Please contact me for more information.
$180 USD in 3 days
5.0 (42 reviews)
4.8
4.8
User Avatar
Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
$180 USD in 3 days
4.8 (26 reviews)
4.6
4.6
User Avatar
Do you need PDF forms? your all requirements can be fulfilled in pdf forms with java scripting.
$264 USD in 3 days
5.0 (12 reviews)
3.8
3.8

About the client

Flag of AUSTRALIA
KARRAKUP, Australia
4.9
2
Payment method verified
Member since Jul 9, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.