Solved Help on blank Email body (1 Viewer)

lookforsmt

Registered User.
Local time
Today, 14:59
Joined
Dec 26, 2011
Messages
672
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

I’m here to help
Staff member
Local time
Today, 03:59
Joined
Oct 29, 2018
Messages
21,358
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:
Code:
Public Const olMailItem As Long = 0
 

bastanu

AWF VIP
Local time
Today, 03:59
Joined
Apr 13, 2010
Messages
1,401
Or the OP had a reference to Outlook even if if using late binding:
Capture.PNG
 

bastanu

AWF VIP
Local time
Today, 03:59
Joined
Apr 13, 2010
Messages
1,401
Here you are, I suggest you spend some time to look at the code.

Cheers,
Vlad
 

Attachments

  • SendEmail_11_Vlad.zip
    38.2 KB · Views: 144

theDBguy

I’m here to help
Staff member
Local time
Today, 03:59
Joined
Oct 29, 2018
Messages
21,358
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!
 

Attachments

  • SendEmail_11.zip
    41 KB · Views: 139
Last edited:

lookforsmt

Registered User.
Local time
Today, 14:59
Joined
Dec 26, 2011
Messages
672
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

AWF VIP
Local time
Today, 03:59
Joined
Apr 13, 2010
Messages
1,401
You're very welcome, good luck with your project!
Stay safe!
 

Users who are viewing this thread

Top Bottom