I'm trying to write a macro that gets data from a spreadsheet and puts it in
a word document say mydoc.doc.
(I've got this bit sorted ok)

Once it has gathered all data from excel, it should save the document with a
different file name,e.g. mysaveddoc.doc and email it.
(i can do this bit too) using activedocument.saveas filename:=mysaveddoc.doc

it should then close the saved document, i.e. mysaveddoc.doc and open the
original document,i.e. mydoc.doc and repeat the process. (it will get the
data from a different row on the spreadsheet but that is neither here nor
there)

Any ideas?

TIA