Output to a Word Document

Originally Posted by SkyjinksAileron

Output to a Word Document

I would like to create an Excel Workbook that spits out two items.

1 > A Microsoft Word Document to be emailed to clients.

2 > A printed out Excel sheet for internal office use.

Both items will contain only 10 variables; ie: Date & Time scheduled, project name, project manager’s name, etc. These 10 variables are entered prior to needing the DOC and prior to printing the XLS. The original/template workbook shall never be modified. The two output items don’t need to be edited either, they are just for memo purposes. The output values in the DOC need to be 'part of the DOC' not an embedded XLS.

I’ve spent a few hours tinkering with this and a few minutes browsing the Excel for Dummies and similar books at Borders. I’ve run this by my IT guy (not an Excel wiz), my Executive Assistant (well versed in XL, she needed more time w/it) and a few others to no avail. All say it is possible, just don’t know how.

Where to go from here? I’ve got the input part down. I understand the “if” conditionals and have the XLS output down pat. I need help with how to create the output word DOC. It has to be a word DOC, not a PDF.

This needs to be done so the end users need only to enter the 10 variables. If necessary, a few other simple tasks like running a macro. I have a gracious time budget as the holidays are going to be slow.

Suggestions? Any help most appreciated. Please note I’m the noob.

Hi,

A look at http://www.mvps.org/dmcritchie/excel/mailmerg.htm might help you

---