' ' MadeIn@CEREAL ' Fonction d'envoi d'un mail avec Outlook 2003 ' ' Il faut avant d'utiliser ajouter la référence à Outlook dans les références COM ' Microsoft Office 11 Object Library ' Importer le Namespace ' Imports Outlook = Microsoft.Office.Interop.Outlook ' ' Utilisation de la fonction : ' Function CreateMail(ByVal astrRecip As String, ByVal strSubject As String, ByVal strMessage As String, Optional ByVal astrAttachments As String = "") As Boolean ' ' ByVal astrRecip As String ' Liste des destinataires séparés par des points virgules ; ' ' ByVal strSubject As String ' Sujet du message ' 'ByVal strMessage As String ' Corps du message ' 'Optional ByVal astrAttachments As String ' Liste des fichiers attachés séparés par des points virgules ; ' ' Exemple : ' CreateMail("dest1@test.com;dest2@test.int", "Sujet du message", "Corps du message à envoyer", "monfichier1.zip;monfichier2.doc") ' ' Adaptation du code exemple http://www.vbfrance.com/codes/CONTROLER-OUTLOOK-ENVOYER-MAIL-DEPUIS-VB_320.aspx mais pour qu'il fonctionne avec du .NET ' Imports Outlook = Microsoft.Office.Interop.Outlook Module SendOutlookMail Function CreateMail(ByVal astrRecip As String, ByVal strSubject As String, ByVal strMessage As String, Optional ByVal astrAttachments As String = "") As Boolean Dim olApp As Outlook.Application Dim objNewMail As Outlook.MailItem Dim varRecip As Object Dim varAttach As Object Dim blnResolveSuccess As Boolean Dim sRceipList() As String Dim sAttachments() As String olApp = New Outlook.Application objNewMail = olApp.CreateItem(Outlook.OlItemType.olMailItem) 'Crée un tableau avec la liste des expéditeurs sRceipList = Split(astrRecip, ";") sAttachments = Split(astrAttachments, ";") With objNewMail ' Add each item in the varRecip array to the Recipients collection. For Each varRecip In sRceipList .Recipients.Add(varRecip) Next varRecip ' Determine if all recipients have corresponding entries in the ' Outlook address book. blnResolveSuccess = .Recipients.ResolveAll ' Add each item in the varAttach array to the Attachments collection ' and specify the subject and text of the mail message. For Each varAttach In sAttachments .Attachments.Add(varAttach) Next varAttach .Subject = strSubject .Body = strMessage ' If all recipients are valid then send the message now, otherwise ' display the message so the user can fix invalid e-mail addresses. If blnResolveSuccess Then .Send() ' '.Display() Else MsgBox("Unable to resolve all recipients. Please check " & "the names.") .Display() End If End With Return True End Function End Module
Avis de décès, Carte de voeux, Bricolage, Coloriages, Cinéma, Coiffure, Cuisine, Déco, Dictionnaire, Horoscope, Jeux en ligne, Programme TV, Recettes, Restaurant, SMIC, Test débit, Voyage, Signification prénom