I have question regarding the attachment in Access 2010.
I have a table name called NewJobsTbl and i have column for attaching some pdf drawings to it at the time when we receive the Fabrication drawings in PDF format.
Now my requirement is when i am releasing the particular job for fabrication i will update the PO release date and from there i have created a macro that works after updating the records and the PO release column has today's date it will send send an email to the concerns mentioning the job release.
I am utilizing this for the past 2 months and some of my staffs they are asking for the fabrication drawing along with that mail then i am started doing the both the things, first when i update the date macro will send an mail, and i will write a personal mail using outlook attaching with that fabrication drawing.
Is there any way to forward the available attachment with that particular record along with the mail which has been created by the macro.
Your support will help me a lot and thanks in advance and sorry i am not attaching the sample database since web site doesn't allow me to load file size 650 kb.