#MAIL MERGE WITH ATTACHMENTS FULL#

' Give the user an opportunity to abort, and also the option to save the emails in drafts, or send immediately , vbOKOnly + vbCritical, 'Error') = vbOK Then Exit Sub VbLf & vbLf & 'Please click the Edit Recipient List button to confirm that mail merge is correctly setup for this document.' _ If MsgBox('Mailmerge not set up for active document - cannot perform mailmerge. ' check for the mail merge state being that of a mail merge ready to go ' identify the mail merge of the active document ' Please make sure you copy all the text in this code snippit box, including the function 'StripToLcaseLetters' below this sub.ĭim outlookApp As Object 'Outlook.Applicationĭim outlookMail As Object 'Outlook.MailItemĭim outlookAccount As Object 'Outlook.Account

' Please share freely while retaining attribution

Multiple To, CC, BCC and Attachment columns can be used.

Omitting a field or leaving it blank will leave that field in the email as the default value.

#MAIL MERGE WITH ATTACHMENTS FULL#

Attachment is the full file path of an attachment.

SendAs is the email address of the person or team from which the email should appear to be sent from, or sent on behalf of.Account is the email address of the account from which the email is to be sent (not send as, see below).DeliveryTime can be a datetime, a date (email will be sent at midnight on that date) or time (email will be sent at next instance of the specified time).ReadReceipt and DeliveryReceipt can be true, yes or y to request, or false, no or n to not request.Sensitivity can be normal, personal, confidential, and private.Subject can be whatever you want, and individualised to the recipient.To, CC and BCC should contain email addresses separated by a semi-colon (multiple columns can be used if preferred).Add any of the following columns to your Mail Merge data: To, CC BCC, Subject, Importance, Sensitivity, ReadReceipt, DeliveryReceipt, DeliveryTime, Account, SendAs, Attachment.Copy the text of the Macro from below and add to Word.

Mail merge with attachments