Excel How do I automatically populate an excel, word & outlook templates from an excel file

Joined
Sep 27, 2011
Messages
1
Reaction score
0
I am new to the world of Visual Basic & Macro's so please excuse my ignorance.


I am looking to create a macro to populate
  • Excel Template
  • Word Template
from an exsisting (master) Excel file

once these documents populated I want to create a zip file containing the newly populated templates.

and then add this zip file and the details from the (master) excel file to an microsoft outlook meeting request

is it possible to do this using macros or will I have to generate some sort of code/ script

I understand there are a lot of factors i am trying to combine into one simple command and may be trying to run before i can walk, but any input, guidance or suggestions would be greatly appreciated,
 
Back
Top