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

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.
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button - Send and Save 2
using lotus notes 3
Send Mail using Lotus Notes 1
Sending e-mails from specific email address 2
Access Automatically Send a notification email once a record is added 0
Creating and displaying an email in lotus notes thorugh excel Options 1
need to create shortcut button in Excel spreadsheet 1
Send email in Lotus Notes 2

Top