Hi, if you know Excel, Word and VBA, this one is easy! Here is the program flow:
1) User enters First Name, Last Name, Address, City, Province, Postalcode into Excel (columns)
2) Clicks a button "Create Letters" and for each row that has a column "Already Printed?" marked "No" it takes a Word Template and merges the fields in for the letter (address, name, etc.)
3) Opens one document with all the merges in it, whichever works best.
** Program then updates each excel - each row gets updated to show that (this can be in a new column) it was merged and a date goes beside it in a new column as well.
** Each word document should be time stamped unique
** Since the sheet will have more names added to it regularly, program should just scan for the first "no" and include all other "nos" and it should not delete or remove any rows.
** Program must work from within one folder only
That's it...probably not more than 2 hours at most.
10 freelancers are bidding on average $27 for this job
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Awaiting your response. Thank you.
The examples of my codes you can see in my books. I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”
Hi Sir/Madam, We have expert in data services providing analysis and extracting website information using script language. data validating the outputs.