See
http://www.rondebruin.nl/sendmail.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"bbc1" wrote in message ...
Sorry am not sure how to place this in the code could I have the actual code
I need to insert

"Sheeloo" wrote:

With the mail object use the following;

.To = "

basically use the same syntax as populating SUBJECT field...

"bbc1" wrote:

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.