YellowLabPro
03-17-2007, 08:46 AM
I have a fun one here.
I have a worksheet that looks up the email address:
=IF(G5="","",VLOOKUP($G5,CompInfo!$A$2:$M$199,10))
which resides in F9.
What I thought would be good fun is to be able to click on that cell or another button that would look at F9, close the workbook, attach it and send the workbook to that email address, possible?
Thanks,
YLP
ps. I will be gone for most of the day.... I will check back in tonight.
I have a worksheet that looks up the email address:
=IF(G5="","",VLOOKUP($G5,CompInfo!$A$2:$M$199,10))
which resides in F9.
What I thought would be good fun is to be able to click on that cell or another button that would look at F9, close the workbook, attach it and send the workbook to that email address, possible?
Thanks,
YLP
ps. I will be gone for most of the day.... I will check back in tonight.