Excel to Outlook

Hi Buddies,

I just want to elaborate my case and seeking on suggestions from all of you.

I have an excel with 2 sheets,
Sheet (1) Pivot data
Sheet (2) Main data

Now, here i would like to take the copy of the Pivot data from the sheet 1 and add into the body of the email to send. Once the copy has been done, i need to attach the excel sheet in mail itself.

I need all your valuable suggestions on this fix and expedite it.

Thanks a lot!!!

Thanks,
Janarthanan Arunachalam

Hi Buddies,

Can somebody reply me to sort it out of the challenges, what i have facing right away :slightly_smiling_face:

Thanks a Lot!!!

Thanks,
Janarthanan Arunachalam

HI @Lakshay_Verma,

Hope, i will get the information on my case in this detailed.

Thanks,
Janarthanan Arunachalam

@Janarthan_0310

Hey you can convert your datatbale into HTML format, when sending an email from SMTP/Outlook make sure you check IsHtmM to True.

To attach file, there is a option to attach file.

You can use below link

2 Likes

@Lakshay_Verma So cool kind of your suggestions. :slight_smile:

Much thanks on your help and as you suggested to save as html format and add into mail, all set and able to run the bot.

I just created a topic for another issue, Save as/system date and time/attach into mail

Please have a look and give your valuable suggestions.

Thanks,
Janarthanan A

1 Like

Thanks Buddy.

Guys, Please use this solution and i have marked as a Solution for future reference.

Many Hearty thanks to @Lakshay_Verma and all…

Thanks,
Janarthanan A

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.