E-mailing Attachments

[wilro85]

At the end of my form, the user presses a button that activates the SendMail method sending the workbook to us. I'd like them to also be able to send an attachment Zip file with the document.

I know it can be done using a code similar to this:

Please Login or Register  to view this content.

However said code requires a reference to Outlook which causes problems depending on what system it is being filled out on.

Are there any other methods availible to send attachments that require program referances?

[Leith Ross]

Hello wilro85,

You can use CDO instead of SendMail or Outlook. CDO doesn't display any security warnings and will work with any machine. The email is sent using the machine's STMP service. Have a look at Ron De Bruin's page...

Send an Email with CDO

To send an attachment, use the .AddAttachment statement. Place the file path and name to the right of the statement. You can not use relative file paths. Place this before the .Send statement of your code.

Please Login or Register  to view this content.

To send more than one file, add more .AddAttachment statements.

Sincerely,
Leith Ross