<div>
Also, &nbsp;for the above code to work you need to make sure that your Outlook options allow HTML emails. &nbsp; (It wouldn't work at my location, because all of our emails are plain text)
</div>


Also,  for the above code to work you need to make sure that your Outlook options allow HTML emails.   (It wouldn't work at my location, because all of our emails are plain text)

<div>
&lt;&lt;<br />
Also, just out of curiosity, is there a way to send an email from Access to Outlook which has a link to a specific form?<br />
&gt;&gt;<br />
<br />
No... but you can send a link to a database which has an autoExec Macro or startup form which takes the user to that specific form. The link will open the database, and the startup macro or code will take the user to the form (I can't think of anyway to get the user to a specific record on that form, though).
</div>


<<
Also, just out of curiosity, is there a way to send an email from Access to Outlook which has a link to a specific form?
>>

No... but you can send a link to a database which has an autoExec Macro or startup form which takes the user to that specific form. The link will open the database, and the startup macro or code will take the user to the form (I can't think of anyway to get the user to a specific record on that form, though).

<div>
<div class="content wysiwyg-content">
In Access 2010 I have a form with a command button which creates an Outlook email. &nbsp;When you click the button it opens up the email in Outlook and in the body I need a link back to the database.<br />
<br />
I cannot get the link to work. &nbsp;Here is the code I've tried to use.<br />
<br />
StrBody = StrBody &amp;&nbsp;&quot;&lt;A href='file://S:/Users/jal.<wbr />doc'&gt;&lt;U&gt;Cl<wbr />ick Here&lt;/U&gt;&lt;/A&gt;&quot;<br />
<br />
Also, just out of curiosity, is there a way to send an email from Access to Outlook which has a link to a specific form?<br />
<br />
Can anyone help me with this?<br />
<br />
Thanks in advance!
</div>
</div>


In Access 2010 I have a form with a command button which creates an Outlook email.  When you click the button it opens up the email in Outlook and in the body I need a link back to the database.

I cannot get the link to work.  Here is the code I've tried to use.

StrBody = StrBody & "<A href='file://S:/Users/jal.doc'><U>Click Here</U></A>"

Also, just out of curiosity, is there a way to send an email from Access to Outlook which has a link to a specific form?

Can anyone help me with this?

Thanks in advance!

Email Hyperlink from Access to Outlook

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.