Results 1 to 4 of 4
  1. #1
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    emails from Access making the emailid hyperlink work

    My URL hyperlink works but my eamilid hyperlink does not work. Does anyone know how to make it a link?


    Code:
    Txtbody1 = "https://www.xyzcompany.com/thenet/info "
    Txtbody2  = "1.  Download the questionnaire and census file to your local drive or network drive."
    Txtbody3 = "2.  Complete the Questionnaire as instructed and e-mail it to emailid@xyzcompany.com."
    Thx
    Russ

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    hello again Russ,

    If you're creating emails with VBA, you need to encode your links in HTML so they can be read on the other side when the server accepts the email:

    Code:
    "<a href='https://www.xyzcompany.com/thenet/info'>https://www.xyzcompany.com/thenet/info"></a>
    You can send email via plain text or HTML though, so you need to use this method especially if you're using the .HTMLbody property of the email object.

  3. #3
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    email via plain text or HTML

    Currently i am sending via plain text.
    I have not figured out how to send via HTML.
    Russ

  4. #4
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151
    I have it working. Added mailto: in front of the emailid.

    " Complete the Questionnaire as instructed and e-mail it to mailto:Returnemail@abc.com. "

    I was a little disappointed that the mailto: part comes accross too.

    The email body is text. If I can figure out how to change it to html probably I can make it look nicer.

    With plain text I can not do bold print either.

    Russ

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-31-2011, 03:19 PM
  2. Access emails
    By Gargen in forum Access
    Replies: 5
    Last Post: 08-04-2010, 01:10 PM
  3. Replies: 0
    Last Post: 06-29-2010, 12:04 PM
  4. Emails from Access
    By dbn00bz in forum Access
    Replies: 0
    Last Post: 12-07-2009, 07:55 AM
  5. Making the like operator work for fields
    By olidav911 in forum Queries
    Replies: 2
    Last Post: 06-06-2009, 01:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums