Search results for query: *

this can be closed, resolved in post: How to code in VBA a HTML body of email, fonts, hyperlinks for text fields... 2 thread705-1789919

Of course it was my typing! Can't copy to work machine... Left off the = after 'a href'! Much appreciated!

I got past the error but I am not seeing where any of the text is a hyperlink. Can you help me understand how a text value becomes a hyperlink?

Andy, any idea why I would be getting "Compile Error: Expected: end of statement on this statement: strBody = strBody & "Please contact <a href="http://www.Google.com">HR Services</a></p>" and the http is highlighted? Is there any particular reference that needs to be made?

This is perfect! Amazing 1 line of code to resolve bringing the template format .HTMLBody = .HTMLBody strongm, if you want to put that same suggestion in Post: thread705-1789870, I'll give you a star there also, I wasn't getting any hits there! Thanks again and also to Andy for the HTML...

Wow that sounds promising,let me try. I got the same error on the http highlighted end of statement error, like I need something set to reference http? Let me try what your suggestion strongm.

ok Andy, let me try what you just sent, thanks

I'll work on getting my code together because I'd like to show how I bring in the template which would be the ultimate because I would not need an attachment with the format I want for instructions, I could have those in the email itself! But for now when I am trying the example above from...

As far as examples, I am trying: "Hi " & ",<br><br>" & _ "THIS IS AN ALERT" & _ how to bold or change font? "Please contact HR Services" & _ how to underline HR Services and make it a hyperlink (<http://) and not show hyperlink?

If I am using the .oft template does the .HTMLBody need to be included in the VBA? What am I missing that is causing the formatted template from dropping the bolds and causing the actual URL hyperlinks to display If I decide not to use the .oft template I'm not sure how to code the .HTMLBody =...

I am building emails in VBA and would like to define the overall font for the body of the email. I would also provide text that would actually be a hyperlink, such as: go to this our SharePoint site and it would go to that site, or People names that would be a <mailto> link. I currently have...

I have decided to just add an attachment to the email in the VBA code so that I can maintain some formatting for the user. But I'd like to maintain the format the text that remains in the template email, such as Bold, font size, text fields that are hyperlinks (now the text is replaced with the...

I have this question posted in another area of this forum and didn't get any responses so I am posting it again here. Hi, I've been successful in sending emails using Outlook templates (oft) for only text and hyperlinks. But now I have a template that contains a table with images and text in the...

I have decided to just add an attachment to the email in the VBA code so that I can maintain some formatting for the user. But I'd like to maintain the format the text that remains in the template email, such as Bold, font size, text fields that are hyperlinks (now the text is replaced with the...

Hi, I've been successful in sending emails using Outlook templates (oft) for only text and hyperlinks. But now I have a template that contains a table with images and text in the table and it only creates the email with the text remaining in the email. Is there something else that has to be...

Hi, I had a thread a while back thread702-1783846 ["Access 2016 append query "long text" field is being truncated"] and was helped with a workaround. Just curious if anyone knows if Access 2016 has been provided a fix for this issue and would know the release number? I am continuing to...

Andy, I believe it is giving me what I need, I will check it again in the morning - it is on my work laptop. Thanks for all your help!

Actually, this is what Access changed it to in the query: <>"Mark tests" And <>"Bruce dfsdf" And <>"Cheri dfdhffh" And <>"John jgfjgjfgo" And <>"William fghfghr, III

Never mind I've got it - Not "name" And Not "name" Thanks!

Thanks! How to code the syntax for if it is NOT = or In