Cancelled

MS Word & Excel database/macro project

This project is involve following tasks:

1. Create a scipt or macro for a "[url removed, login to view]" file in MS Office that will generate MS Word files to be used for copy/paste and e-mailing. Refer to the attached "[url removed, login to view]" file for the reference.

- I need a "one click" new file (*.doc) generated from "[url removed, login to view]" template

- "one click" e-mail generated to the recepient with some custom infrmation in the "title" and "e-mail body" fields extracted from the generated *.doc file.

2. Generate file similar to "proposal ISP & UG office [url removed, login to view]" file with fields (marked in red) extracted from the newly generated *.doc file in the task #1 above. "One click" e-mail generated to the recepient with some custom infrmation in the "title" field extracted from the generated *.xls file.

Please note: the "master file" in task #1 doesn't have to be in MS Office format - i need *.doc files populated from it by filling required fields. I was thinking of using macros, however I am open for suggestions and easier solutions.

Skills: Data Processing, Excel, Order Processing, Script Install, Word

See more: excel database macros, word reference, template project proposal, proposal template project, proposal project format, proposal format project, new project proposal format, ms processing, project proposal format, format proposal project, format project proposal, doc note, open office project, master solutions, master excel, word script, ug, office install, Ms office , macro, macro excel, macro e, format word, format excel, filling database

About the Employer:
( 19 reviews ) White Plains, United States

Project ID: #1139023

1 freelancer is bidding on average $175 for this job

terwelu

This cant do with macro, but VBA code. So, the VBA code will generate the doc file and do email message creation by using Outlook Object Model Library. For task #2, it will require to access Excel Object Model library More

$175 USD in 1 day
(0 Reviews)
0.0