Saved email as hyperlink

[jj22171]

I have a table with one of the fields as hyperlink to store saved email messages. While I can drag and drop the saved message from a folder into each record, it would be nice to do it in an unbound textbox (in a Form) and update all the records in the table at one time. I tried creating a textbox and set Is Hyperlink to yes but it won't accept drag & drop. What's the correct way of doing it? Thanks.

 

[jj22171]

Not sure if it's the best solution but it looks like it's working. I created a temporary table with a single hyperlink field and bound to it a textbox in my form. Now I can drag and drop my saved email to the textbox and use it to populate my records. Hope others may find this useful.

 

[pjd218]

jj,

I too was working on a project similar to this. Couple of thoughts. You can automate the import of emails to a table and link to individual records. Or you can create a command button that will allow you to browse the Outlook folder with the emails you want to view. I am still working on the code to save the actual link to the folder in the database, but the browse capability at least puts all of the info at my fingertips for quick viewing/reference.

Happy to supply the code that worked for me.