Hi There,
I have a spreadsheet that contains employee claims, eachline is 1 claim which has a unique identifier
I need a way for the user to be able to select rows and havecertain cells from the selected rows to be added to an email (recipient,subject and body template will be static)
The spreadsheet is dynamic, as new claims are always beingadded.
Initially I started with the thought of adding tick boxes ineach row so the user can tick the claims to send, and then click a combobuttonthat will create the email, using the fixed template and inserting cells fromthe selected rows in the middle of the body. Or even a button on each row, thatthe user caqn click once the change is complete for that row.
Each claim is created via a form, so anything added to theclaim such as a tick box, would need to be added via the user form.
Other alternative is to trigger an email each time the cellin a certain column is changed (The column is Q ‘Notes’, and send only thecells in certain columns for the row that has been changed
Sheet columns to send in email are:
Column A = Record ID
Column D = Employee Number
Column E = Employee Name
Column I = Claim Number
Column Q = Claim Notes
I have found several types of code, but nothing that reallyfits what I need.
Any help would be greatly appreciated
I have a spreadsheet that contains employee claims, eachline is 1 claim which has a unique identifier
I need a way for the user to be able to select rows and havecertain cells from the selected rows to be added to an email (recipient,subject and body template will be static)
The spreadsheet is dynamic, as new claims are always beingadded.
Initially I started with the thought of adding tick boxes ineach row so the user can tick the claims to send, and then click a combobuttonthat will create the email, using the fixed template and inserting cells fromthe selected rows in the middle of the body. Or even a button on each row, thatthe user caqn click once the change is complete for that row.
Each claim is created via a form, so anything added to theclaim such as a tick box, would need to be added via the user form.
Other alternative is to trigger an email each time the cellin a certain column is changed (The column is Q ‘Notes’, and send only thecells in certain columns for the row that has been changed
Sheet columns to send in email are:
Column A = Record ID
Column D = Employee Number
Column E = Employee Name
Column I = Claim Number
Column Q = Claim Notes
I have found several types of code, but nothing that reallyfits what I need.
Any help would be greatly appreciated
