Copying a file to the server then attaching to an e-mail

[scliffe]

We have as part of our interface an option for people to send texts or e-mails to others and want to add the option of attachments. These are then sent from the server to the recipients.

Basically, we're looking at what options there are in copying the file selected (in the designed dialog box whose path is then entered into a section on the form) to the server and attaching to the e-mail that is then sent. Is there any way of doing this?

e.g. To send bob.doc we want to copy bob.doc from [local machine]c:\pathname\bob.doc to [server]c:\attachments\bob.doc then attach that to the e-mail created by the form and send the e-mail and the attachment out. This attachment could then be removed from [server]c:\attachments

Any thoughts?

 

[kjv1611]

Well, you may can use the FileSystem object (you'll need a reference set in VBA, I think) to copy the file to the network location.

For the email portion, I am sure there is a way directly within VBA, but I can't think at the moment as to what would be best to use.

I did find this, however:

http://www.blueclaw-db.com/access_email_send_outlook.htm

--

"If to err is human, then I must be some kind of human!" -Me

 

[kjv1611]

And you might could use the same properties referenced in the code in thread705-1367295.

--

"If to err is human, then I must be some kind of human!" -Me