Email sender

[aspfun]

I want to code to send an email from Access app in which the email sender not my email address but something like "DBAdmin@xxx.com".
I search in Google but all I found is using my outlook object and display sender as my email address.
Is there a way to send an email without display my real email address as sender?

 

[krowe]

Hi

If your outlook has the mail account DBAdmin@xxx.com set up, could you not put in a line like:

Dim olApp As Outlook.Application
    Dim objMail As Outlook.MailItem
    Dim Email As String
    Set olApp = Outlook.Application
    'Create e-mail item
    Set objMail = olApp.CreateItem(olMailItem)
    Email = Replace(Me!Email, "#", "")
    With objMail
       'Set body format to HTML
       .BodyFormat = olFormatHTML
       .To = Email
      [COLOR=red] .From = [/COLOR][EMAIL="DBAdmin@xxx.com"][COLOR=red]DBAdmin@xxx.com[/COLOR][/EMAIL]
       .Display
    End With

Just a thought, somebody may correct me though if i'm wrong, i've not tested it as only have hte one user set up on my email at work.

 

[krowe]

Just researched my reply and it seems that would not work, have a look at this though:

http://www.rondebruin.nl/mail/account.htm

if you are using outlook 2007 there is this command:

.SendUsingAccount = OutApp.Session.Accounts.Item(1)