I need someone to write visual basic code that will allow better efficiency in performing routine tasks in Outlook, Excel, and Access.
The programmer needs to speak and write in English.
The programmer needs to have experience with Microsoft Access database design: Tables Forms Reports Queries Modules and Visual Basic
The programmer needs to have experience with Microsoft Outlook: Office suite integrations using Visual Basic
The programmer needs to have experience with Microsoft Excel: Office suite integrations using Visual Basic
I need some custom buttons that will perform specific tasks related to MS Office products. These custom buttons will reside inside of the menu/ribbon and they will be stored associated with the MS Office file that is open.
I'd like to take the project as one task at a time. Once I see progress/completion of a task, I can provide other tasks.
An example task:
I need a button in Outlook that when clicked will prompt me for a new project name and client code (10 digits max, 2 digit minimum). This project name/code will be stored in memory and it will then be written to a new folder in Outlook in a certain Project year folder. The presently selected email will then be moved into that folder. The name/code will also be written to certain fields in a specific Access database table as a new record. Certain other fields in that same record will be automatically populated (such as the present date). Also, the name/code will be used to create a new project folder/directory in Windows Explorer in a particular project year. Then, the attachments of the email will be saved into that windows explorer folder. If the button is pressed and there is already a folder/project by the same name, then there needs to be options to: 1) type a different project name 2) change existing folder and database project name and client code.
3 freelancers are bidding on average $54/hour for this job
Previosly worked with [url removed, login to view] interface for excel and also always using access database for desktop so great exp in Vb And C# also.........See portfolio for some previous work....THank you sir