Sending mail from Excel with CDO
Eine Möglcihkeit um aus Excel, per VBA, Emails zu versenden sieht so aus: 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 ‚
» Weiterlesen