Gregory Long
New member
- Local time
- Today, 12:51
- Joined
- Feb 23, 2022
- Messages
- 9
Hi Everyone. I am in need of help from someone that is way smarter than me. I created a simple database to keep track of personnel and their assigned tasks. I have an attachment MVF field in this database. I know they aren't recommended but it keeps everything in one place. Most of the attachments are 1 page PDFs. This database automatically sends a generic text email to the person when a task is assigned to them so they know to go and open the database and look at the request. I have now been asked if I can send any attachments that have been placed in the MVF attachment field of the record with the generic text email. Can this be done?
I have successfully sent myself an attachment from the database but the file was located in the same directory as the database so I just reference the filepath anf filename. How can one reference and select the items that are in the MVF field and send them instead.
Thanks in advance for everyone's help.
Greg
I have successfully sent myself an attachment from the database but the file was located in the same directory as the database so I just reference the filepath anf filename. How can one reference and select the items that are in the MVF field and send them instead.
Thanks in advance for everyone's help.
Greg