Attach an existing file to an email

[ellenr]

I know how to set up a macro that opens an email in which I can fill in the intended recipient's email address and edit the message body and which attaches an Access report as a pdf. I would like to be able to set up the same email (probably need to do it in vba) but attach an existing pdf that resides in an ftp folder. I know the ftp username and password, as well as the name of the pdf. I am able elsewhere in the db to open this same pdf and view its contents by selecting it from a dropdown list. I am just trying to make it really easy for my users to email this one particular file, and my curiosity is piqued as to how to do it.

 

[June7]

AFAIK, will have to use CDO (Collaboration Data Object) code to create and manipulate email object and attach file. Rather common topic.

 

[isladogs]

Speaking of which, have a look at my EMail Tester sample database which contains code for testing email settings & sending emails using CDO ... including attachments

https://www.access-programmers.co.uk/forums/showthread.php?t=293368

 

[ellenr]

ridders, thanks for the test db--I took a look at it but it doesn't help me figure out if it is possible to attach a file from a ftp folder. June, I agree about the CDO. This db already has a cdo routine that works, so if I can figure out the ftp thing I can adapt it.

 

[June7]

Bing: vba download ftp file
Here is one https://analystcave.com/vba-downloading-files-from-ftp-using-vba/