Send email from a VBA macro?
 

Can i send an email from an Excel 2003 macro under XP SP 2?

Not just get into Outlook Express (I think, just possibly my client has
Outlook),
but also fill up the message and send it.

Thanks,
Peter

Send email from a VBA macro?
 

Peter, have a look at Ron's site here
http://www.rondebruin.nl/sendmail.htm#Tips He is "the man" on the subject
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Peter Chatterton" wrote in message
...
Can i send an email from an Excel 2003 macro under XP SP 2?

Not just get into Outlook Express (I think, just possibly my client has
Outlook),
but also fill up the message and send it.

Thanks,
Peter

Send email from a VBA macro?
 

Thanks Paul, that looks like a great resource!

Peter.

"Paul B" wrote in message
...
Peter, have a look at Ron's site here
http://www.rondebruin.nl/sendmail.htm#Tips He is "the man" on the subject
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Peter Chatterton" wrote in message
...
Can i send an email from an Excel 2003 macro under XP SP 2?

Not just get into Outlook Express (I think, just possibly my client has
Outlook),
but also fill up the message and send it.

Thanks,
Peter

Does anyone knows how to build macro in excel?
 

Hi Le Jurassien

See this page for example code
http://www.rondebruin.nl/copy5.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl



"Le Jurassien" wrote in message
...
Hello,
I need help in creating a macro that selects all identical numbers in
column
B from the main sheet then move all data associated with the identical
number
to a new sheet. For example: Tab 1 (contains the main report), Tab 2 (will
consist of all the 001s Id number), Tab 2 (all the 005s id), Tab 3 (all
the
0017s id code) etc...

Thanks,
Jurassien