creating a macro


1)There are word files in a folder which relates to payroll with employee no in file name which starts.

2) There is a excel file stored with the employee no, email adress , employee bame, password to protect for each employee.

A macro need to be created

This word files need to password locked by edit access locked. Edit access lock can be one number For eg 1234 for all files. Word file should be password protected is different for each employee. employee x 1943, employee y 2233. This is stored in a excel file input 2. once its locked the word file should be send as an attachment in outlook in line witht the employee no in word file and to the employee no's email adress as per input 2. The outlook mail with a standard subject and standard mail mentioning the employee name in input 2 should be send .

Taidot: Excel, Microsoft Access, Visual Basic, Microsoft Outlook, Visual Basic for Apps

Näytä lisää: how to create a macro in excel 2010, how to create a macro in excel 2019, how to create a macro in excel 2007, how to create a macro in excel 2016, how to create a macro in excel 2013, macro excel tutorial, excel macros examples, macros in excel for beginners, creating macro copy excel paste program, creating macro permutation excel, creating macro excel developer profile, edit model number oscommerce, lock number excel, creating macro filling form excel, creating macro generate labels, lock number excel drop, macro inputs, macro inputs outputs, edit display number products oscommerce, creating macro graphic position

Tietoa työnantajasta:
( 0 arvostelua ) United Arab Emirates

Projektin tunnus: #24096897

Myönnetty käyttäjälle:


Hi, Good Day! I can help you in creating a Automated tool that can do what you needed in word and excel file. The tool can also email your files automatically to list of email in excel using MS Outlook. Please message Lisää

$25 USD 1 päivässä
(37 Arvostelua)

8 freelanceria on tarjonnut keskimäärin 32$ tähän työhön


Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets Lisää

$30 USD 1 päivässä
(90 arvostelua)

I have extensive knowledge in Excel VBA, Data Processing, Web Scraping, Web Search and Data Entry as well. Am 100% sure that i can complete your work, kindly contact me for more discussion about the project

$20 USD 1 päivässä
(8 arvostelua)

Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language Lisää

$15 USD 1 päivässä
(1 arvostelu)

Hi, How are you? I have checked your project description now. As far as I understood, you want to vb macro and I am familiar with this. I will help you to do this. Let me know if you have interests. Thanks.

$100 USD 1 päivässä
(0 arvostelua)

Greetings, I will be very glad to have this opportunity. Thank you very much. As per requirement, I would like to share with you that I have good experience of more than 10 years in the IT field especially in MS Offic Lisää

$27 USD 7 päivässä
(0 arvostelua)

Hi sir, This is Ravi Samarth from india i have work experience for the same in HR department for five years.

$20 USD 1 päivässä
(0 arvostelua)

We have a team of computer experts. I am a team program developerr software and have worked extensively on exel software so I can succeed in writing macro.

$20 USD 7 päivässä
(0 arvostelua)