Sending Emails

[Radu84]

Hello Im using some vba code to send an email through Lotus Notes.
My problem is that if i attach an rtf document then it comes up as an attachment, which i do not wish. I would like to send the "bodytext" as an rtf instead of a simple string, is there any way to do that ?

 

[Radu84]

Bump, can anyone pls help ?

 

[Radu84]

This is pretty urgent, any help would be very appreciated.

Basically , I'm sending emails to Lotus Notes using vba from ms access. Each of the emails will be personalized according to a ms word rtf file. What I wish to do is NOT to attach this rtf file, but to put it in the body of the email, as when you normally send an email with formatted text. I have no ideas as how to do this with Lotus Notes

 

[Me!User]

Don't despair! Google it!

I googled "programmatically send email via Lotus Notes" and, after sifting through the results, came across the following useful examples:

Reply by "PAT_PENDING" shows VBA code to send email via Lotus Notes.
http://www.mcse.ms/archive153-2005-6-1702489.html

Alain Aucordier gives an example using VBScript (a touch different than VBA)"
http://cwashington.netreach.net/depo/view.asp?Index=761&ScriptType=vbscript

The good folks a Granite Consulting have grouped information on sending email in one handy place (I've bookmarked this one!):
http://www.granite.ab.ca/access/email.htm
Near the bottom of the page is a link to sending email via Lotus Notes.

In a nutshell, you need to set a reference to the Notes component in order to expose its object model to VB. The examples shows you how to retrieve the pertinent info (mail server name, etc), initialize the appropriate variables (To, From, Subject, Body, etc) and transmit the message.

 

[Radu84]

Thank you for your post,
But i was reffering to something else... I dont have a problem sending emails using vba through lotus notes, my problem is that i wish to attach a personalised rtf document for each customer, but i do not want it to come up as an attachment, instead i want it in rtf format as the body text of the email.

 

[Me!User]

I can't test my ideas because I don't have access to a Lotus Notes/Domino server environment. Are you using CREATERICHTEXTITEM(Doc, "Body")? If so, I believe that it will always appear as an attachment. Perhaps you've already tried this but I believe the key is the format of the "Body". Try formatting the body text in HTML and DON'T use CREATERICHTEXTITEM. I think the Domino server (post R5.0) will understand the format and display it correctly. The first test need not be complicated just a few lines of bold and itsalic text should be a sufficient test.