how do i create a button on excel which would send an email / Lotu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to have a control button which would send an email to a specified
e-mail address . The goal would be be able to click a button which sends the
contents of a cell as the subject line from my work e-mail address (which I
can only access using Lotus Notes) to some outgoing email address.

Normally, I just copy the contents of the cell, log into my lotus notes
email account, paste onto the subject line, and send an e-mail. But I would
like to automate this proccess using some sort of excel programming. Would
appreciate ideas. Xavier.
 
Hi Ron,

This is exactly the type of thing that I'd like to run. However, I get the
following error when I try and run this macro:

Compile Error:
User-defined type not defined

This refers to this line:

Dim Data As DataObject

I think this may have something to do with not having "Microsoft Forms 2.0
Object Library" installed - how do I check if this is installed, and how do I
install it if it's not?

Thanks for your time,
Atreides
 
Ah, I managed to figure this out! For anyone else following in my newbie
footsteps:

Open the module, go to the Tools menu, then References, then check
"Microsoft Forms 2.0 Object Library"

+

Another question though: How would we make it so that you can choose which
email address to send it to before it sends?

Thanks
Atreides
 
Back
Top