VBA Macro to generate word letters

Budget $30 - $150 USD
Bids 17
Average Bid $95
Status Closed

I have started a project in Excel VBA but run into problems. I need somebody to finish it for me.

The proect is to produce a series of Excel Macros to create some personalised letters and their address labels.

The main Excel dashboard is to have 3 command buttons :-

1) Import contacts from Outlook - this is done

2) Edit one of two templates. The user can select one of two templates (called "KIDS" and "TEMPLATES") and edit them within Word. Excel just allows the user to open select the template from a drop down.? Depending on the value chosen, the relevant file is open. This is virtually complete.

3) Create letters and labels. This is has to be done. For every name that is extracted from the Outlook, a seperate word file has to be created - based on the template chosen (so another drop down is required here) - this has to be populated with all the address details for that contact. The letter needs to be saved in the share - with the filename set to the full name of the contact person.

In addition a series of address labels is needed. There also needs to be the option of printing the labels / files.?



Get Free Quotes For A Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • Byambajargal Profile Picture


    Ulaanbaatar,  Mongolia

    I have master degree on Computer Science (Russia) . One of author and software adviser of Oxford English-Mongolian dictionary. Main field of work: VBA, Java, Pascal, FORTRAN language and Data Structures and Algorithm.

  • jason79vw Profile Picture


    United States

  • SafonovAlexey Profile Picture


    Minsk,  Belarus

  • nafarin Profile Picture



    Greetings! I am VB and Excel Expert with 6 years experience in freelance projects. I hold Computer science degree and also have decent knowledge in Mathematics. My goal here to finish the projects with good quality, on-time delivery, and good communication. I have finished over 100 projects in Visual Basic (VB) dan Excel in the past 6 years. I also do some PHP programming. Here is my projects summary in VB, Excel, and C++ : - VB Projects : Windows Desktop Software, Computation/Finance Software, etc. - Excel Projects : Excel Apps, Excel Macro (VBA), Data Entry Automation, Data Processing, etc. - C++ Projects : Windows System, Security, etc.

  • chandreshkumarlx Profile Picture
  • pShankar2 Profile Picture


    Bangalore,  India

  • slavisatosic Profile Picture


    Banja Luka,  Bosnia and Herzegovina

    ## BIO I am graduated engeneer of electrical engineering - computer science (in my country it is little above B.Sc.E.E., 5 years of under graduate study). Working almost 10 years in local companies as a database and softwer designer, programmer and system administrator. Also made several information system projects (alone, as well as together with team of experts). Now finishing postgraduate studies in area of database and SQL optimisation. ## Area of Expertise MS Access, VBA, Visual Basic, Visual Basic.NET, SQL Server, C#, ASP.NET

  • JackWorm Profile Picture


    Dhaka,  Bangladesh

    I have been doing online freelance jobs for almost 5 years now. I have done many jobs on online job sites. I want to share my expertise also with the clients here.

  • customizedata Profile Picture


    lahore,  Pakistan

    Dedicated and hard worker

  • shikhamehta Profile Picture


    Pune,  India

    I am an experienced Business Process Automation and Optimization professional with over 11 years of experience. My expertise include solution development in MS Office - Word, Powerpoint, Excel, VBA/Macros, Dashboard and Report creation and Power BI, Python etc. Over more than 9 years of working here on Freelancer, I have built a team of consultants and we have delivered process automation solutions in PHP, Wordpress, C# .Net, and many more. Me and my team have experience of working with corporations like HSBC, Capgemini, Daiichi-Sankyo, American Express, Bank of America, Merrill Lynch, Equity, RedHare, Octoship, Most-Wanted and so on. We have also taken up servicing projects where we provide data extraction and Financial Modelling services to our clients. We have worked with clients all across the globe and have been consistently rated Excellent for the quality work we do. Contact me for your project requirement and my team will be happy to assist you.