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

Sep 27, 2011
Reaction score
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,


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question