Shadeslayers09
New Member
- Joined
- Nov 30, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Good afternoon,
I am wondering if there is a way to setup some type of macro/script that will allow me to send individual emails to a list of emails that i have on a spreadsheet. With my job as an estimator for a GC, i have to send out invites to subcontractors as well as any answered RFI's or addendums, and would like to have a button for each option that will allow me to create a unique email for each subcontractor but only pressing one button.
For instance, when i send out the Invitation to Bid (ITB), after I press the button, it would ask if i want to send it out to everyone or just certain ones (if certain ones then it would ask me to select the cells). After i make that choice it would then ask what i want the subject line to be (if able to setup a code to auto-pull from certain cells that would be great) and then what i want the body of the email to say.
If anyone could help me out that would be great.
Thanks!
I am wondering if there is a way to setup some type of macro/script that will allow me to send individual emails to a list of emails that i have on a spreadsheet. With my job as an estimator for a GC, i have to send out invites to subcontractors as well as any answered RFI's or addendums, and would like to have a button for each option that will allow me to create a unique email for each subcontractor but only pressing one button.
For instance, when i send out the Invitation to Bid (ITB), after I press the button, it would ask if i want to send it out to everyone or just certain ones (if certain ones then it would ask me to select the cells). After i make that choice it would then ask what i want the subject line to be (if able to setup a code to auto-pull from certain cells that would be great) and then what i want the body of the email to say.
If anyone could help me out that would be great.
Thanks!