Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email excel spreadsheet - embedded in email | Excel Discussion (Misc queries) | |||
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Email Spreadsheet | Excel Discussion (Misc queries) | |||
Trying to email a spreadsheet | Excel Worksheet Functions |