Hi
Apologies for the simple question, but cannot find the answer.
I have an active worksheet, which users currently send by email, using the following code:
Application.Dialogs(xlDialogSendMail).Show
This allows me to insert the addresses of those people, to whom I want to send the worksheet, and for me to choose when to send the email (using the "Send" button)
I want to have those addresses automatically pre-inserted into the "To" box, but for the email to not be automatically sent, until the user clicks on the "Send" button.
I know the code for automatically sending the email, using typically:
ActiveWorkbook.SendMail Recipients:="nick.paton@home.com"
But this does not give me the control to choose when to send the email.
I am using Excel 97 and Outlook
Please help and many thanks!
Apologies for the simple question, but cannot find the answer.
I have an active worksheet, which users currently send by email, using the following code:
Application.Dialogs(xlDialogSendMail).Show
This allows me to insert the addresses of those people, to whom I want to send the worksheet, and for me to choose when to send the email (using the "Send" button)
I want to have those addresses automatically pre-inserted into the "To" box, but for the email to not be automatically sent, until the user clicks on the "Send" button.
I know the code for automatically sending the email, using typically:
ActiveWorkbook.SendMail Recipients:="nick.paton@home.com"
But this does not give me the control to choose when to send the email.
I am using Excel 97 and Outlook
Please help and many thanks!