Creating Template - Macro/Mail Merge/VBA?
Hello All,
I am trying to create a Word template for our PM. Right now he is manually typing data into 7 different sheets in an Excel document and then copying and pasting them into a Word doc. I believe there must to be a more effective way to do this.
The data comes in 3 forms:
1. Simple text data (names, addresses, etc.)
2. Data in a table (will include a screenshot)
3. Simple bar graphs created from data placed in the excel doc.(will include a screenshot)
Please let me know what other information is needed to answer this question. Any help would be GREATLY appreciated.
|