| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Send e-mail
Hi all,
I've created a macro which on button press (button is on an Excel file) send an e-mail via Outlook (sender, recipient, and attached file are constant). In order to send I use Application.Dialogs(xlDialogSendMail).Show. Now I would that this e-mail doesn't appear on send-mail-folder of Outlook. Is this possible? Exist a better method migliore in order to send and don't write on send-mail-folder? Or, it's possible to send, and in a second step delete this e-mail from send-mail-folder? Thanks in advance JFM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Send e-mail
Hi Andrea
It is possible to delete in Outlook but try CDO first. http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Andrea" wrote in message . .. Hi all, I've created a macro which on button press (button is on an Excel file) send an e-mail via Outlook (sender, recipient, and attached file are constant). In order to send I use Application.Dialogs(xlDialogSendMail).Show. Now I would that this e-mail doesn't appear on send-mail-folder of Outlook. Is this possible? Exist a better method migliore in order to send and don't write on send-mail-folder? Or, it's possible to send, and in a second step delete this e-mail from send-mail-folder? Thanks in advance JFM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Send e-mail
Hi Ron,
thanks for your reply. Your method is exactly what I'm looking for. Great! Only a little problem: sometimes (not always), when your procedure CDO_Send_Workbook() is running, when it come to iMsg.Send, here an alert like this run-time error '.........': The transport failed to connect to the server. appear, after clicking 'OK' I go in debug-mode, and if I press 'F8' or 'F5' in order to re-try to execute Send instruction, all seems work fine 'cause I can find my expected mail in my mailbox. Do you know what is the source of this trouble? It's possible to avoid this behavior? Thanks in advance JFM "Ron de Bruin" ha scritto nel messaggio ... Hi Andrea It is possible to delete in Outlook but try CDO first. http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Andrea" wrote in message . .. Hi all, I've created a macro which on button press (button is on an Excel file) send an e-mail via Outlook (sender, recipient, and attached file are constant). In order to send I use Application.Dialogs(xlDialogSendMail).Show. Now I would that this e-mail doesn't appear on send-mail-folder of Outlook. Is this possible? Exist a better method migliore in order to send and don't write on send-mail-folder? Or, it's possible to send, and in a second step delete this e-mail from send-mail-folder? Thanks in advance JFM |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Send e-mail
Hi Andrea
You can try to add trhis ..Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Andrea" wrote in message ... Hi Ron, thanks for your reply. Your method is exactly what I'm looking for. Great! Only a little problem: sometimes (not always), when your procedure CDO_Send_Workbook() is running, when it come to iMsg.Send, here an alert like this run-time error '.........': The transport failed to connect to the server. appear, after clicking 'OK' I go in debug-mode, and if I press 'F8' or 'F5' in order to re-try to execute Send instruction, all seems work fine 'cause I can find my expected mail in my mailbox. Do you know what is the source of this trouble? It's possible to avoid this behavior? Thanks in advance JFM "Ron de Bruin" ha scritto nel messaggio ... Hi Andrea It is possible to delete in Outlook but try CDO first. http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Andrea" wrote in message . .. Hi all, I've created a macro which on button press (button is on an Excel file) send an e-mail via Outlook (sender, recipient, and attached file are constant). In order to send I use Application.Dialogs(xlDialogSendMail).Show. Now I would that this e-mail doesn't appear on send-mail-folder of Outlook. Is this possible? Exist a better method migliore in order to send and don't write on send-mail-folder? Or, it's possible to send, and in a second step delete this e-mail from send-mail-folder? Thanks in advance JFM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Send e-mail from a Excel file | Excel Worksheet Functions | |||
| Send To - E-mail Recipient | Setting up and Configuration of Excel | |||
| using macro to send e-mail | Excel Discussion (Misc queries) | |||
| help with send mail through excell | Excel Worksheet Functions | |||
| send to mail all the context | Excel Discussion (Misc queries) | |||
Linear Mode
