I would like to build a procedure which creates and sends bunch of emails with attachement.
I have an excel list which consist of 2 columns (among others) that i want to use in my robot - column A and column B.
Column A includes email address of people to which the email should be sent
column B includes the names of the files (pdf files created already by a separate robot) that are saved in a specific windows folder ON my PC that i want to attach to the email.
I aim to:
- loop through list in excel and create email for each email address (using email address in
- attach the specific pdf file (using name in column B)
- save all emails in a specific Inbox
- send all emails
Can anyone provide some advise on how to do it.