+ Reply to Thread
Results 1 to 3 of 3

monitoring email replies

  1. #1
    Registered User
    Join Date
    05-13-2008
    Location
    Liverpool
    MS-Off Ver
    2019 pro
    Posts
    17

    monitoring email replies

    Hi all,

    Many thanks fro your help on previous issues, however I have another.

    I have emailed 1392 governement depts asking for some foi reqeusted data. I got the databases online and about 80 - 90 of the emails have now been acknowledged with the remainder having incorrect or out of date email addresses so all is good as thats well enough do do the work.

    So, I'm having trouble trying to export the content of the emails in order to cross match them with the sent to and recd from email addresses. Each (most of) acknowledgements have a unique foi request number in their subject line. Once all the emails are back I thought that sort the list be request number would be the easiest way to monitor who has acknowledged, then replied and obviously the data can go into the respective columns for analysis

    I've tried exporting the list as csv, exporting as text and grabbing that data through a query, saving the emails as a list but nothing is getting me exactly what I want with either not enough data or far far too much which is then unable to fit on one sheet (I think thats down to it including the body of the text but I maybe wrong)

    So ideally what I want exporting from outlook is the sender and the subject line which will enable me to use the same sheet for when the data starts to arrive

    I've attached a small selection of my contact list and also a brief oultline of what I need together with the results from outlook which I dont think is complex at all I just cant get the correct results, although I've had everything but.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-13-2008
    Location
    Liverpool
    MS-Off Ver
    2019 pro
    Posts
    17

    Re: monitoring email replies

    Hi all,

    Apologies for not stating that I managed to sort this myself, I had marked it solved with no answers.

    Many Thanks

    Mark

  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
    6,170

    Re: monitoring email replies

    .
    FYI

    Someone else may be seeking a solution to the same issue.

    Can you post your solution for others ?

+ 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. Help making macros for email replies in Outlook
    By ruslruslrusl in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2014, 12:27 PM
  2. [SOLVED] Zero replies
    By martindwilson in forum Suggestions for Improvement
    Replies: 3
    Last Post: 03-30-2013, 08:12 AM
  3. wow never seen so many replies lol
    By martindwilson in forum The Water Cooler
    Replies: 4
    Last Post: 12-06-2012, 12:41 PM
  4. canned replies
    By martindwilson in forum The Water Cooler
    Replies: 6
    Last Post: 11-08-2012, 02:05 PM
  5. Holidays - Best OUT OF OFFICE email auto-replies
    By oldchippy in forum The Water Cooler
    Replies: 0
    Last Post: 06-22-2009, 04:04 AM

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