none
Access Web App SendEmail with hyperlink to new record RRS feed

  • Question

  • Using the SendEmail() function, I've written a macro in my Access web app that will send a notification to a specified user when a new record is created in a table.  I want to include in the message a hyperlink that will take the recipient user to the specific page (view) and record of the newly created record.  I'm able to create a hyperlink that gets the first part done; it will take the user to the  view where all the records are displayed (https: ... default.aspx#Tile=BusinessRegistrations&View=BusinessRegistrations%20List).  I can't figure out the last piece that will display the specific record.  I have a variable in the macro (varNewRecordID) that is set to the new record ID.  Any help will be greatly appreciated.

    Ken


    Ken Warthen

    Monday, December 28, 2015 3:18 PM

Answers

  • Hi Ken,

    Based on my understanding, the Access web app was not able to retrieve the URL query string from the macro. So it is not able to create a view to display the specific record through the hyperlink we send to others.

    A workaround is that we can sent users the detail information with the field information and the hyperlink of the list view, then end-user can research this record based on the field information.

    In addition, if you want Access web app to support retrieve the value from hyperlink, you can try to submit the feedback from link below:
    Welcome to Access Suggestion Box! - UserVoice

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, December 29, 2015 5:40 AM
    Moderator

All replies

  • I looked into this but could not find a solution. First I thought a simple "&ID=123" would work but it doesn't. Use Access UserVoice if you feel strongly about this and want to push for it.

    -Tom. Microsoft Access MVP

    Tuesday, December 29, 2015 3:48 AM
  • Hi Ken,

    Based on my understanding, the Access web app was not able to retrieve the URL query string from the macro. So it is not able to create a view to display the specific record through the hyperlink we send to others.

    A workaround is that we can sent users the detail information with the field information and the hyperlink of the list view, then end-user can research this record based on the field information.

    In addition, if you want Access web app to support retrieve the value from hyperlink, you can try to submit the feedback from link below:
    Welcome to Access Suggestion Box! - UserVoice

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, December 29, 2015 5:40 AM
    Moderator