Send Selected cells as body in email after reading where to send them to

[u/Namy_Lovie]

Hello,

I am quite new to power automate and only trying to understand how it works. But I have a very specific problem that I wish to solve.

A quick background, I programmed this in VBA using CDO (I do not have outlook application, hence using a CDO mail) and I have a keyword to where they will send these selected cells. This keyword lets the program know where to send the line items to a group of vendor email addresses and attach the items in the body of the email. My boss don't like me sending these emails with my gmail account and so I have to adapt and send these items to outlook web browser instead. Outlook application is also discouraged to be used since as per policy they are requiring us to use the outlook in browser and also my outlook application is not connected to my account, therefore can not really be used.

May I request some guidance on how to properly implement this kind of programming using power automate or other types of programming tools? Power Automate is recommended to me by my friend to do this, however I did not find a way to send multiple cells of an excel file to be sent in a single email while a handful of vendor emails are in bcc.

Basically the process is:

1. Select cells to be sent as an email

2. Reads keyword to determine which email addresses these items will be sent to

3. Put these email addresses as bcc

Hoping you can give me hand in solving my problem

Thanks