Solved Help on blank Email body (2 Viewers)

[lookforsmt]

the attached db was working perfectly fine earlier. i tried to but not able to get this working'
Dear Minty, i tried adding the above mentioned set objMail to the code but not sure how to take it forward
request if you may have a look at the attached db for the actual issue

 

[theDBguy]

So I am so puzzled now as to how it all worked before

My guess would be that there was a local constant used to represent it. For example:

Public Const olMailItem As Long = 0

 

[bastanu]

Or the OP had a reference to Outlook even if if using late binding:

 

[lookforsmt]

Any help from anyone here pls

 

[bastanu]

Here you are, I suggest you spend some time to look at the code.

Cheers,
Vlad

 

[theDBguy]

Hi. Here's my quick attempt. It's not quite complete as I ran out of time. For some reason I can't investigate right now, it keeps accumulating the records in the email table. Sadly, I have to leave the office right now. Hopefully, it will help still. Cheers!

 

[lookforsmt]

HI! bastanu and everyone here, Apologies for the delay,
I have checked the codes and adjusted to my requirement and it works perfectly fine.
Want to thank bastanu and everyone for their valuable time and help.

thanks again, i will close this thread as Solved

 

[bastanu]

You're very welcome, good luck with your project!
Stay safe!