title: vba code to create a temporary worksheet and have data mail merged to word then the temporary sheet is deleted
body: <p>I'm using excel 2010. I would like to see if a new temporary worksheet can be created from 2 other worksheets and data mail merged to an existing word document. Then the temporary worksheet be deleted or maybe saved and reused as a new temporary worksheet. All this in a vba form. Thanks.</p>