Hi! New poster to the forum, though I've long perused for answers. I hope to contribute help myself going forward.
In the mean time, I've searched for an answer to this and have yet to find an answer (if something has already been posted, forgive me).
I'm a team lead at my place of employment, and we track login information in spreadsheets. The way our tracking spreadsheet is currently setup allows me to select one of 30 people in my group, and click a button which launches my macro sending an email to that particular person with only their login information. As you can imagine, this can be a bit tedious with a group of 30.
Is anyone familiar with a way to write the macro to send the unique login form to all 30 agents individual emails at the same time? Essentially creating 30 unique emails with unique cell values sent to 30 unique email addresses with one click of a button?
Please let me know if you need additional information, any help is greatly appreciated!
Additional info - all team leads have access to Excel 2010, so no need for compatibility with prior versions. Same with Outlook.
In the mean time, I've searched for an answer to this and have yet to find an answer (if something has already been posted, forgive me).
I'm a team lead at my place of employment, and we track login information in spreadsheets. The way our tracking spreadsheet is currently setup allows me to select one of 30 people in my group, and click a button which launches my macro sending an email to that particular person with only their login information. As you can imagine, this can be a bit tedious with a group of 30.
Is anyone familiar with a way to write the macro to send the unique login form to all 30 agents individual emails at the same time? Essentially creating 30 unique emails with unique cell values sent to 30 unique email addresses with one click of a button?
Please let me know if you need additional information, any help is greatly appreciated!
Additional info - all team leads have access to Excel 2010, so no need for compatibility with prior versions. Same with Outlook.