send an email when a cell is changed for selected rows only with VBA

Kaarrma

New Member
Joined
Jun 8, 2018
Messages
4
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

 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,213,562
Messages
6,114,322
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top