Hello everyone,
Please see the attached [VBA HELP.XLSX] document.[List] tab column A and B contains the list of 'To' email list. Column C contains 'Send Link' hyperlink which I originally had 'mailto' function.
The process should be that the EA need to click hyperlink on column C line by line to send an email (we want to keep it this way).
So when she clicks C3, it will send an email to A3 and AB. The body of the email is from [Email] tab.
I am completely new to VBA and have no idea how to create a VBA code. I came across Ron de bruin website, but no luck at all.
If you could help me, that would be great.
Bookmarks