I am already using a more standard macro to send off a confirmation e-mail, but I would also like a meeting request to ping off to a e-mail address using the info already in some columns of the sheet...
For this example let's say the key fields are housed in the following columns:
Confirmation button: Column U
E-mail address to use: Column S
Date of meeting: Column J
Time of meeting: Column K
Can VBA be used to pick up the info from these columns, transfer it to a meeting invite and send off to the e-mail address?
Worth noting that the e-mail addresses will differ depending upon the row, as will the times, dates etc.
Thanks in advance.
Bookmarks