powershell get 資料後以表格寄出

 有時後要用powershell去撈一些資料，然後寄出，如果已經用powershell篩出要的資料再寄出，語法不難，網路上一堆。

但假設我撈出了兩欄資料，我希望寄出來，是有表格的型式，這就難了。

在爬了一堆文後，找到一篇很實用的文章

https://evotec.xyz/sending-html-emails-with-powershell-and-zero-html-knowledge-required/

一開始就是先用get-xxx去把要的資料找出來，並且設成一個變數。

二是建立一個迴圈，把撈出來的資料依序帶入到一個表格容器裡面，設成一個變數。

三是用html語法建立一個表格，設定表格的樣式，抬頭名稱，欄位名稱，然後把步驟二的資料放到這個html的表格內，也是要設成一個變數。

四就是最後一步，用powersell發mail的指令發信，信的內容就是把步驟三產生的變數帶入，就完成了。

依照這個架構，就可以利用powershell去產出表格資料寄給需要的人。

Sometimes, I need to fetch data using PowerShell and then send it out. If I have already filtered the desired data using PowerShell, sending it out is not difficult, as there are plenty of examples available online.

However, if I want to send the fetched data in a tabular format, it becomes more challenging.

After searching through various resources, I found a very useful article:

https://evotec.xyz/sending-html-emails-with-powershell-and-zero-html-knowledge-required/

First, I use "Get-xxx" commands to retrieve the desired data and store it in a variable.

Next, I create a loop to iterate through the fetched data and populate it into a table container, which is stored as another variable.

Then, I use HTML syntax to create a table, set its style, define column headers, and incorporate the data from the previous step into the HTML table, which is stored as a variable as well.

Finally, in the last step, I use PowerShell's email sending command to send the email, and the content of the email is populated by inserting the variable generated in the previous step.

By following this framework, I can utilize PowerShell to generate tabular data and send it to the intended recipients.