I have a sheet that I have created a button on that when its pressed opens
outlook up, would like as part of the macro that it places the employee's
email address's in it and sends it.
Sub Email()
'
' Email Macro
''

'
Application.Dialogs(xlDialogSendMail).Show
End Sub

Outlook opens corrrectly with the file attached and the subject completed
but I have to select the persons email address from the contacts dropdown.