Send PDF document via Send Command

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Hi

I have an Access macro that uses a Send Object Action to send an Access
report to different people via email Outlook...I pick "Report" from the
Object Type argument, then select the Report object name to send via email
Outlook.

However, I also want to send in the same macro and same email a PDF document
(created OUTSIDE OF ACCESS) along with the Access Report...how can I send
another pdf document so the email being sent has 2 attachments...one pdf
document that is an Access Report and another pdf document that is a letter
created outside of Access.

thank you very much for any assistance!!

Craig
 
SendObject does not permit external attachments. As such you have to use
automation to send e-mails. If you are using Outlook then you can use the
procedure found at

http://www.devhut.net/index.php?lang=en&pid=0000000013#OutlookAuto

If you are not using Outlook, give us some information so we can better
guide you.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Dan,

Thanks but I am not great with VBA so was wondering if I can have a macro
that has 2 Send Objects in it.

The first Send Object would be to send the Report via outlook.

Then with the next Send Object in the macro, could it involve the following:

First, I would Create a small module in Access, lets says its called "TEST"
that goes something like this:just have one or two statements that say
something like this:

DoCmd.Send Object "path\name.pdf"

Then go back to my macro and insert a SendObject action with the Object Type
being "Module"

The Object Name "TEST"

Output format = PDF

Then when I run my macro the first Send Object would send the Report to the
email address and then the second Send Object would send, in a separate
email, the PDF external doc to that same email address.

Is this doable? If so, could you help me with the statement:
DoCmd.Send Object "path\name.pdf"

Thanks very much!!

Craig
 
Craig,

Sadly, sendobject will not attach external objects. So your only solution
is to do some VBA programming. If you have questions just ask and we will
help you.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Back
Top