Closed

VBA Macro to generate word letters

This project received 17 bids from talented freelancers with an average bid price of $95 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $150 USD
Total Bids
17
Project Description

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.?

Thanks

Kaps

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online