I have created a word document that can be sent as attachment when I click the submit button it sent as attachment. the document needs to be used by many people. I want the document to be blank again after it was sent.



I looked into this code, I didn't work

Doc.SaveAs2 FileName:=("S:\DATA\InformationTech\Secured\New Staff") & "\" & Environ("username"), Fileformat:=wdFormatDocument, AddToRecentFiles:=True

can somebody explain to my this code
thank you
Gaafar

If you use a Word template, every document you create from it will be 'blank'.

The code snippet you've posted is for saving a document with a new name, but is incomplete as it lacks the filename; it also has nothing to do with 'clearing' a document.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]