Open files with hyperlinks and send as attachments

[mkaeser]

Hello all,

I have a database which has several records with at least 5 documents needing to be attached to each record. Using attachments or OLE would cause considerable bloat, so I opted for hyperlink fields for all the document types necessary to save with each record. However, now I am faced with an issue. It is easy enough to write code to open the files by following the hyperlinks, as well as write code to send an email, but how would I go about combining the two? I need to write a code that will attach these documents to an email, as attachments and not as hyperlinks. Is this possible? I know with excel documents, I could follow the hyperlink and send the document by email through excel, but I also have images converted to pdf's that need to be sent as attachments. Any ideas?

 

[namliam]

Well if you have code already in place to send emails, you should be able to "simply" add attachments at that point? I think?

Been a long time since I actually did do something with mailing and even longer ago with attachments.

 

[mkaeser]

True, but the attachments I need to add are not in the database, and they will be different each time, so it is not very efficient to add attachments that way I believe...

 

[mkaeser]

So I found a link that seems to be the direction I want to go, as namliam pointed out, attachments seem relatively "simple" to add into your code:

http://www.access-programmers.co.uk...084&highlight=email+hyperlinks+as+attachments

I will post back when I find the right code for me! Thanks!

 

[namliam]

That code you linked seems to already work with attachements?