hisrot.blogg.se

Vba create outlook email
Vba create outlook email






vba create outlook email vba create outlook email

' Array("C:\Temp\Table2.txt", "C:\Temp\Supplier List.txt"), _ ' Array("C:\Temp\Table2.txt", "C:\Temp\Supplier List.txt")) ' Call "My Subject", "My body.", True,, _ ' Array("C:\Temp\Table2.txt")) ' Call "My Subject", "My body.", True,, _ ' Website : ' Purpose : Automate Outlook to send an HTML email with or without attachments ' Copyright : The following is release as Attribution-ShareAlike 4.0 International ' (CC BY-SA 4.0) - ' Req'd Refs: Late Binding version -> None required ' Early Binding version -> Ref to Microsoft Outlook XX.X Object Library ' ' Input Variables: ' ~~~~~~~~~~~~~~~~ ' sTo : To Recipient email address string (semi-colon separated list) ' sSubject : Text string (HTML) to be used as the email subject line ' sBody : Text string to be used as the email body (actual message) ' bEdit : True/False whether or not you wish to preview the email before sending ' vCC : CC Recipient email address string (semi-colon separated list) ' vBCC : BCC Recipient email address string (semi-colon separated list) ' vAttachments : Array of attachment (complete file paths with ' filename and extensions) ' vAccount : Name of the Account to use for sending the email (normally the e-mail adddress) ' if no match is found it uses the default account ' ' Usage: ' ~~~~~~ ' Call "My Subject", "My body.", True) ' Call "My Subject", "My body.", True) ' Call "My Subject", "My body.", True,, _

vba create outlook email

'- ' Procedure : SendHTMLEmail ' Author : Daniel Pineault, CARDA Consultants Inc.








Vba create outlook email