amy-biz-tip-header1

December 12, 2013

Volume 102

Subscribe to Amy’s Biz Tips e-newsletter.

Archive of Amy’s Biz Tips.

These Tips Are Courtesy of AAPK

Excel - Recent Document Options

|

Using Graphics Safely
 in Emails

|

You Have
To Laugh

 

Excel - Recent Document Options

When opening up an Excel file you will see a list of recent files. Did you know that you can change the number of recent documents that are listed or “pin” a file to remain on the list?

This feature is turned on by default, but it can be turned off as well by setting the number of recent documents to 0. The maximum number of documents listed is 50.

To change the number of documents: Click on the Microsoft Office Button (in 2007 and above) and choose Excel Options at the bottom of the window. Choose Advanced from the left navigation and scroll down until you see Display, there you can enter or use the arrows to increase or decrease the documents shown. The maximum is 50.

To keep or pin a file in the Recent Documents list: Click the Microsoft Office Button, and then click Pin (sideways push pin) this document to the Recent Documents list. When a document is pinned to the Recent Documents list, the pin button looks like a push pin viewed from the top (see below).

Excel-Pin-Recent-Docs-121213

Use this list when you can’t remember the name of a recent file or you just don’t want to trek through your folders to find a file you work on often. 

If you need help with an MS Office project contact me at info@aapk.com. I have a lot of experience with PowerPoint, Word, Excel and other MS Office products.

 

Using Graphics Safely in Emails

You get these emails many times daily - ones that contain graphics or a background to make the message stronger and now you want to create one. Did you know that there are various ways to add graphics to an email and each method can cause different issues?

First rule is that you must have your email format set to HTML – this is generally the default setting for most email programs.

Below is a chart that outlines the various ways to use graphics and their potential downfalls.

Type

Adding

Resolution

Easy to Save for Receiver

Resulting Email File Size

Viewed as Spam*

Embed

Add to graphic using "Insert"

Lower quality of resolution

No

Low

Yes - most likely

Attach

Insert/Attach (generally shown with a paperclip)

Maintains original resolution

Yes

A larger file will take longer to load in a recipient's email client

Yes - sometimes

In-line
(using a graphic from the web) 

Reference a URL**

Maintains original resolution

Yes

Low

Rarely

* Each email server has different rules about what they deem as potential spam - AOL and Gmail tend to have the toughest rules.
** In order to use this option, you must have a web server to host the file on and then refer to the file in the HTML as a URL - such as www.aapk.com/amy-biz-tip-header1

So, next time you want to add a graphic to an email you now have the necessary information to make a decision about the best way to do it.

If you need help creating email marketing programs, please contact me at info@aapk.com

 

You Have To Laugh

Funny Video: Kangaroo Boxes Toy Hippo  ...  Click here

 

Amy’s Biz Tips are brought
to you by AAPK

who can help
you with:

 

Amy’s Biz Tips are brought
to you by AAPK

who can help
you with:

 

Unsubscribe from Amy’s Biz Tips e-newsletter.

  Home   Web Design   Social Media   Print Media   Consulting   About AAPK

Contact us - 203-305-3124 or at  info@aapk.com

AAPK - 45 Shadyside Lane, Milford, CT 06460

AAPK © 2015