Connecting VBA to Authorised SMTP
Results 1 to 4 of 4

Thread: Connecting VBA to Authorised SMTP

  1. #1
    Junior Member
    Join Date
    Jul 2003
    Posts
    4

    Connecting VBA to Authorised SMTP

    Howdy folks, was wondering if anyone knew how to connect to an authorised SMTP server, I can currently connect to an unsecured SMTP server but it's the auth that's getting in the way. I'm using Winsock to make the connection and send the data. Would appreciate any help given on this matter as it's for a college project I'm doing.

  2. #2
    Just Another Geek
    Join Date
    Jul 2002
    Location
    Rotterdam, Netherlands
    Posts
    3,403
    I'm guessing you wrote something yourself that can email?

    If you need to authenticate look at the RFC's to see which commands you need to send to the server.

    These may come in handy:
    RFC-2821
    RFC-2554
    Oliver's Law:
    Experience is something you don't get until just after you need it.

  3. #3
    Senior Member
    Join Date
    Nov 2001
    Posts
    1,255
    Have you looked to see if there are any SMTP handling DLLs you could then use inside your VBA? If you get docked marks for not reinventing the wheel, I'll lend you my prof smashing stick.

    On a more serious less frustrating note, in addition to the RFCs, what you may want to do is pull up a packet sniffer (say Ethereal) and have it watch your SMTP traffic, then send an email through outlook or something using the same server. Once you see how all the traffic works, you'll have a better understanding of how to go about it. I've used this approach in several projects (for work and for school).
    Chris Shepherd
    The Nelson-Shepherd cutoff: The point at which you realise someone is an idiot while trying to help them.
    \"Well as far as the spelling, I speak fluently both your native languages. Do you even can try spell mine ?\" -- Failed Insult
    Is your whole family retarded, or did they just catch it from you?

  4. #4
    Junior Member
    Join Date
    Jul 2003
    Posts
    4
    Thanks guys. chsh, if I could have a look at your DLL's that would be great. I don't think I'm going to be docked marks for it considering my lecturer has no idea how to do it herself so any solution I come up with will be new to her. GREAT FUN!

    Thanks SirDice, those links helped me understand what was going on a lot better. Cheers buddy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •