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

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.

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

See this website for the vba code:

Q10081 - HOWTO: Send data from a range as part of an e-mail's body
http://www.excelkb.com/article.aspx?...1&cNode=1X5M7A

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Xavier" wrote:

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.

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

Start he

http://www.rondebruin.nl/sendmail.htm


--
Gary's Student


"Xavier" wrote:

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.

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

Thanks Ron. This is great! ~Xavier

"Ron Coderre" wrote:

See this website for the vba code:

Q10081 - HOWTO: Send data from a range as part of an e-mail's body
http://www.excelkb.com/article.aspx?...1&cNode=1X5M7A

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Xavier" wrote:

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.

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

okay. I'll check these out thanks G.

"Gary''s Student" wrote:

Start he

http://www.rondebruin.nl/sendmail.htm


--
Gary's Student


"Xavier" wrote:

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.

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

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


"Ron Coderre" wrote:

See this website for the vba code:

Q10081 - HOWTO: Send data from a range as part of an e-mail's body
http://www.excelkb.com/article.aspx?...1&cNode=1X5M7A

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Xavier" wrote:

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.

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

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



"Atreides" wrote:

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


"Ron Coderre" wrote:

See this website for the vba code:

Q10081 - HOWTO: Send data from a range as part of an e-mail's body
http://www.excelkb.com/article.aspx?...1&cNode=1X5M7A

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Xavier" wrote:

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.