Results 1 to 2 of 2
  1. #1
    Ultimateneo is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2018


    Hello i am using the code below, but when i have the email generated in outlook the to section has after the email address #mailto and part of the name. How do i get it to be just the email address in the to of the email?

    Private Sub CurrentEmail_Click()
        Dim oApp As Outlook.Application
    Dim oMail As MailItem
    Set oApp = CreateObject("Outlook.application")
    Set oMail = oApp.CreateItem(olMailItem)
    oMail.Body = "Dear," & Me.CurrentFirstName & Me.CurrentLastName
    oMail.Subject = "Test Subject"
    oMail.To = Me.CurrentEmail
    Set oMail = Nothing
    Set oApp = Nothing
    End Sub
    Thank you for any help provided much appreciated

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    Isn't this just a continuation of this thread?
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

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

Similar Threads

  1. E-Mail code adding #mailto:
    By SMcGrath in forum Programming
    Replies: 2
    Last Post: 12-23-2013, 11:47 AM
  2. mailto with Subject
    By umarus in forum Programming
    Replies: 4
    Last Post: 12-20-2012, 12:58 PM
  3. embed mailto in access sharepoint form
    By johnhoare65 in forum SharePoint
    Replies: 2
    Last Post: 12-23-2011, 03:00 PM
  4. Quick help w/ Mailto??
    By Visfire in forum Programming
    Replies: 3
    Last Post: 09-17-2010, 08:36 AM
  5. Replies: 1
    Last Post: 06-08-2010, 12:08 PM

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 - Senior Forums