• Home
  • /Archive by category ' Tek Tips '

Archive For: Tek Tips

How to Wrap Text in New Google Sheets

How to Wrap Text in New Google Sheets

One of the first things I noticed (and found annoying) when switching to the “New Google Spreadsheets” was the fact that my cells were spilling into adjacent cells rather than wrapping with-in the existing cell.   Word-wrap is turned off by default in New Google Sheets

It took me a few minutes to figure it out, but once I did,  it is a super easy fix.  If you do not want your cells to word-wrap in Google Sheets, simply highlight all of the cells that you do not want to wrap, and click the “wrap-text” icon.  You can toggle word-wrap off and on by highlighting cells clicking the “wrap text” “word-wrap” icon (see below.)

 

 
Top 3 Reasons IT Professionals should learn HealthCare IT

Top 3 Reasons IT Professionals should learn HealthCare IT

If you currently work in IT or are considering an IT career path, you should consider adding IT and Healthcare training and credentials to your tool belt.  The Project Management Institute (PMI) created the following informative Infographic highlighting some of the following exciting statistics (source).  My top 3 favorites are:

24%     –  Annual HealthCare IT Market Growth
88%     – Increase of job ads requesting EHR experience
$109,000 – Avg Salary of Healthcare IT PMs

 

 
Setup a Ticketing System using Google Groups for Business

Setup a Ticketing System using Google Groups for Business

If your business requires a ticketing system and you are an existing Google Apps for Business or Education customer, you may not know it, but you already have one!  In addition to the email, calendar, contacts, and 30GB storage you get with your $5/user/month, you also get a flexible, robust, and reliable ticketing system.

The video below shows you how Google Groups for Business can be used as a full blown ticketing system:

GoogleGroupsCollaborativeInbox-450-92

 
How To Send Mail from Your Printer or Scanner Using Google Apps

How To Send Mail from Your Printer or Scanner Using Google Apps

Sending mail from a printer, scanner or app

You can set up your on-premises multifunction printer, scanner, fax, or application to send email through Google Apps. The three available options are: SMTP relay service, Gmail SMTP server and Restricted Gmail SMTP server.

  1. SMTP relay service – used to send mail from your organization by authenticating with the IP address(s). You can send messages to anyone inside or outside of your domain.
  2. Gmail SMTP server – requires authentication with your Gmail/Google Apps account and password. Messages can be sent to anyone inside or outside of your domain.
  3. Restricted Gmail SMTP server – does not require authentication, and you will be restricted to send messages to Gmail or Google Apps users only.

If you decide to use an SSL based solution (recommended in most cases) SSL must be enabled from the Google Apps Domain

Enable SSL in Google Apps Domain:

admin.google.com –>  Security –> Basic Settings –> Enable SSL (checked)

Enable SSL in Google Apps Domain

 

The table below will help you decide which one of these options will best meet your needs:

Option Google Apps SMTP relay (recommended) Gmail SMTP server Restricted Gmail SMTP server
FQDN of SMTP Service smtp-relay.gmail.com smtp.gmail.com aspmx.l.google.com
Configuration requirements Port 25, 465, or 587
TLS optional.
One or more static IP addresses are required.
Port 465 (SSL required)
Port 587 (TLS required)
Dynamic IPs allowed
Port 25
TLS not required
Dynamic IPs allowed
Mail can only be sent to Gmail or Google Apps users
Requires authentication IP address provides authentication. Your full Gmail or Google Apps email address required for authentication No.
Bypasses anti-spam No. Suspicious emails may be filtered. No. Suspicious emails may be filtered. No. Suspicious emails may be filtered.
Sending Limits Limits for registered Google Apps users. 
A registered user cannot relay messages to more than 2,000 recipients per day.
For full SMTP relay limits please see Sending limits for the SMTP relay service.
2000 Messages per day. SeeSending limits for more detailed information. Per user receiving limits will apply.

You can use the SMTP relay service in the Google Admin console to relay mail from your device or application. This is possible once you add your network IP range to the SMTP relay service. You will need to configure your device to connect to smtp-relay.gmail.com on ports 25 or 465, 587. For more details about using this setting, see SMTP relay service setting.

Gmail SMTP Server could also be used to relay messages from your device or application. You can connect to Gmail mail servers using SMTP, SSL/TLS. If you connect using SMTP, you can only send mail to Gmail or Google Apps users; if you connect using SSL/TLS, you can send mail to anyone.

If your device or application supports SSL – connect to smtp.gmail.com on port 465.

To connect with SSL, you need to provide a Google username and password for authentication. Ensure that the username you use has cleared the CAPTCHA word verification test that appears when the user first logs in. We also recommend ensuring that the account has a secure password.

If your device or application does not support SSL – connect to aspmx.l.google.com on port 25.

You must configure an SPF record for your domain with the IP address of the device or application to ensure that recipients do not reject mail sent from it. You must also add this IP address to the Email Whitelist box in your Google Admin console. For example, if your sending device sends from 123.45.67.89, add that address to your SPF record without removing the Google Apps mail servers from the record: v=spf1 ip4:123.45.67.89 include:_spf.google.com ~all

v=spf1 ip4:123.45.67.89 include:_spf.google.com ~all

 
How To Disable New Tab History Icons in Google Chrome

How To Disable New Tab History Icons in Google Chrome

If you have recently upgraded to the latest version of Google Chrome, like it or not, thumbnails of your browsing history are now showing up when you launch a new tab.  There are several situations where this configuration may not be ideal….

Luckily you can turn off the Google Chrome browser history thumbnails in new tabs as follows:

Launch Google Chrome and type the following in your browser:

chrome://flags

Scroll down until you find “Enable Instant Extended API” and  DISABLE

Relaunch Chrome with the button on the bottom left of the page

ChromeFixedNewTab

 
Disable LogmeIn new Pop-Up Browser Window

Disable LogmeIn new Pop-Up Browser Window

Every once in a while I accidently click to add the “Plugin” for Logmein.  Basically this just makes things a pain because you can no longer have multiple browsers

Trash the following files to have logmein use Java (which enables you to have logmein sessions in multiple browsers.

 All of the techs at our company run Macbook Pro's to support customers all over Dallas.  It is imperative that we have the ability to run multiple logmein sessions in a single browser using multiple tabs.

At one point we thought we lost this ability and were about to move to a completely different remote support solution because of this “new” Mac logmein plugin.

However, we found that if we removed the plugin and select “Skip Installation” for the Mac plugin everytime we initiate a remote connection, logmein uses a Java client and allows you to  run multiple logmein sessions in a single browser using multiple tabs.  

Every once in a while we accidently click to “Install Mac Plugin” and have to remove it.  Here is how to remove the junk Mac Logmein Plugin and get back to using multiple tabs with logmein.

From your Mac:

Open Finder:

Navigate to

Library->Internet Plugins

DELETE any

Logmein.plugin files


After doing this you will be able to launch logmein without it popping up in it’s own browser window.  You will have to be careful to NOT click “Install Mac Plugin” every time you connect to a remote client or you will have to uninstall it again.

Hope this helps!