sending a mail from VBA excel
rhXX
how can i send a mail from excel using VBA.
that is, i have a program in excel (VBA) and at the end i obtain a
text file with the results.
i need to send a simple mail (TO:, SUBJECT: ) with this text info as
body of the mail.
i would like when i "click" my program, at the end it send this mail
i am using mozilla firefox, so i need to access to mozilla outbox, to
put the mail
is there some util program of mozilla firefox, which allow to put a
mail in the outbox automatically?
in order to run it from VBA?
tks in advance
David McRitchie
> how can i send a mail from excel using VBA.
> put the mail
Doesn't make any difference what someone is using to read
their email all you need is their email address. So since you know
how to use VBA should have been posted to
news://msnews.microsoft.com/microsoft.public.excel.programming
similar to how you posted here to
news://mozilla.org/mozilla.support.firefox
as it is an Excel question and has nothing to do with Firefox.
You might check out http://www.rondebruin.nl/sendmail.htm
for sending mail from Excel.
Please don't post Excel questions in this Mozilla newsgroups.
--
David McRitchie
rhXX
but i am asking about mozilla util:
is there some util program of mozilla firefox, which allow to put a
mail in the outbox automatically?
that is, forgetting wich client i am using, i want to put a mail in
the MOZILLA FIREFOX OUTBOX, automatically, that is, without human
intervention.
tks in advance
gNeandr
Ralph Fox
rhXX wrote:
Firefox does not have an email outbox.
Firefox is not an email client.
Perhaps you are thinking of Thunderbird or of Seamonkey,
or perhaps you are thinking of a web mail interface.
This is not clear from your message.
Can you clarify.
> tks in advance
David McRitchie
part so maybe it is of interest after all, and, of course, as Ralph
mentioned it is Thunderbird not Firefox that does mail. That leaves
how another program would be integrated.
WebMail
"The Webmail extension integrates web site based email accounts in to Mozllia Thunderbird, this allows Thunderbird to download and
to send emails using the web site.
Currently Yahoo, Hotmail, Lycos (Europe), MailDotCom, Gmail, Libero, and AOL domains are supported. "
http://webmail.mozdev.org/
--
David McRitchie, most questions have been asked before.
Firefox customizations/extensions notes, see
http://www.mvps.org/dmcritchie/firefox/firefox.htm
"Ralph Fox" <-...@-.invalid> wrote in message news:6udt531kn525m9s5a...@4ax.com...
rhXX
yes, i was talking about MOZILLA Thunderbird
sorry again! im new with both mozillas, and i confused browser with
mail client
:-(
Ralph Fox
rhXX wrote:
> On 31 May 2007 04:37:20 -0700, in message <1180611440.6...@g4g2000hsf.googlegroups.com>,
> rhXX wrote:
>
> > david, tks,
> >
> > but i am asking about mozilla util:
> >
> > is there some util program of mozilla firefox, which allow to put a
> > mail in the outbox automatically?
> >
> > that is, forgetting wich client i am using, i want to put a mail in
> > the MOZILLA FIREFOX OUTBOX, automatically, that is, without human
> > intervention.
[crosspost and followup set to mozilla.support.thunderbird]
You could append the message to the "Unsent Messages" file, which
is in MBOX format. You might also need to delete the summary
file "Unsent Messages.msf" file to ensure that it is regenerated
correctly. This might not be possible if Thunderbird is running.
When you append the message to "Unsent Messages", you should
include the "X-Mozilla-Status:" and "X-Mozilla-Status2:" headers
with appropriate values (check a newly created unsent message
for values), so that T'bird can update these when the message is
sent. (Otherwise, if "Unsent Messages.msf" is deleted, the
message may re-appear in a state ready for sending again.)
If this is just for your own use, you could hard-code the location
of the "Unsent Messages" file. If it is to be deployed on lots of
computers with different configurations, you may need to
programmatically find where the "Unsent Messages" file is.
--
Cheers,
Ralph