custom Template to be used in Layout for exporting data

Hi Guys,

Hope you are doing well.

Just need some help on my File,
I have attached 2 files on to this thread ( Template & Statement Macro)
What I would like Template to do is that,,, When i click on Send email on Template file, it splits the information on below cells and generates new Workbook and opens the outlook.
My need is that… Rather then creating New workbook I want information to go from Template workbook to Statement macro workbook where I created statement layout..

Is it possible to do that ?

If so, can anyone give me a hint , ?
Thank you Guys
Greeting from Ireland

Hello Ben,

Isn't this the same as this thread you posted earlier?