+ Reply to Thread
Results 1 to 3 of 3

creating an address book entries based on sent or inbox email box

  1. #1
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    creating an address book entries based on sent or inbox email box

    We copied over our email to office 365 however in doing so we lost our contact lists.

    I want to recreate these.
    Conceptually I was imagining going over the inbox (or sent box) and creating a list of contacts (names and emails) and then populating the address book.

    Can anyone direct me to some code that can do this or get me close?

    as you can imagine it is a bit annoying for the users (and a bit of a screw up) - so I am not concerned if this ends up taking a fair bit of time.
    Last edited by scottiex; 03-20-2024 at 03:49 PM.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: creating an address book entries based on sent or inbox email box

    Before anyone runs off and does to much work I tried chat GPT and it gave me some code I could work with

    the fixed up version is below.

    I think this is ok although feel free to comment

    Please Login or Register  to view this content.

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: creating an address book entries based on sent or inbox email box

    Untested here :

    https://stackoverflow.com/questions/...ed-in-a-column

    Another method :

    Please Login or Register  to view this content.
    https://www.slipstick.com/developer/...from-messages/
    Last edited by Logit; 03-20-2024 at 06:11 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating address book with other data in excel..
    By idjundje in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2016, 02:18 PM
  2. Using macro to find email address in address book of Outlook
    By danfullwood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2014, 06:48 AM
  3. Replies: 0
    Last Post: 05-13-2014, 01:25 AM
  4. Creating an Address Book via Macros / VBA
    By Shawn1888 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 08:30 PM
  5. Creating Address book for mail merge
    By Feline in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-20-2007, 06:39 AM
  6. [SOLVED] Transfer Email addresses from spreadsheet to email address book
    By Beana in forum Excel General
    Replies: 2
    Last Post: 05-30-2006, 01:10 PM
  7. Replies: 0
    Last Post: 12-07-2005, 01:40 PM

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