Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-07-2019, 03:59 AM   #1
hinchi1
Newly Registered User
 
Join Date: Oct 2017
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
hinchi1 is on a distinguished road
Hyperlink email body text

I have automated Outlook from Access and all works fine when Outlook on my PC is started and loads the message which I have programmed inside Access. The email addresses show up as hyperlinks as I would expect. However, my organisation is moving to OWA(Office 365) and the email addresses in the message body just show as plain text. I have looked on other forums on how to make the email addresses as hyperlinks within the Access code but not my speciality, so in need of some help please. Attached is the code which for obvious security reasons i have removed email names but I have highlighted in yellow the areas which need HTML formatting. Thanks in advance.
Attached Files
File Type: docx Email Hyperlink Question.docx (19.0 KB, 7 views)

hinchi1 is offline   Reply With Quote
Old 11-07-2019, 04:20 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,951
Thanks: 114
Thanked 2,993 Times in 2,721 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Hyperlink email body text

Hi and welcome to AWF.
I've moved your post as it was in a moderated area intended for working code samples.

Normally you would insert this info with a DLookup (or a user defined function based on DLookup) together with concatenation for text strings.

Suggest you look at the similar threads below for information.

I expect someone will be along soon with a more detailed reply if you need it.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 11-07-2019, 05:01 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,721
Thanks: 57
Thanked 1,260 Times in 1,241 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Hyperlink email body text

Hi. Welcome to AWF! You could try tagging the email address with HTML. For example, <a href=mailto://EmailAddressHere>EmailAddressHere</a>.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-07-2019, 05:06 AM   #4
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA
Posts: 187
Thanks: 19
Thanked 10 Times in 10 Posts
vba_php is on a distinguished road
Re: Hyperlink email body text

Quote:
Originally Posted by hinchi1 View Post
The email addresses show up as hyperlinks as I would expect. However, my organisation is moving to OWA(Office 365) and the email addresses in the message body just show as plain text.
Have you tried wrapping the emails with the HTML tag:
Code:
<href></href>
That might possibly work. I've automated outlook many times but never with Office 365, so my links were always automatically detected and appeared as hyperlinks. If <href> doesn't work, it's not all bad to send email addresses as plain text. The only thing user has to do if they wanna email that person is copy and past the text into an email message.
vba_php is online now   Reply With Quote
Old 11-07-2019, 05:29 AM   #5
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,332
Thanks: 432
Thanked 790 Times in 766 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Hyperlink email body text

I am not sure HTML is going to work in plain text email.?
I would expect the HTML code would just be displayed.?

Then again, I've only ever used HTML with HTML emails.?
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
Old 11-07-2019, 11:47 AM   #6
hinchi1
Newly Registered User
 
Join Date: Oct 2017
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
hinchi1 is on a distinguished road
Re: Hyperlink email body text

Thanks for the replies. I just wondered why owa would be just plain text. Maybe something for Microsoft to work on.
hinchi1 is offline   Reply With Quote
Old 11-07-2019, 11:48 AM   #7
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,721
Thanks: 57
Thanked 1,260 Times in 1,241 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Hyperlink email body text

Quote:
Originally Posted by hinchi1 View Post
Thanks for the replies. I just wondered why owa would be just plain text. Maybe something for Microsoft to work on.
Maybe there's a Settings somewhere to change it?

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-07-2019, 11:57 AM   #8
hinchi1
Newly Registered User
 
Join Date: Oct 2017
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
hinchi1 is on a distinguished road
Re: Hyperlink email body text

Looked to change settings but cannot see anything. Will contact our IT department for possible solutions.
hinchi1 is offline   Reply With Quote
Old 11-07-2019, 12:00 PM   #9
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,332
Thanks: 432
Thanked 790 Times in 766 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Hyperlink email body text

Well an easy test would be, can you do it manually.?

If so, send it to yourself, and then look at the source.?

That should tell you what you need, if it can be done.?

HTH
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
Old 11-07-2019, 12:03 PM   #10
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,721
Thanks: 57
Thanked 1,260 Times in 1,241 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Hyperlink email body text

Quote:
Originally Posted by hinchi1 View Post
Looked to change settings but cannot see anything. Will contact our IT department for possible solutions.
Hi. If you have to go through IT, then maybe the answer would be a no. For example, at out work, HTML emails are permanently disabled because it can contain links or code (like JavaScript) that could be dangerous to the company network.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 11-07-2019, 12:13 PM   #11
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,332
Thanks: 432
Thanked 790 Times in 766 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Hyperlink email body text

Well I took it to be plain text as you have vbCRLF in your email body string.?

Quote:
Originally Posted by hinchi1 View Post
Thanks for the replies. I just wondered why owa would be just plain text. Maybe something for Microsoft to work on.

__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink in Email Body Wayne Modules & VBA 12 06-11-2019 12:43 PM
Email Body Text below signature debson Modules & VBA 9 03-17-2013 06:06 PM
Email, body text seany Modules & VBA 1 07-07-2005 02:27 AM
Parse Email Body Text NickBridgens Modules & VBA 3 01-25-2002 03:32 AM




All times are GMT -8. The time now is 08:05 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World