Pages: 1
RSS
export mails to excel, make excel list from date and subject
 
i need to make excel list which should contain only date and subject from sent mails
sent mail list is too large to do it manualy, so i need quick way to make some kind of list

is it posible to do it with "the bat"
either directly, or using some crossing program

justo to mention that this is URGENT, URGENT!!!!!!
many thanks for any information
Edited: mndra - 10 May 2011 20:24:22
 
Create a manual outgoing filter
Never mind the condition
As action you set export to file (plain text)
file name something like c:\temp\exportlist.txt
option: append to existing file
use the template:
%Date, %Subj
In case you need the subject with prefixes (like Re: and Fwd:) make the template:
%Date, %FullSubj
Open the txt file with Excel and tell Excel that it's a CSV file with the comma as separator
Good luck
__________________________________
I'm just a user of The Bat! I don't work for Ritlabs.
 
is there some command for exporting to file or....
where to click, what to write....
shall i mark all the messages, or one by one...
how i am making filter...

please, sorry for these questions, but this is totaly unknown teritory for me, and it would be wery healthy for my bare life :) to solve this problem
 
There is an export command, but that doesn't what you want as it exports complete messages.

You create a filter via the menu:
Account -> Sorting Office/Filters -> select 'outgoing mail' -> File -> New filter
Now you create a filter with the actions I proposed
Afterwards at the 'options' tab you select 'this filter is active' (should be on by default) and 'use this filter for manual refiltering only'
Now you press the OK button.

Next you select your 'sent mail' folder and via the menu you pick:
Folder -> Re-Filter
Now a pop-up appears and you enable 'outgoing mail' and 'manual filters only',  nothing else. Press OK and the re-filtering starts.

BTW The description of the filter says that it's c:\temp\exportlist.txt, that means that you've got to have a directory C:\temp in case you haven't got that now (and that's not unlikely) you need to create one before you run the filter.
__________________________________
I'm just a user of The Bat! I don't work for Ritlabs.
 
uhm, i did everything as written
i made c:temp folder and there was not exportlist file :(

"Now you create a filter with the actions I proposed"
This is where I think I made some mistake
Pages: 1