How can I set the FROM address in an Access email send? 2

[RikHess]

I have a situation where I'm emailing from an Access 2000 database. I have to customize each message extensively -- even the Subject.

This works -- but now I need to change the FROM address so it shows another email (not mine) when the message is sent.

Any ideas?

Thank you,
Rik

 

[KarMac21]

I'm assuming you are using an email application like Outlook or Outlook Express. What you need to do is create and send the email directly through your SMTP server. This will allow you to completely customize your email, including the From address.

 

[RikHess]

Thank you for what sounds like a solution to my problem. Would you mind giving me a little help on where to start getting some useful info on the SMTP server?

Google just gave me lots of vendors.

TIA!
Rik

 

[Kotaro24]

I've just finished researching this topic. Here's the links I came up with:

'### SOURCES:

http://www.freeaccess.de/downloaddetails.asp?id=19

'Example in MailDBNeu.mdb
'###

http://www.AllAPI.net

'API Descriptions for wsock32.dll
'###

http://www.granite.ab.ca/access/email.htm

'Tony Toew's Email FAQ + Links!
'###

http://www.vbip.com/

'Winsock Tutorials
'### --

http://www.vbip.com/winsock/winsock_uucode_01.asp

'###

http://www.freesoft.org/CIE/RFC/821/index.htm

- SMTP Basic Protocol
'###

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/

'### (Continued) wss/wss/_cdosys_summary_of_rfc_822.asp - RFC822
'
Particularly useful were the 3 class modules in the MailDBNeu.mdb database.

Incidentally, the security settings on our exchange server don't allow unauthenticated Email to be sent outside our own organization (and I haven't seen a way to authenticate using SMTP protocol), so you may still have problems with this method.