Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-14-2021, 05:29 PM
trevorc trevorc is offline Not using the default email address Windows 7 32bit Not using the default email address Office 2013
Competent Performer
Not using the default email address
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default Not using the default email address

Hi All,


I have a strange problem with my email, i use several email accounts and have changed the default one to match my office login details, When i run the code below in uses the wrong email address even though that is not the default.


Code:
        Dim MailOutLook
        Dim olmailItem
        Dim AppOutLook
        Set AppOutLook = CreateObject("Outlook.Application")
        Set MailOutLook = AppOutLook.CreateItem(olmailItem)
        With MailOutLook
            .To = Intersect(acrow, tblColumns("Email Address").Range)
            .Subject = " "
            .Body = "Hi " 
            .Display
        End With
        Exit Sub
    Else
    End If
Reply With Quote
  #2  
Old 12-14-2021, 05:48 PM
trevorc trevorc is offline Not using the default email address Windows 7 32bit Not using the default email address Office 2013
Competent Performer
Not using the default email address
 
Join Date: Jan 2017
Posts: 174
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

All good now, Outlook is using the Data file default for some reason and not the default email address, i changed this and it uses the correct email now.
So for all you ppl out there using sendonbehalfof you don't need to for this case.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Email Address of Previous Email when Replying or Forwarding bondingfortoday Outlook 0 03-05-2016 04:29 PM
Add link to email address that hides the actual address or makes it inaccessible to online bots richiebabes Word 1 09-03-2014 03:22 PM
Macro to send from non-default email address k.n. Mail Merge 5 12-03-2013 03:22 AM
Setting default "from" email address Jammmers Outlook 0 02-23-2012 12:14 PM
Default Home Address over Business Address DunnDeal Outlook 1 12-03-2010 04:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft