Excel CDO Excel I'm trying to bypass Outlook to send an email with a csv attachment. I used the code provided by Ron De Bruin (http: / / www.rondebruin.nl / cdo.htm): - - - - - Sub CDO_Mail_Small_Text() Dim iMsg As Object Dim iConf As Object Dim strbody As String Dim Flds As Variant Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.Configuration") ' iConf.Load -1 ' CDO Source Defaults ' Set Flds = iConf.Fields ' With Flds ' .Item("http: / / schemas.microsoft.com / cdo / configuration / sendusing") = 2 ' .Item("http: / / schemas.microsoft.com / cdo / configuration / smtpserver") _ ' = "Fill
About using CDO to send email within Excel Excel Hello Excel Experts: Urgent help is required from you IT guys. I need to send emails silently within Excel using VBA, and the following code doesn't work for me (the code is found Dim iConf As Object Dim strbody As String Dim Flds As Variant Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.Configuration") iConf.Load -1 ' CDO Source Defaults Set Flds = iConf.Fields With Flds .Item("http: / / schemas.microsoft.com / cdo / configuration
Microsoft CDO 1.21 manquant ? Excel Bonjour. Je viens d'installer office 2003 sur mon nouveau poste. J'ai lanc = E9 une macro qui poste des mails, et interruption : Microsoft CDO 1.21 manquant. J'ai donc t = E9l = E9charg = E9 la r = E9f = E9rence manquante mais au moment de l'installer ( = E0 partir du Exchange CDO que j'ai t = E9l = E9charg = E9), Windows = me dit que pour que cette librairie mauvaise version ? Si c'est = E7a, avez-vous un lien vers la version 2003 ? Merci. Excel - French Discussions Macro (1) Exchange (1) Bonjour, Un site internet tr?s complet sur le sujet ici : http: / / www.rondebruin.nl / cdo.htm#Tips MichD - -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - 5adc70da-5ffe-4e48-9ac3-5b96e79ba6b7@j13g2000pro.googlegroups.com. . . Bonjour. Je viens d
Email Excel VBA / CDO Excel I am trying to use Ron DeBruin's CDO Email routine http: / / www.rondebruin.nl / cdo.htm But, I am running into some problems. The exact code being used is as Dim iMsg As Object Dim iConf As Object Dim Flds As Variant Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.Configuration") iConf.Load -1 ' CDO Source Defaults Set Flds = iConf.Fields With Flds .Item("http: / / schemas.microsoft.com / cdo / configuration
Shortcut Key Creation Excel Shortcut Key Creation Can I create a shortcut key for save and close in Excel? Thaks Excel Miscellaneous Discussions Microsoft Excel (1) Excel (1) Workbook (1) Macro (1) CodeCage (1) Thaks (1) Shortcutkey (1) Newsgroiups (1) This is post but I believe he just wanted to save and close the workbook, not Close Excel. Always best when responding to leave some of the original posting so's other can see to what you are referring. Gord Dibben MS Excel MVP On Thu, 12 Feb 2009 01:35:52 +0000, JBeaucaire Actually, I stopped using