A
A1pro
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
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