Code Seems Broken Since Beginning Of Month

[JFJ]

Good Morning,
I have a code that converts a sheet to .pdf then opens Outlook for me to send an email.
Body of the email is a few lines and a "snapshot" of selected cells, also with an attachment of the sheet in .pdf form.
As of 01Jun, the worksheet seems to be broken. It no longer opens Outlook to send the email. I'm also getting a ":424 Run Time Error" now that wasn't there before.
Now, I, by no means, am an expert at this, but I am able to limp my way through it. And I can not find what the issue is. I have made multiple changes to no avail.
Below is the code, any help would be greatly appreciated.
NOTE: This is not my code, nor is it the person who created the workbook (looks like a template), but it had worked for years.

Thank you for your assistance!

Please Login or Register  to view this content.

[CK76]

At which line do you get the error?

Also, I'd recommend uploading sample workbook with full code. Without it bit hard to pinpoint the cause.

Looking at what you posted, there's two object variables... OutlApp and Out1App...
Reset of your code only uses latter. So, if Outlook was already open when the code executes... it will likely produce that error.

Try replacing latter with former for all instances.

FYI - Please use code tag (# button) when posting codes.

[JFJ]

At which line do you get the error?

Also, I'd recommend uploading sample workbook with full code. Without it bit hard to pinpoint the cause.

Looking at what you posted, there's two object variables... OutlApp and Out1App...
Reset of your code only uses latter. So, if Outlook was already open when the code executes... it will likely produce that error.

Try replacing latter with former for all instances.

FYI - Please use code tag (# button) when posting codes.

Thank you for the response.
I misspoke earlier as I am getting a "424:Object Required" error on the following line:

Please Login or Register  to view this content.

I can post the whole code, but I'm sorry as I'm not familiar with where/how to do it on this forum without just copying it in to a reply.

[dmcgov]

change this line:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

[CK76]

To upload a file...
Use "Go Advanced" button and follow "Manage Attachments" hyperlink. It will launch new tab/window for managing uploads.

[JFJ]

dmcgov,

Forgive me, but what is the difference between these two?

[JFJ]

Code is under "Daily Report" (sheet 1)

[dmcgov]

@jfj

the first line says Out"l"App and that is an L in the quotes
the second line says Out"1"App and that is a One in the quotes

[JFJ]

To upload a file...
Use "Go Advanced" button and follow "Manage Attachments" hyperlink. It will launch new tab/window for managing uploads.

Thank you!

[JFJ]

dmcgov,

Thank you, I see what you mean.
That is now corrected but I am getting a "Object Variable or With Block Variable Not Set" error

[dmcgov]

which line in the debugger is highlighted. i downloaded your workbook, changed OutlApp to Out1App and it worked (in that im getting no error's and the email popped up with the pdf attached)

[CK76]

I tested your file with recommendation I made in post #2. It worked fine.

0.JPG


See attached.

[JFJ]

Ok, Well that changes things.
When I run the code, it doesn't highlight, but the cursor stops on the line that I pointed at.
I also ran the code that was uploaded again, and it did the same thing. This my be more a OS issue than an excel issue.

[CK76]

That error means that you forgot to close With... statement with End With, or If with End If etc.

Did you use the file I uploaded without altering it?

[JFJ]

Yes sir, I did. With the same result. That is why i felt like it was no longer an Excel issue.
After digging in with my IT group, we found that they had implemented a new security program at the beginning of the month that "blacklisted" this particular excel sheet on this computer.
I'm sorry for wasting ya'lls time on this when it had nothing to do with the code, but I appreciate your assistance and your patience.

Thanks again.

[JFJ]

Ok, I may have spoke too soon, but I did go check the With and End With and it is there. I did try on the file that you uploaded (no altering) and it's giving me the same message. My IT said they Whitelisted the file, but I don't see a change.