Good morning –
I’m very new to Visual Basic and I’m looking for some help building a Macro. I’d like to base the Macro off of an Excel worksheet that tracks dates (this is for performance management). Ideally, the first column would be checkboxes and when checked and a button on the sheet is pressed, I’d like the Macro to update dates on the Word document based on cell data and attach it to an email.
Can someone help with how to set up this code or how this code should look?
Also, is it possible to generate multiple emails with the corresponding attachment (i.e. if I check 3 people all with different managers, is it possible to generate emails with the correct attachment to the correct manager)?