Outlook batch email PDF

[Ruegen]

I've been given the task of making a button that batch emails bookings of all the schools on the database that have booked with each their own PDF (print report already made).

So I have the query and report made - before I head into trying to make this happen I thought I'd ask for the best method.

The query includes the emails
The schools can't have a pdf showing other schools details (I assume each report gets individually made into a pdf rather than a combined pdf)


Batch emailed via Outlook I am guessing
Guessing this is a task that takes time so the person walks away and lets outlook do it's work if there are 700 schools to email (although working in the background would be nice)

Any advice much appreciated.

[June7]

You will have to use VBA. Common topic. Search forum and Google. Here is a start:

https://www.accessforums.net/import-...ook-18221.html

https://www.accessforums.net/access/...ect-17713.html

[Ruegen]

Thanks I will have a read through these links

[Ruegen]

Thanks I will have a read through these links

I'm up to a stage of sending off emails but one last thing I am confused about

with docmd.sendobject I have the option of sending a report

how do I use that using the outlook object library vba? (as a PDF)

[ItsMe]

Use docmd.openreport then send object then docmd.close acreport

Or something

[June7]

SendObject doesn't need the Outlook library because not manipulating an Outlook object.

If email is a simple message and don't have to do other attachments to email, SendObject might be adequate.

[Ruegen]

??

But how do I ensure the email I send off using outlook library gets an attached PDF like I would using sendobject?

[June7]

That requires first saving the report as an external PDF file (OutputTo method) and then attaching that file to the Outlook email object.

I think Access can save as PDF without having any Adobe software installed.

[Ruegen]

That requires first saving the report as an external PDF file (OutputTo method) and then attaching that file to the Outlook email object.

I think Access can save as PDF without having any Adobe software installed.

oh....

[Ruegen]

I think I will use this

http://stackoverflow.com/questions/2...of-values-from

What do you think?

[June7]

That should save the PDF file.

Then follow with the email code that attaches the file.

Then code can even delete the PDF file.

[ItsMe]

Maybe something like

        DoCmd.OpenReport "rptName", acViewPreview, , strCriteria, acHidden
        DoCmd.SendObject acSendReport, "rptName", acFormatPDF, strEmail, , , "Subject Line", "Body of Email", True
        DoCmd.Close acReport, "rptName"

[ItsMe]

I was typing from my phone earlier....

[Ruegen]

Maybe something like

        DoCmd.OpenReport "rptName", acViewPreview, , strCriteria, acHidden
        DoCmd.SendObject acSendReport, "rptName", acFormatPDF, strEmail, , , "Subject Line", "Body of Email", True
        DoCmd.Close acReport, "rptName"

Problem is I'm using outlook object library

i.e.

'open Outlook, attach zip folder or file, send e-mail
With MailOutLook
    .BodyFormat = olFormatHTML
    .To = "email@email.com.au"
    ''.cc = ""
    ''.bcc = ""
    .Subject = msubject & " " & emailofsc
    .HTMLBody = messagebody  


    .DeleteAfterSubmit = False 'This would let Outlook send the note without storing it in your sent bin
    .ReadReceiptRequested = True
    .send

[June7]

Why do you need to use that method?