+ Reply to Thread
Results 1 to 3 of 3

Outlook email tracking (with a lot of help from Excel)

  1. #1
    Registered User
    Join Date
    Saint Louis, Missouri USA
    MS-Off Ver

    Outlook email tracking (with a lot of help from Excel)

    I'm in sales, so getting customers to reply to emails can be an issue. Out of frustration, I worked up VBA in both Outlook at Excel to keep track of emails with no replies, and to focus on them when they do get replies. Excel is used as a database of the emails and their status (I might have been able to do this entirely in Outlook, with collections or the dictionary (right?) but I'm not that strong, and I use customized spreadsheets for work, and I am doing some integration with this and those spreadsheets, e.g. when a tracked email arrives, I can click from there into another spreadsheet and see this customer's projects/quotes pre-sorted and filtered.... so relying on Excel for the grunt work was easier for me).

    That's maybe more info than you need. I wanted to see if anyone would like to see this and/or collaborate on improving it. I have a couple minor issues that I think are related to the connection between Excel and Outlook. I think I need to convert from late- to early-binding, for one thing. It is working; it does show me who hasn't replied, and it does identify replies to the tracked emails. But I think it could be a little faster and without errors (it does throw an error every so often, that is related to the Outlook-workbook connection).

    The spreadsheet is doing this behind the scenes but does act as a side-bar spreadsheet, to allow me to focus on a particular customer. For a selected email, it displays their name, company name, their photo from Outlook (that was fun!) and buttons to quickly pull up the contact card, their Linkedin and Facebook pages, as well as texting my phone with their phone numbers (this latter part just makes it easier for me to call them, as I use my cell phone for work calls).

    I am assuming many people would be interested in this (making sure you get replies to your emails), but before I throw up all the code I wanted to check for interest.
    Last edited by evanzo; 10-10-2018 at 11:34 AM.

  2. #2
    Registered User
    Join Date
    Saint Louis, Missouri USA
    MS-Off Ver

    Re: Outlook email tracking (with a lot of help from Excel)

    I did get this working, but it's pretty involved and interwoven with some other Outlook/Excel integration. If you want to learn more, send me a private message and i can explain it and I can send the code (it will just take some time to sort out the procedures specific to this -- I've got 2400 lines just on the Outlook side, but maybe only a 3rd of that is for the email reply tracking).

  3. #3
    Registered User
    Join Date
    Singapore, Singapore
    MS-Off Ver

    Re: Outlook email tracking (with a lot of help from Excel)

    Hi evanzo,
    I am looking to track if there are replies to emails I send (which I will move to a subfolder). If the recipient has not given me a reply, I would also like to send them a reminder email after a few days. Your VBA seems like it would do the trick, would you be able to share the code with me?

+ 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. Replies: 0
    Last Post: 05-28-2018, 09:53 AM
  2. vba pull data from outlook body of email through email or subject of mail into excel
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 04:37 AM
  3. export outlook 2007 email into excel with subject and body of email
    By akulka58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 02:37 PM
  4. How to parse data in Outlook email using HTML version of email back to excel
    By bnasty in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-31-2012, 02:54 PM
  5. Replies: 2
    Last Post: 08-01-2012, 02:47 PM
  6. [SOLVED] Excel email: Outlook not recognizing email ID
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-16-2012, 10:03 AM
  7. Email using Excel VBA and Keeping Outlook Signature on the Email
    By Shama in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2009, 07:39 PM

Tags for this Thread


Posting Permissions

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06032 seconds
  • Memory Usage 8,933KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (3)postbit_legacy
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1