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
column A)
attach the specific pdf file (using name in column B)
Thank you for responding to me.
The method of sending the email does not really matter - either way is ok.
The important bit is to have a separate email for each email address indicated in Excel file and correct pdf file attached to each email.
By point 3 i meant saving all produced emails in either Draft or Outbox folder of Outlook etc. But I would like to understand how to specify a specific email Inbox to which all of the emails can be saved in (different team email Inbox).
Great , thanks Marius.
This is a very similar concept to what I created however yours works as opposite to mine. Thanks
Is there an option to select a specific inbox i.e. if i am on distribution list for 2 different teams can I somehow select Draft folder under one team email address i am member of or is it not possible?
This kind of error is thrown mostly because the email address is not correctly written. Perhaps one or more of your input email addresses are missing the . (dot) from their structure.
Could you please share more details about your distribution list.
I am struggling with creating the email for the scenario in which i have more that 1 recipient for the email. When i put 2 email addresses into my excel file under “Email address” column it generates an error.