Hi,

1 use TEXT(G2,"dd/mm/yyyy") instead of G2
2 Have a look at Mail Add-ins for Excel for Windows, This helped me a lot.

Cheers,