Hi,
I am trying to build a macro where I can send Email notification.
Now alert are sent as follows :
1) Depends on Combination of category ( eg: Car, Bike, Truck..) and country (India, UAE, USA..)
2) For Car-
ID | Name | City | Country | CarFlag | CarDate |
For Bike :
ID | Name | Country | BikeFlag | BikeDate |
For Truck :
ID | Name | Country | TruckFlag | TruckDate |
These column will be send
3) There is a flag by which rows are selected.
4) In Email - Table is send which is built as per 2nd point.
Please check attached excel sheet to get an idea of dataset.
Thanks
Hi @vatagarw - I'm not sure what is your question?
Hi @ArtApa
Sorry for inconvenience. I have added details , I can't add a workflow due to organization issue.
I am having 2 dataset.
Table 1 :
Table 2:
Below workflow is for sample made without macro.
--> Use filter in 1st Table, CarFlag = 'Y' then we will add Category column as 'Car' and select columns which are required(City is selected only for Bike Category) and then join with Table2 on Country and Category.
--> Table 2 just have Name, Category, Country, Email IDs(each combination of Name, Country, Category will have different), Subject and Body. Then make a basic table (with Chosen Columns in a table).
--> Step1 and 2 similarly for other categories.
--> Union All the output of Basic Table and append Report Text with Thanks and Regards (Signature)
Then Mail it.
Please let me know if you need any other information.