Hi all, I have VBA code where I send e-mails to x people (100-400) with y images (2-10). For creating images, I use:
And then in another sub I create temporaty sheets where I copy the data from pivots, past the data as tables and use these sheets in the loop. My loop filters every single person in each temporary sheet and creates images with code above. Then it embeds these images in e-mail body for that person. A part od code in the loop:Please Login or Register to view this content.
Story: I had been using it on my old computer with Excel 2016. It worked fine for some time, but then it started to send one of the images empty to around 10% of people. Then I received a new computer with Excel 2016, but I installed Excel 2019. I started to send e-mail from the new computer. It worked perfectly. But recently it started to send 1-2 images empty to around 10% of people. So I started to use again my old laptop and guess what - it works perfectly therePlease Login or Register to view this content.
That's why I know that the code is correct. It's not the most optimal/efficient, but it works. I also share files and macros with others and everyhing works for them.
Have any of you an idea why such issue occurs? How to repair it? I'd be really grateful.
Bookmarks