Is there a way, using VBA, to search Outlook 2000's Public Folders for everything posted on a particular date (e.g. today) and copy/paste only the subject into Excel?
I'm having trouble trying to figure out how get a list of filenames from a folder in Outlook2000.
In Public Folders, I have a directory containing notepad files and I would like to be able to search for files posted on a specific date and copy only the filenames (subject?) into Excel.
I'm not...
I am trying to figure out how to take a time (i.e. "8:04" for time spent-not the actual time) and amount completed (i.e. 65) and figure out how many were completed per hour.
The time spent comes from the difference between the start and stop times.
My problem is that I cannot figure...
I have two fields - DateReceived and DateCompleted which are in mm/dd/yyyy format.
I'm trying to figure out how to create 3 queries - one that tells me when DateReceived and DateCompleted were within the same day, one that tells me when DateReceived was 1 day before DateCompleted and a third...
I have several checkboxes that I use in my form. When I run a report, the checkboxes are visible yet when I try and cross the info over into Excel, they disappear! The only information that crosses over is anything that is a text or number field. How do I get the checkboxes to show in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.