What can I say? It's summer and I'm
feeling lazy so I haven't done as much to my site as usual. I'm sure
it's just a temporary setback and I will get moving again in the Fall.
This heat wave has just been KILLING me!!
But, I did add a few things you
might want to check out.
A couple more articles I wrote for
TechTrax are reprinted here.
And, Vic Ferri's added a whole bunch of new VB Freebies to our Side by
Side page. Along with his free Temp Converter, we now also offer the
following for free download:
- Port 139 Blocker
- Empty Recycle Bin
- Show/Hide Files
Yep, they are all free to download here:
http://personal-computer-tutor.com/sxs/sidebyside.htm
And, to help keep these freebies coming,
please go here and check
out his great sponsors...some of the best prices I've ever seen for quality
printer cartridges and supplies! Remember to
support "the little guy"!
And, as usual, more links have been added to my favorite links here:
http://personal-computer-tutor.com/internet.htm
And, if you missed any of the other new stuff I added to the site in the
past few months, you can always go here and see it all:
http://personal-computer-tutor.com/new.htm
Thanks for your patronage of my site and ezine. Drop me a line any time and let me
know of any additions you can think of. I may be busy, but I'm always
open to suggestions.
Linda
linda@personal-computer-tutor.com
<<<back to contents
Subscribers' Exclusive Tip
Links to Outlook Contacts in Excel.
Let's say you have a worksheet that includes a lot of customer
names who are also in your Outlook Contacts. You can easily make their names
clickable links that will open up their Outlook Contact Form.
Here's how:
In this example I used my buddy Hal Cardona's info. In cell A1, I
entered his name, "Hal Cardona", then I went to the Insert Menu and chose
Hyperlink (or you can click on the Hyperlink button on Excel's Standard
Toolbar or simply hit ctrl+k). When this box comes up, I see Hal
Cardona in the box that says "Text to display" and all I do is type the
following in the box that says "Address:"
Outlook:Contacts/~Hal Cardona
Now, when I click on Hal's Name, it opens his Contact Form in Outlook!
Linda Johnson is a
college instructor of all of the Microsoft Office Programs, as well
as Adobe PhotoShop and Windows. She also teaches online distance
learning classes in Excel, Outlook, PowerPoint, Publisher, and Word at
Eclectic Academy. She has worked helpdesk and teaches
and lectures at many local businesses and tech schools in her area. Support this
newsletter by checking out Linda's eBooks, MS Word MAGIC!, Book
I: Fonts, Fun & Formats and Book
II: Table Wizardry,
How
To Get Started As a Software Trainer, and
her newest series of MSOffice
eBook Tutorials and CD
<<<back to contents