R
RL
Good afternoon,
I have developed a customer database within Access 2007. From within a
customer's record, I would like users to be ablet to select a PDF document
from a combo box and email it at the click of a button.
I have played with SendObject, and have got as far as opening an email with
the appropriate email address, subject and content.
I have also toyed with FollowHyperlink, which now opens the PDF selected in
the combo box.
I am struggling to combine the two and attach the selected document to the
email.
Is this possible within Access? Can anyone advise me what I need to do
(baring in mind that my VBA is limited!).
Thanks in advance,
RL
I have developed a customer database within Access 2007. From within a
customer's record, I would like users to be ablet to select a PDF document
from a combo box and email it at the click of a button.
I have played with SendObject, and have got as far as opening an email with
the appropriate email address, subject and content.
I have also toyed with FollowHyperlink, which now opens the PDF selected in
the combo box.
I am struggling to combine the two and attach the selected document to the
email.
Is this possible within Access? Can anyone advise me what I need to do
(baring in mind that my VBA is limited!).
Thanks in advance,
RL