question

KageDev-6020 avatar image
0 Votes"
KageDev-6020 asked KageDev-6020 edited

Outlook VBA Code Disappearing - partially


Hi,

I have a very extensive outlook VBA Macro that creates an html formatted email containing information pulled from a database. The code is working wonderfully, however, it seems that about every month or so about half of my code disappears from the macro on 4 client machines. The code always cuts off at the same line on all 4 machines and the macro is no longer functional. I have to go to a backup copy of the macro and move it to the machines so that the end users can continue using it.

Without posting all of the code here is what happens:

A window appears when I open up the developer tab (see below image). When I click yes and open the developer tab and then the code, it cuts off at line 188. The code is supposed to be 432 lines long.

Has anyone ever experienced this or have any idea why this would occur. I am at a complete loss here.

135652-error-msg.png

office-vba-dev
error-msg.png (5.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers