Hi
I have a fairly simple VBA procedure that uses the DoCmd.SendObject process to create an email which includes values pulled from a recordset (that was created by a query) - and it works fine.
The email is to tell players and umpires in my hockey club when and where their next game is and the start time etc.
What I would really like to do to add some polish to this email is to include one of those little 'Add to Calendar' links - I think it is an ical file? - so the player receives the email, and they can just click that link or attachment, and it adds the details of the match to their calendar.
Honestly - I have no idea how to start, or if it is even possible, as I have read that the standard SendObject process is quite limited in terms of handling emails, attachments, etc.
Any help much appreciated - solutions are great, but just pointers in the right direction fine! My VBA if quite limited but willing to learn more/research/improve with some help
Thanks
I have a fairly simple VBA procedure that uses the DoCmd.SendObject process to create an email which includes values pulled from a recordset (that was created by a query) - and it works fine.
The email is to tell players and umpires in my hockey club when and where their next game is and the start time etc.
What I would really like to do to add some polish to this email is to include one of those little 'Add to Calendar' links - I think it is an ical file? - so the player receives the email, and they can just click that link or attachment, and it adds the details of the match to their calendar.
Honestly - I have no idea how to start, or if it is even possible, as I have read that the standard SendObject process is quite limited in terms of handling emails, attachments, etc.
Any help much appreciated - solutions are great, but just pointers in the right direction fine! My VBA if quite limited but willing to learn more/research/improve with some help
Thanks