Results 1 to 11 of 11
  1. #1
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185

    Return An Email With Mail Body Options

    Hi Guy's a bit of a long shot, has anyone tried to send an email out in html and within the html body by Access VBA where there is a link so that the recipient can:

    Mail Out to recipient

    Please find consignment details of your collection which is ready to collect

    Please inform us of your anticipated collection day and part of day

    Click here for Next Day AM

    Click Here for next Day PM

    Click here for 2 days AM

    Click here for 2 days PM

    Click here for 3 days AM

    Click Here for 3 days PM

    return mail by recipient

    each click here option returns a mail back to us to confirm anticipated collection period

    unsure if anyone has asked, tried or succeeded with something like this ?

    ----------------------------------------------------------

    I have mails going out regular in another project in html with a hyperlink

    click here to go to THIS web page

    click here to go to THAT web page



    click here to go to THE OTHER web page

    Was unsure if a link can be a return email instead ?

    ps: just tell me I'm barking up the wrong tree if there is no option

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    You can use a mailto link, but would still need user to confirm it going I believe?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185
    WGM thank you I know what you mean, instead of directing to web page, direct to me@home.com for example

    but the actual options i thought may not be an option without the recipient input

    Thanks anyway for your response

  4. #4
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185
    Click here for specific replies i meant

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Like WGM (I think) the html tags should be able to open an email message window with certain property values filled in but the user would have to click send (and could thus edit). Surely to be able to automatically send email from someone else's system because they clicked a link just cannot be possible if that's what you're asking. If anyone knows different I'd sure like to read about it. Maybe this will help with some of the tags
    https://www.computerhope.com/issues/ch000056.htm
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185
    I currently use something like this, I can easily change the web page link to an email address, it was can I add want i want the recipient to choose to return the mail

    disregarding all strings set etc because code is large, where i have wiped out web site name, have an email address with some options in the mail body where the excipient can click an option and it replies back with an answer, but going off yours and WGM reply, don't think its possible


    Code:
    Set myItem = myApp.CreateItem(olMailItem)    With myItem
         Set OutAccount = myApp.Session.Accounts.Item(2)
           .To = Me.txtEMail
           .Subject = "job Ref " & Me.RecordNo & " Reminder"
           .HTMLBody = strA & "<br>" & "<br>" & "<P><IMG border=0 hspace=0 alt='' src='file:" & imgPath & imgFile & "' align=baseline></P>" & "<br>" & "<br>" & _
           strB & "<br>" & "<br>" & BoxStart & FontStart & strC & "<br>" & "<br>" & strD & "<br>" & "<br>" & Replace(strE, "|", "<br>" & "<br>") & "<br>" & "<br>" & strF & "<br>" & FontEnd & BoxEnd & "<br>" & "<br>" & _
           BoxStart & FontStart & "<br>" & strG & "<a href=" & Q & ActBooking & Q & "> https://www.me.com/client-bookings </a>" & "<br>" & "<br>" & _
           strH & "<a href=" & Q & Rebook & Q & "> https://www.me.com/re-book </a>" & "<br>" & FontEnd & BoxEnd & "<br>" & "<br>" & _
           wkr & "<br>" & "<br>" & _
            myfName & "<br>" & "<br>" & _
            "<P><IMG border=0 hspace=0 alt='' src='file://T:/Sapphire/" & SigFile & "' align=baseline></P>"
           .SendUsingAccount = OutAccount
           .Display
        End With

  7. #7
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If that is Access code, I fail to see how it approaches what you asked about, which was how to control the email process on someone else's pc. That is, I click the link in the email I accepted and opened, and you want to control certain properties (e.g. CC or subject) and the body content (possible to a degree) BUT you also want it to automatically go to you without user intervention. The last part is what I'm saying surely cannot be possible. The rest, OK. Have I misunderstood the goal/question/problem?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  8. #8
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185
    Hi Micron ahh sorry so instead of:

    Code:
    "<a href=" & Q & ActBooking & Q & "> https://www.me.com/client-bookings </a>"

  9. #9
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185
    To this:
    Code:
    "<a href=" & Q & Click Here To Confirm 2 Days AM & Q & ">this email replies to us to say collection in 2 days AM </a>"

  10. #10
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185
    Yes i have this in HTML.Body on a email button

  11. #11
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Clear as mud. Sorry, I don't see what is wrong with answer in post 2. I'm out for most of the day so maybe someone else will carry on, or maybe this will help
    https://www.wikihow.com/Create-an-Email-Link-in-HTML
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Return Email Address From Selected Inbox Mail
    By DMT Dave in forum Access
    Replies: 15
    Last Post: 02-09-2022, 04:10 PM
  2. Extracting Part of Mail Body
    By DMT Dave in forum Access
    Replies: 2
    Last Post: 11-19-2019, 10:51 PM
  3. image to mail body
    By DMT Dave in forum Access
    Replies: 17
    Last Post: 08-06-2019, 03:17 AM
  4. add bmp from word doc to mail body
    By DMT Dave in forum Access
    Replies: 1
    Last Post: 05-22-2018, 05:53 PM
  5. Replies: 3
    Last Post: 05-18-2015, 11:24 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