Hi!
I'm trying to attach parts of an excel file to an email and I'm not sure how to approach it. The reason for dividing it up is to send different pieces of information to different people. The file consist of one sheet (main) with all info and then separate sheets based on the value of a column in the main sheet. It is these separate sheets I want sent out to different people.
There are two "ways" for me to divide up this information, one is to attach the different sheets of the excel file to different emails, the other is to attach specific rows, based on column values in the main sheet, from the excel file to different emails. I would prefer if I could use the column from the main sheet to divide the information, but I'm open to all ways to go about it. I have tried using the Get tables function and this allows me to get different parts of the excel file but I haven't figured out to attach the table as a file, sending it out in the body of the email as a HTML table is unfortunately not an option.
Does anyone have any idea on how I can approach it? Would be very happy for any input as I'm a bit stuck and not really sure how to proceed onwards.
Best regards,
Elin
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,089
Most Valuable Professional