My main macro pulls data from several .xls files into three worksheet
in one file, processes that data, then depending on the value of
specified cell, sends up to three e-mails; each e-mail sent has one o
the worksheets attached as an .xls file. All of this works fine.

I now want to make the e-mail sending process a two-way street: I wan
to make the outgoing e-mail attachment, in 'ThisWorkbook' module
contain 'BeforeSave Events' code that, after the user modifies the .xl
file (explains why he/she received such e-mail), saves such modifie
.xls file to a specified location, and sends a return e-mail with suc
modified file as an attachment. Part of the problem in doing this i
how to create the outgoing attachment; when it is saved, it wants t
execute the 'BeforeSave Events' code.

I would appreciate any suggestions.
TIA,
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=40047