Generate E-mail from VBA

[Tench]

Hi i have used this forum for quite a while to get answers to numerous things but never posted,

I currently have a function behind a button that sends an e-mail to any users in my database that have tasks outstanding to prompt them on...

I have become stuck on what i though would be an easy addition, i want to add a link in the body of the generated e-mail that will open the database but do not want to show the file path as i try to keep this unavailable to general users the link needs to show as "Technical Program" but link to "\\server\data\TechFrontend.accde"

Heres the code i am currently using to generate the e-mail, the strEmailAddress is defined earlier in the code which is quite long but this is the only part needed to generate the e-mail



Call Email_Via_Outlook(strEmailAddress, "Technical Program Reminder", "You have tasks to authorise in the technical program, please log in to view your job list.", True, "")

Can anyone think of a way to do what i need?

[SoftwareMatters]

If you are creating an email using HTML this will work other wise it won't but you need to add something like this:

<a href='\\server\data\TechFrontend.accde'>Technical Program</a>

[Tench]

Thanks for the input JD, i have tried what you suggested and the e-mail body shows the entire text '<a href='\\server\data\TechFrontend.accde'>Technical Program</a>' when it is generated despite the HTML icon being highlighted on the outlook ribbon?

[SoftwareMatters]

This may help: http://www.access-programmers.co.uk/...d.php?t=205455

[Tench]

Thanks again JD it looked promising but when i tried to use that code the OutApp, OutMail etc threw up errors, possibly this is due to the references im using to work with Access 2010/Outlook 2010?

[SoftwareMatters]

You probably need to add the Microsoft Outlook reference. To do this open your VBA window and go to Tools/References and then scroll down and tick it.

[Tench]

My mistake I had messed up of the Dims, the code now works perfectly with my current references, thanks for your help!

[SoftwareMatters]

My mistake I had messed up of the Dims, the code now works perfectly with my current references, thanks for your help!

No problem - glad you got it sorted