Send outlook email to multiple users which are listed in Excel column

I’m trying to automate a process to send email to users.

  1. Users are listed in a column (Attached excel column)
  2. Need to send a single mail to all users
  3. The body has a news content
    Your daily news - This is hyperlinked and excel has a cell which contains the link.

Hi @anujkaul

Use Read range
Use For each row in Dt
Send Outlook Message
to :Row(“Users”).ToString
Body: row(“Links”).ToString

Ashwin S

1 Like

I’ll try and confirm. Hope, this works to send mail to all users listed in excel at once.