+ Reply to Thread
Results 1 to 3 of 3

using an outlook procedure to return senders address, not working as expected

  1. #1
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,293

    using an outlook procedure to return senders address, not working as expected

    so i have the following code that is working for the most part:

    Please Login or Register  to view this content.
    the problem is that these two lines (which return the normalized username) don't show the full address (ie name@company.com), it just returns a first and last name. how can i rewrite this so that it returns the full email address?

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,922

    Re: using an outlook procedure to return senders address, not working as expected

    Have you tried Msg.SenderEmailAddress? You use it earlier in the same code.
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Valued Forum Contributor dmcgov's Avatar
    Join Date
    11-11-2015
    Location
    Florida, USA
    MS-Off Ver
    Office 365 Business
    Posts
    1,293

    Re: using an outlook procedure to return senders address, not working as expected

    yes, that didn't work. i wrote this function which returns the senders full email address:

    Please Login or Register  to view this content.
    then i used that in my code above. all is working now as expected

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1