Under To, you will get the standard fields of Outlook contacts. In From section, you will get a box that includes column names from CSV file you are going to import. In Outlook, click on Map Custom Fields button and it will prompt Custom Fields wizard. If we want to include the “ Sender” information in the output table, we can click the Expand Table button at the top of the “ Sender” column and click OK to extract the names and email addresses as additional columns in the current table. Map CSV File Columns to Outlook Distribution List. The “ Sender” column contains nested information about the name and email address of the sender. Other columns, like the “ Subject” column display all the email subject lines. You can also filter using pre-build text filters for items that begin, end, include, or don’t include specific text. I want to filter the “ Folder Path” column to only include messages from the “ Action Required” subfolder. It is easier if you simply select Contacts click New Contact Group and name it with regard to your needs choose Add Members and simply add people from your contact list who you want to see in this very list save and close the function. This contains two versions of the email message: a plain text version and an HTML version of the message. go to My Contacts and choose the folder where the contact group is to be saved. Attachment indicator and attachment filenamesĪn interesting column is the “ Body” column.These headings allow us to sort and filter the table to include only the needed items. Once we have brought the Inbox information into Power Query, check out these categories across the top of the table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |