Word Mail Merge with differnt attachment like excel file, ppt file, pdf etc.

This is my "off the shelf" from my workbench mailer in Excel. It is up to you to write code to "feed" the arguments such as a list of email addresses and maybe even customizations like adding a person's name or whatever.

This subroutine takes a number of arguments:

• Who to mail to
• Subject
• Message Body
• CC (optional)
• BCC (optional)
• Attachment (full path name)
• Send flag

The Send flag is false by default which means that the mail message will be composed, but not sent. You have a chance to edit it. True means the mail goes out automatically without intervention.

Multiple attachments can be sent. Use the full path names and separate them by the semicolon (. These attachments can be any kid of file.

Please Login or Register  to view this content.