Outlook batch email PDF

[Ruegen]

Attachment 14731

my references

[Ruegen]

Something just dawned on me. The only thing late binding is going to do is allow for different versions of Outlook to work. It helps only when you need it to work on machines with Outlook installed.

so don't bother with late binding?

[Ruegen]

Can you try on another computer, another system, home computer, work computer?

The code works for me. Am on home computer now.

Did you use an actual email address in your code? I send to myself.

I tested with and without (I was surprised this worked) library reference. With Outlook open or closed.

different systems, windows etc same result

[Ruegen]

Couldn't I do a check first to see if the user has Outlook before running the code for the users without outlook to prevent errors?

[ItsMe]

I feel as though I am goofing things up. I definitely was and may still be confused about what you are trying to accomplish. If you want to send emails you can use CDO. If you need return receipt, I do not believe that will work with CDO. I will look for a schema though.

That leaves you with Outlook. If the machines are going to have different versions of Outlook, ie 2003, 2010, 2013, then use late binding.

[June7]

I think it is possible to check if Outlook installed but might be easier just to trap the error with error handler.

Also, might find this interesting http://www.cpearson.com/Excel/EMail.aspx

[Ruegen]

I feel as though I am goofing things up. I definitely was and may still be confused about what you are trying to accomplish. If you want to send emails you can use CDO. If you need return receipt, I do not believe that will work with CDO. I will look for a schema though.

That leaves you with Outlook. If the machines are going to have different versions of Outlook, ie 2003, 2010, 2013, then use late binding.

Yeah since I can't use CDO I will have to use outlook and just not reference the library for some of the users' front end - I can go back to trying to get outlook to work without the late binding as that doesn't seem to be working for me

[Ruegen]

I think it is possible to check if Outlook installed but might be easier just to trap the error with error handler.

Also, might find this interesting http://www.cpearson.com/Excel/EMail.aspx

The problem I see with CDO

no read receipt
no sent box

If I was using it I would use CDO but the requirements set by management make CDO not an option

[June7]

Then we are back to the mystery of why the code works for us but not you.

It's looking like error handler best way to deal with absence of Outlook.

[ItsMe]

Well, I got CDO to send a return receipt but if I use Bcc it will ask for two return receipts. This would be confusing to the user. I say Bcc, because there is no way for CDO to place the message in the sent folder. Of course, there probably is a way. I just don't know if it is worth it. Could be interresting to try though.

[Ruegen]

I think what you have will work. I tested the following and it worked for me. Remove the reference to Outlook Objects in your reference library thing before you run the code.

Private Sub cmdTest_Click()

Dim appOutLook As Object
Dim MailOutLook As Object
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(0)

With MailOutLook
    .BodyFormat = 2
    .To = "Email@Domain.com"
    ''.cc = ""
    ''.bcc = ""
    .Subject = "Subject Line"
    .HTMLBody = "This is the body of the Email"
    .DeleteAfterSubmit = False 'This would let Outlook send the note without storing it in your sent bin
    .ReadReceiptRequested = True
    .send
    
End With
 
End Sub

I have this working now,

I took out everything and am now working on the recordset

UPDATE: Infact I know why the error was happening and I will explain later

Dim appOutLook As Object
Dim MailOutLook As Object
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(0)

had to be placed just above the With MailOutlook

[ItsMe]

Did you see post #40 ?

[Ruegen]

Did you see post #40 ?

yeah - but as I am pressed for time I am going with outlook and just disabling the reference for the runtime users

[Ruegen]

Thank you to you both for help with this