aol mail workaround problem

[Tom Wright]

in an excel file my embedded vb has a workbook that the vb emails to
another computer for processing using the SendMail method for a
workbook.

it works in general but not on aol. unfortunately aol strips of the
Subject and prompts the user for it and the To field.

on the receiving computer the subject is used by vb in outlook to
detect legitimate submissions and is complex and must be exactly
right. we don't want the processing computer to try to process spam or
other non-conforming email.

i thought i would get around this aol problem by modifying the outlook
vb to also look at the message body, which i've done, and by modifying
my excel vb to also put the subject as the email body. unfortunately
the SendMail method for a workbook does not support a body.

is there another excel method to send email with a subject, body, and
an attached file? i couldn't find it using f2.

thanks,
tom
san diego

[Samuel Hon]

have a look for CDONTS. This should be able to do it

Tom Wright <tj*@wherever.com> wrote in message news:<lj********************************@4ax.com>. ..

in an excel file my embedded vb has a workbook that the vb emails to
another computer for processing using the SendMail method for a
workbook.

it works in general but not on aol. unfortunately aol strips of the
Subject and prompts the user for it and the To field.

on the receiving computer the subject is used by vb in outlook to
detect legitimate submissions and is complex and must be exactly
right. we don't want the processing computer to try to process spam or
other non-conforming email.

i thought i would get around this aol problem by modifying the outlook
vb to also look at the message body, which i've done, and by modifying
my excel vb to also put the subject as the email body. unfortunately
the SendMail method for a workbook does not support a body.

is there another excel method to send email with a subject, body, and
an attached file? i couldn't find it using f2.

thanks,
tom
san diego

[the Wiz]

Tom Wright <tj*@wherever.com> wrote:

in an excel file my embedded vb has a workbook that the vb emails to
another computer for processing using the SendMail method for a
workbook.

it works in general but not on aol. unfortunately aol strips of the
Subject and prompts the user for it and the To field.

on the receiving computer the subject is used by vb in outlook to
detect legitimate submissions and is complex and must be exactly
right. we don't want the processing computer to try to process spam or
other non-conforming email.

i thought i would get around this aol problem by modifying the outlook
vb to also look at the message body, which i've done, and by modifying
my excel vb to also put the subject as the email body. unfortunately
the SendMail method for a workbook does not support a body.

is there another excel method to send email with a subject, body, and
an attached file? i couldn't find it using f2.

thanks,
tom
san diego

Try the free SMTP control from www.ostrosoft.com
This will allow you to send mail without using Outlook.

More about me: http://www.jecarter.com/
VB3/VB6/C/PowerBasic source code: http://www.jecarter.com/programs.html
Freeware for the Palm with NS Basic source code: http://nsb.jecarter.com
Drivers for Pablo graphics tablet and JamCam cameras: http://home.earthlink.net/~mwbt/
johnecarter at@at mindspring dot.dot com. Fix the obvious to reply by email.