Sunday, October 4, 2015

How can I Reduce the Amount of Junk Mail I Receive?

OptOutPreScreen is website helps you take yourself off lists for pre-approved credit, auto loans, and other offers which use your credit score to determine the offer. The site asks for your social security numbers, so before using it, I googled "is optoutprescreen legit" and found several credible looking sites confirming its validity. Turns out you don't have to to enter your SSN or telephone number even thought they mark them red like required fields!

DMAChoice is a web site Direct Marketing Association, the principal trade association of the direct mail industry. They don't want to waste their member's money so they provide the ability to remove yourself from all mailing lists used by direct mail companies or to opt out one by one, using the codes printed on the pieces direct mail.

Credits

http://www.moneycrashers.com/how-to-opt-out-and-get-less-junk-mail/

Friday, October 2, 2015

How do I Add a Password to a Zip File on a Mac?

Get ready for a trip back into the 60s...

Open Terminal (not kidding).
Use cd to go to the folder containing the file.
Type command below replacing archive.zip with the name of the compressed file you wish to create and file.txt with the name of the file you are compressing.

zip -e archive.zip file.txt

Enter password and confirm.
Exit Terminal and you should find archive.zip in the appropriate folder.

To compress multiple files in one archive.
Create folder.
Copy all files to folder.
Open Terminal and type command below.

zip -er archive.zip /path/file.txt






Monday, August 24, 2015

How do I suppress spreadsheet cell overflow in Open Office

Environment
Open Office for Mac v4.1.1
.ods or .xls file extension

Select entire sheet by tapping on top left cell or clicking Command-A (Mac OS)
Right click any cell and select "Format Cells..."
Select Alignment > Wrap Text Automatically

To suppress overflow without using word wrap, select entire sheet, right click on any row number and set Row Height to something like 0.18", then select Format Cells again and set Alignment > Vertical to Top.