aol mail workaround problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tom Wright
    #1

    aol mail workaround problem

    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
    Tags: None
    • Samuel Hon
      #2
      Re: aol mail workaround problem

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

      Tom Wright <[email protected] om> wrote in message news:<ljlf10tqb scj6c3tmh3sta8s navf99i37l@4ax. com>...[color=blue]
      > 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[/color]

        Comment

        • the Wiz
          #3
          Re: aol mail workaround problem

          Tom Wright <[email protected] om> wrote:
          [color=blue]
          >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[/color]

          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.

            Comment

            Previous template Next
            Working...