VBA Code to send email from Lotus Notes

[megairwalk]

Hello,

I have an excel document that I would like to insert a Submit button that will send out the Excel document to a number of people.

My thought would be to click submit in Excel and then it will attach the file to a Lotus Notes email with about 5 peoples name automatically appearing in the To field.

I am hoping to have the body of the email contain a message as well as the Subject Line.

Does anyone know of a VBA script that can do all of this for me?

Your help and time is appreciated

 

[Smitty]

Welcome to the Board!

I don't have it handy on this computer, but if you do a board search for "Lotus Notes" you'll find some code that will do what you want.

HTH,

 

[megairwalk]

Hi Smitty, thanks for the quick reply.

I have looked on the board earlier, but none of the VBA scripts will do what I am looking for.
Some you have to manually enter in the subject line and add the recipients in a pop up box and others give the option for me to put in a users email, but nothing in terms of body text and subject line.

Any help is great.

 

[Smitty]

See if this helps:

VBA Tips & Tricks: Automate Lotus Notes eMail using Visual Basic

And instead of static messages/addresses, you can always use range references. Unfortunately for you (but thankfully for me) I no longer have to use Lotus Not(s), so I can't test any code changes, but it's all very doable.

 

[megairwalk]

Hi Smitty, problem with the code you sent is that it has to form with my Lotus Notes NSF file.

The excel file that I want to incorporate the submit button \VBA script to will be on a server accessed by multiple people using their lotus notes programs.

Any other thoughts?

 

[Smitty]

Unfortunately, like I said, I don't use Lotus Notes anymore, so about all I can do is point to links.

As soon as I get my PC back from the shop in a few days, I'll be able to post some code.