Email spreadsheet
 

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.

Email spreadsheet
 

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.

Email spreadsheet
 

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.

Email spreadsheet
 

From mrexcel.com:

Dim Send As Dialog
Send = Application.Dialogs(xlDialogSendMail).Show("someon ",
"Subject Line", True)

--JP


On Sep 27, 2:26*am, bbc1 wrote:
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.

Email spreadsheet
 

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.

Email spreadsheet
 

Thankyou very much worked it out and it works perfectely

"Ron de Bruin" wrote:

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.