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