Email Notification Macro

[vatagarw]

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 

[ArtApa]

Hi @vatagarw - I'm not sure what is your question?

[vatagarw]

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.