Main Area and Open Discussion > General Software Discussion

Script to sort your Gmail messages by size using Google docs

<< < (5/7) > >>

TaoPhoenix:
Iain you're smarter than this ol' sharp marble, so I dunno if I'll actually get around to doing that : )

IainB:
I can delete them as is, I'd miss the searchability. I wish there was an app for "download all the attachments, print the email text itself to a PDF, throw all that into a folder".
-TaoPhoenix (May 04, 2012, 06:10 PM)
--- End quote ---
What I do:
I view each email shown in the spreadsheet, starting with the biggest.
If I want to keep the attachment:
(a) I save it to Gdocs (now Gdrive) and give it a useful/relevant filename;
(b) I get the link to that file as a Shared file.
(c) I select foward for the email, insert the filename and link in the text at at the top of the email, and untick the attachment box.
(d) Put my address as the "To" name for the email (I'm sending it to myself).
(e) send the email, now less any attachment.
(f) Delete the email with the attachment.

That way, you get to separate the email from the attachment, save them both, and keep them linked.

It's a bit tedious, so I do this in bits, over time. It's surprising what a dent you can make in your "fat" emails this way, and it makes for more orderly storage.
If you use the Gdrive app to sync to your PC (I recommend this), then you can have all the attached files (which are now detached and saved in Gdrive) backed up on your PC. If you want to do that, then select their Gdrive folders in the Gdrive sync app. (I sync all folders - the whole Gdrive - by default.)
The first time the sync runs, it takes a while (all files/folders selected get transferred to your PC), but after that it's not too busy.

Your email will thus eventually be just email with no/few attachments, and you can similarly back the email up using a client email package (e.g., Outlook) on your PC.
____________________________________________
WARNING:

* Gdrive has virtual "folders" (they are really like Gmail labels  - "tags"), and you can place a file in several of these "folders". It's a great way to organise your files into categories. But there's always only one single copy of the file, no matter how many folders you have it in (unless you deliberately create a duplicate of it).
* So, if you shuffle your files around in the folders on Gdrive or tick a file as being in more than one folder, then that will cause the sync app to save a duplicate of the file to each logical folder on your PC. All those duplicates could have the potential to become very confusing (e.g., which is the version you want to update offline?), a waste of disk space, and a bandwidth hog if you shuffle files around a lot whilst organising things.
* So consider turning the sync app off until your shuffling has finished and experiment carefully to discover how offline update affects file updates to Gdrive after online sync.

TaoPhoenix:
You're awesome, but we'll see.

Heh I have 87,000 messages in my *sent* box. Sky knows how many total! : )

IainB:
Heh I have 87,000 messages in my *sent* box. Sky knows how many total! : )
-TaoPhoenix (May 04, 2012, 06:54 PM)
--- End quote ---
That's a lot.    :o
In my case, as soon as Gdocs enabled the file link capability in Gdocs some years back, I started using it to reduce my Inbox bloat - as detailed in my above post.
Every file that has an attachment that I receive gets this same archival treatment.
I press "forward", insert my email address, untick the attachment box and have an AHK script that types into the top of the email:
   For archives:
   File(s):

--- End quote ---
- and I just add the filename and link in Gdrive.
Then I press send, and delete the original email.
Fortunately I don't get too many such emails.
I would automate it further if I could. (Any ideas?)

As for sending, I rarely send an actual file attachment, just an email with a link to the file saved in Gdocs.
I think - but am not sure - that Gdrive could help to make this easier to do. Still experimenting with it though.

By the way, I have edited my previous post above and added a WARNING regarding the difference between Gdrive virtual "folders" and the logical folders that Gdrive sync turns those folders into on your PC. Potential duplication/confusion. (I'm sure I'm not the only person to have mentioned this to Google in their feedback form.)

TaoPhoenix:
I think I have over 160,000 in my total box. I inherited a colleague's email box as part of the total. Wheeee!   ;D :D

Edit: (Iain says:) " Fortunately I don't get too many such emails."

Heh 40% of my emails have attachments! : )
"If it doesn't have an attachment one of you two isn't working hard enough" - Me just now   :P

Navigation

[0] Message Index

[#] Next page

[*] Previous page