Dear Forum,
I am stuck with combining the different things at a place ..Attached is the sheet that explains it in a better way ..
1/Update Record:
update the record from the data base placed on the drive (same computer)
Eg: As location keeps changing get the updated location from the master sheet placed on a different drive but on the same computer.
2/ Creat an e mail with
a/ Details of tables from sheets mentioned in column G, should be copied and aligned in the body of the e mail
b/ Attach same sheet as an excel sheet to the e mail (attachment).Eg : Attach sheet"a" to e mail going out to Jim.
c/ Attach a PDF document placed on the desktop to the e mail,this document is different for different e mails
Eg:Jim will have a different document than Basu ,so the document for jim has to be attached to the Email going out to Jim
d/ Send it in case the condition is "A" in the last column.
Query
Can we creat a combo/list box with all these possibilities in to execute this .
Thanks in Advance ..
Bookmarks