Hello,

pardon me if this has already been asked but I was unable to find it
before hand.
I am very new to Excel and VB macro stuff.

Basically I need a macro which can go through a list of emails in
excel, put something in the subject line.
Then in the msg part of the email, I would like it copy particular
fields on a row and automatially sent that email.

I have gotton as far as creating a button in the Excel workbook and
opening the VB editor.

I have had a look at http://www.rondebruin.nl/mail/oebody.htm
But i do not understand where in the VB editor do I paste that code?

Please shed some light
Cheers in advance


--
periro16
------------------------------------------------------------------------
periro16's Profile: http://www.excelforum.com/member.php...o&userid=26345
View this thread: http://www.excelforum.com/showthread...hreadid=396103

This guy is using API calls to use Express to send a mail.

Ussually code like that is placed in a class module, but you place it
into a normal module to make it work.

He's using a sheet as a mailing list


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=396103

You would go into the VBE and with your workbook as the activeproject
(selected in the project explorer) you would do Insert=Module and place the
code in the resulting module.

for tutorials on using VBA, see David McRitchie's listing at:
http://www.mvps.org/dmcritchie/excel....htm#tutorials

VBA tutorials listed after the excel tutorials.

--
Regards,
Tom Ogilvy


"periro16" wrote in
message ...

Hello,

pardon me if this has already been asked but I was unable to find it
before hand.
I am very new to Excel and VB macro stuff.

Basically I need a macro which can go through a list of emails in
excel, put something in the subject line.
Then in the msg part of the email, I would like it copy particular
fields on a row and automatially sent that email.

I have gotton as far as creating a button in the Excel workbook and
opening the VB editor.

I have had a look at http://www.rondebruin.nl/mail/oebody.htm
But i do not understand where in the VB editor do I paste that code?

Please shed some light
Cheers in advance


--
periro16
------------------------------------------------------------------------
periro16's Profile:
http://www.excelforum.com/member.php...o&userid=26345
View this thread: http://www.excelforum.com/showthread...hreadid=396103