Recent content by aliT

  1. A

    How to log into a specific outlook user account via vba in access

    Aha, sorry, but as far as you know is it possible to do it without adding an account, by using the logon method as above ie oNS.Logon sUserName, sPwd, False, True
  2. A

    How to log into a specific outlook user account via vba in access

    I have a problem in that the logon method doesnt seem to work. It still sends from my own profile. And when i put a random password it doesnt give an error and continues to send from my own account. Any ideas? Dim sPwd As String, sUserName As String Dim olApp As Outlook.Application Dim oNS As...
  3. A

    How to log into a specific outlook user account via vba in access

    Thanks very much for that. you are a star
  4. A

    How to log into a specific outlook user account via vba in access

    How do i manually add the accounts. Do i need to enter the other users passwords?
  5. A

    How to log into a specific outlook user account via vba in access

    Yes please, how can i add the accounts and how can i use them please thankyou
  6. A

    How to log into a specific outlook user account via vba in access

    Anyone know how to log into a specific outlook user account and then send an email from that account please? I need the code At the moment i can only get it to send emails from the account my outlook logs into by default ie my own profile's account. thanks ali
  7. A

    How to change the From email for an outlook email via vba

    Hi I use the Outlook.MailItem.SentOnBehalfOfName field to send from a different person in my vba, the problem is that this ends up in the junk box. Anyone know of a way changing the From email without it going to junk? thanks ali
  8. A

    Send email from access vba using outlook

    Now that i used the SentOnBehalfOfName field to send from a different person , the problem is that this ends up in the junk box. Anyone know of a way changing the From email without it going to junk?
  9. A

    Send email from access vba using outlook

    With outlook 2010 you need to use the MailItem.SentOnBehalfOfName field to set the sender field to a certain email address. Took me ages to find out.
Top Bottom