adammgrier
New Member
- Joined
- Aug 16, 2010
- Messages
- 1
Attached is an example file.
When I click the checkbox I would like a date/time stamp to appear in the cell to the right, and then an email to be generated.
The email needs to be addressed to the author at the address specified on the separate sheet. [I would actually prefer not to require the separate sheet if it can be avoided since 1. all of the names in the author range will be in the same format of Last Name, First Name and 2. all of the authors use the same domain of (FirstName.LastName@xxx.com)]
The information in the email needs to be as specified
To: Author
Subject: "Item Number xxx (from column A) is effective"
Text body: Document Number(s) from column D
<table style="border-collapse: collapse; width: 102px; height: 20px;" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 15pt;" height="20"><td style="height: 15pt; width: 68pt;" width="90" height="20">
</td> </tr></tbody></table>
When I click the checkbox I would like a date/time stamp to appear in the cell to the right, and then an email to be generated.
The email needs to be addressed to the author at the address specified on the separate sheet. [I would actually prefer not to require the separate sheet if it can be avoided since 1. all of the names in the author range will be in the same format of Last Name, First Name and 2. all of the authors use the same domain of (FirstName.LastName@xxx.com)]
The information in the email needs to be as specified
To: Author
Subject: "Item Number xxx (from column A) is effective"
Text body: Document Number(s) from column D
<table style="border-collapse: collapse; width: 102px; height: 20px;" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 15pt;" height="20"><td style="height: 15pt; width: 68pt;" width="90" height="20">
</td> </tr></tbody></table>