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.

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.

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.

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.

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.

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.

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.