Solved: Excel form linking to word document problem

[Spratt_Cary]

First of all, VBA for excel and VBA for word is so different for me as a new beginner. Uuuuggggg. Problem is:
I have a excel form that stores information in a spreadsheet and the save command button saves the exel spreadsheet, closes the excel spreadsheet and then opens a word template. Specific data in the excel spreadsheet is linked to the word template using copy/paste special/Paste link\Unformatted Text.
I would like to create the following macro. When the word template opens I would like to see the saveas window immediately and perform a saveas and then I would like to break all the links to the spreadsheet without losing any of the information.
Can this be done? Any help will be greatly appreciated. And thanks in advance.:banghead:

[mdmackillop]

Either:
Open the Word document and use Excel to place the text into defined bookmarks
Create a mailmerge document in word. This can be opened from Excel to create a new document.
Check out the KB (http://vbaexpress.com/kb/getarticle.php?kb_id=818)