Generate an email

EmilAlteryx01

Hi, 

Could you help me generate an email outlining the specifics of the attached source files (attached for your reference)

Template –

1)

To: (always the same) – John@gmail.com; Mark@gmail.com; Mary@gmail.com

CC: (always the same) – Emilia@gmail.com

Subject – Bank details for Chennai Branch_Date DD/MM/YYYY

2)

Hi All,

I hope this email finds you well. Please find below the daily report detailing the stock and cash transactions for today.

3)

Table should only show entries >1,000,000

(to be auto-populated from the source files
Date	Today()
Days	Client	Client	Branch	Difference	Comments
Leave Blank - to be updated manually					Under Investigation
Leave Blank - to be updated manually					Under Investigation
Leave Blank - to be updated manually					Under Investigation
Leave Blank - to be updated manually					Under Investigation
Leave Blank - to be updated manually					Under Investigation

4) AGED DETAILS

Please be advised of the aged details (Blank Table)

Date

=TODAY()

(Details to be updated from the Input sheet -

John	Daily Check	Client Positions	Branch Positions	Difference
	Stock Position	120100000	108090000	12010000
Cash Acc
Principal	Principal	670000	670000	0
Interest	Interest	15000000	15100000	-100000
Mark	Daily Check	Client Positions	Branch Positions	Difference
	Stock Position	11000000	11000000	0
Cash Acc
Principal	Principal Local	1840000	1840000	0
Interest	Interest Local	320000	320000	0
Principal	Principal FX	14800000	14600000	200000
Interest	Interest FX	4472500	4472500	0
Mary	Daily Check	Client Positions	Branch Positions	Difference
	Stock Position	11000000	11000000	0
Cash Acc
Principal	Principal USD	1840000	1840000	0
Interest	Interest USD	320000	320000	0
Principal	Principal EUR	14800000	14600000	200000
Interest	Interest EUR	4472500	4472500	0
Principal	Principal GBP	15000000	14600000	400000
Interest	Interest GBP	320000	320000	0

Email Files.zip