Email message from Excel

[banoshi]

Hi,

I'm trying to make a database so I can send email to the staff due to attend training and I have two problems

1. Why the date in J2 is showing as a number and not as a date

2. I want to create a macro so that by selecting the email cell and clicking EMAIL button message in J2 with subject in I2 goes to that person.

Many thanks

banoshi

[Opsintern]

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,