i have a small form
employeenumber ---textbox
employee name ---- textbox
employee department ---- textbox
employee sal ----- textbox
employee age ---- textbox
now i have a webpage with search textbos
employeenumber ----- textbox (search crtiretia)
when user types employee number all the sql realted data should fill the form conataineing employee name, sal, age , dept etc.
next
i have 2 buttons
excel export
automail
in excel export i have a specified format
WHAT I ACTUALLY NEED IS
WHEN I CLICK EXPORT BUTTON TEXTBOX DATA SHOULD BE SEND TO EXCEL FILE
AND PARTICULAR TEXTBOX DATA SHOULD BE RECEIVED AT PARTICULAR CELL.
E.G:- TEXTBOX1 TO SEND TO C3 OR C4
TEXTBOX 2 TO SEND G9
WHEN I CLICK MAIL BUTTON
THAT DATA SHOULD BE SEND TO EXCEL AND AUTOMAILED AS ATTACHMENT
, I HAVE 3 EXCEL FILES WITH DIFFERENT FORMATS
EXPORT BUTTON SHOULD VIEW ALL THE EXCEL FILES WITH THEIR RESPECTIVE DATA
AND MAIL BUTTON SHOULD SEND MAIL THE EXCEL FILES WITH DATA , 1 USER I EXCEL FILE
2ND USER 2ND EXCEL FILE
3RD USER 3 EXCEL FILE
PLEASE HELP , ITS VERY URGENT
AND PLEASE HELP WITH COMPLETE SOLUTION.