Posts by Lena Shore
Return Receipt for Mail.app on Macintosh
Question Is there a way to know that someone has opened your email using Mail on my Macintosh? Answer There are a couple of ways. Sign up for a service First, you can sign up for a service that will monitor your mail. I don’t have any specific recommendations, but you can google “return receipt…
Read MoreMultiple Employees Working on a Single Excel File
Question What is the best way to allow multiple employees to access and alter a single Excel workbook? We have tried Dropbox in the past, but have had problems. Answer I would use Google Docs. You can work on shared Word documents and Excel documents online and it’s free! You start by uploading or creating…
Read MoreWhere can I find an online design course?
Question I have a quick question that I hope you can answer, or at least provide me some direction. I would like to take an online course that could teach me some design basics. Not necessarily software, but just tips like how to balance elements on a page, what size fonts to use in relation…
Read MorePaper Lesson
Over the weekend I was cleaning out my office and found this great little cheat sheet I created years ago for understanding paper types as explained by one of my printing mentors, Jon Anderson. Paper weight The weight of a paper is determined by how much a ream (500 sheets) weighs in the basis size.…
Read MoreExcel: How to easily join text columns with a formula!
Say someone sends you an Excel document and you while they gave you lots of columns of information, you really need some of those columns joined. Let’s say you also don’t want to merge them permanently. You can do it with an easy formula! This is also called “concatenation” and can be found in the…
Read MoreMac Mail: How to add addresses from Mail to your Address Book in Bulk
Question I have “mail” and “contacts” on my mac. I know there are email addresses that my Mail program recognizes and will auto populate when I begin typing them that are not in my contacts. I desire to get those addresses in my contacts file or download them in some way so I can add…
Read MoreWhat is this anonymous Twitter database on my iPad?
Question On my iPad, under Safari/settings/databases, there was an entry from mobile.twitter.com with the name anonymous. I don’t Twitter, never have, and don’t understand how that entry could have gotten there given the descriptions and my understanding of how the databases are supposed to work. In short, how does a person that doesn’t use Twitter or…
Read MoreIs Streaming Netflix with Your Apple TV 2 Leaving You Hanging?
We love Netflix. We love being able to stream it over our iPad, iPhone, and Apple T.V. 2. However, as of late we keep running into programs and movies just hanging every few minutes on the Apple TV. This is not the joyful experience I am accustomed to. After doing some digging, we found some…
Read MoreEditing a Field in Excel: Mac vs Windows
Question I am working in Excel on my MacBook and editing my Christmas card list. On a PC, I could hit the F2 button to immediately be able to edit the field I was in. Is there a shortcut on a Mac for that? Answer CONTROL+U is the new F2 when you’re using Excel with a…
Read MorePaypal, Square, and 1099s
Question Do you have any idea how Paypal and Square up deal with 1099 reporting for the IRS? Answer Paypal Starting in 2011, all US payment providers including PayPal will be required by the Internal Revenue Service (IRS) to report sales information to the IRS about certain customers who receive payments for the sale of goods or services through…
Read MoreThe difference between absolute and relative paths
Question We are working on a small website page that uses iframes. Part of our instructions are saying we need to use absolute paths instead of relative paths. What is the difference? Answer When using image in web pages your images don’t live inside the source code, they live as a file (jpg, gif, png,…
Read MoreDummy's Guide to Formatting Images in the Shopp Plugin
Shopp (shopplugin.net) is a great little plugin for adding a shopping cart to your WordPress site.The support is excellent and everyone at Shopp has been nothing but overly helpful. That being said, figuring out how to size your images can be a little confusing. Pouring over the community forum is helpful, but I think the…
Read More