vba to send email and attachments via lotus 8.5

Hi all,

I have found a code at http://www.fabalou.com/VBandVBA/lotusnotesmail.asp. The code is supposed to send email and attachment using vba.

Please Login or Register  to view this content.

qn1 : which "UserName" should i change to my own username?
eg, my username is Dan2010.

Please Login or Register  to view this content.

do i change all the "UserName"?

qn2 : which "Attachment" should i change to the location of my attachment?
for eg, my attachment is at c:\Users\Dan\newfolder

Please Login or Register  to view this content.

qn3 : what other commands do i have to add if i need to attach more than 1 attachment?
ps : my attachments can be in pdf format or jpeg

Thanks alot in advance

Regards,
Dan

I'm off out soon so haven't time to specifically answer your questions (I also don't use Lotus any more so can't test anything) but the attached is a more simplified code for sending a workbook as an attachment via Lotus. In this case it's the active workbook but can be quite easily adapted to be any file you want.

To add more than one attachment you would just either repeat these lines with the specific attachment required assigned to stAttachment or create some kind of loop:

Please Login or Register  to view this content.

Hope it helps,

Dom

To answer your questions:

1. No change should be necessary because Session.UserName should be your user name. Verify this by stepping through the code in the debugger.

2 and 3. In your posted code the Attachment variable is a string containing the full path and filename of an attachment, so this is the part you need to change. You'll also need to specify a unique rich text item name for each attached file. For example:

Please Login or Register  to view this content.

i shall try that tomorrow when i have access to lotus. thanks