PDA

View Full Version : excel + a text input box + emailling


zaknbou
12-05-2008, 01:12 PM
hi guys,

my question is the following : i want the employee to write a review including some number into an excel table with formula then he can press a send button and it would be send by email to me

could that be done ,


thanks in advance
Best regards

jassing
12-06-2008, 06:36 AM
hi guys,

my question is the following : i want the employee to write a review including some number into an excel table with formula then he can press a send button and it would be send by email to me

could that be done ,


thanks in advance
Best regards

Not really an ams question -- but yes; as long as the system either has a mapi compliant email or smtp server available-- you could do it all fairly easy in vba write in the excel sheet.

zaknbou
12-06-2008, 02:03 PM
aha thanks for your reply but what i meant is that the excel file is included inside the AMS project and the hit button is not included in the excel file but inside the AMS project ?


thanks in advance

reteset
12-06-2008, 02:21 PM
if you familiar with the LuaCom plugin
you can create a Excel Automation with LuaCom plugin
and you can write something into a Excel File

then you can send back that file to you with a SMTP mailer
there should be some SMTP tools in this forum
try search page

Note: Any version of Microsoft Office should be installed on target system

thanks