BlueCapra

Using Technology To Solve Problems and Create Solutions

  • About Alan Reeves
  • Curiosity & Learning
  • Projects

How-To: Use VisualBasic to Print Mailmerge Documents Separately in Microsoft Word

November 21, 2013 by Alan R Leave a Comment

Have you ever received a newsletter with your name and address printed on the back?  If you have ever wondered what it takes to do that for your organization or business, you are in the right place.  With a little bit of VisualBasic programming and the right equipment, you can save a ton of time and effort.

Several months ago, a co-worker was trying to print a company newsletter on a large Toshiba printer that folds, prints, staples, and possibly makes coffee (it is a very nice machine).  His problem was that every time he did a mail merge to get the names and addresses populated on the newsletter back page, the printer would print all of the several hundred newsletters and try to staple and fold the whole group.  The Toshiba is a nice machine but there was no way it could print over 1000 pages, fold and staple them.  The first 2 or 3 would print, get stapled together, and an error would occur.

Through the magic of VisualBasic programming and macros, we were able to get the desired result.  Here is the code it took to print each one separately: [Read more…]

Filed Under: How-To

Personal SEO – Getting to 1st on Google – Week 95

November 18, 2013 by Alan R Leave a Comment

Personal SEO - Getting to 1st on Google - Week 95 - Bing 2nd page results #10 - #14Welcome back to my journey to being 1st on Google.  This is the 95th update for my attempt to rank first for my name, Alan Reeves.  If you missed any of the posts, you can find the first one here, 94th Week update here (last week), and the ones in between on my Project page. Below are the results as of Sunday, 11-17-13 (click here to do your own search for Alan Reeves on Google):

  • #2 – My Pinterest profile (up 2 spots from last week at #4)
  • #15 – My Vizify profile (down 3 spots from last week at #12)
  • #16 – My About page on BlueCapra (up 1 spot from last week at #17)
  • #18 – My Vimeo profile (no change from last week at #18)
  • #21 – My Blogspot page (up 1 spot from last week at #22)

This week I’m on the first page at #2.  Overall, my top 5 results increased 1 place with 5 of the top 5 results occurring in the first 25 places.  As a whole, I showed up 14 times in the top 100 search results. [Read more…]

Filed Under: How-To

Personal SEO – Getting to 1st on Google – Week 94

November 11, 2013 by Alan R Leave a Comment

Personal SEO - Getting to 1st on Google - Week 94Welcome back to my journey to being 1st on Google.  This is the 94th update for my attempt to rank first for my name, Alan Reeves.  If you missed any of the posts, you can find the first one here, 93rd Week update here (last week), and the ones in between on my Project page. Below are the results as of Sunday, 11-10-13 (click here to do your own search for Alan Reeves on Google):

  • #4 – My Pinterest profile (down 1 spot from last week at #3)
  • #12 – My Vizify profile (up 2 spots from last week at #14)
  • #17 – My About page on BlueCapra (up 2 spots from last week at #19)
  • #18 – My Vimeo profile (up 2 spots from last week at #20)
  • #22 – My Blogspot page (up 2 spots from last week at #24)

This week I’m at #4.  Overall, my top 5 results increased 7 places with 5 of the top 5 results occurring in the first 25 places.  As a whole, I showed up 15 times in the top 100 search results. [Read more…]

Filed Under: How-To

Personal SEO – Getting to 1st on Google – Week 93

November 4, 2013 by Alan R Leave a Comment

Personal SEO - The Search for Alan Reeves - 1st on Google - Week 93 - Top 5 Google ResultsWelcome back to my journey to being 1st on Google.  This is the 93rd update for my attempt to rank first for my name, Alan Reeves.  If you missed any of the posts, you can find the first one here, 92nd Week update here (last week), and the ones in between on my Project page. Below are the results as of Sunday, 11-3-13 (click here to do your own search for Alan Reeves on Google):

  • #3 – My Pinterest profile (up 10 spots from last week at #13)
  • #14 – My Vizify profile (no change from last week at #14)
  • #19 – My Vimeo profile (down 3 spots from last week at #16)
  • #20 – My About page on BlueCapra (down 3 spots from last week at #17)
  • #24 – My Blogspot page (up 1 spot from last week at #25)

This week I’m back on the first page at #3.  Overall, my top 5 results increased 5 places with 5 of the top 5 results occurring in the first 25 places.  As a whole, I showed up 13 times in the top 100 search results. [Read more…]

Filed Under: How-To

Personal SEO – Getting to 1st on Google – Week 92

October 28, 2013 by Alan R Leave a Comment

Personal SEO - The Search for Alan Reeves - 1st on Google - Week 92 - Google ResultsWelcome back to my journey to being 1st on Google.  This is the 92nd update for my attempt to rank first for my name, Alan Reeves.  If you missed any of the posts, you can find the first one here, 91st Week update here (last week), and the ones in between on my Project page. Below are the results as of Sunday, 10-27-13 (click here to do your own search for Alan Reeves on Google):

  • #13 – My Vizify profile (no change from last week at #13)
  • #14 – My About page on BlueCapra (up 1 place from last week at #15)
  • #16 – My Vimeo profile (up 1 place from last week at #17)
  • #17 – My Twitter handle, @AlanReeves (up 2 places from last week at #19)
  • #25 – My Pinterest profile (down 2 spots from last week at #23)

This week I’ve slid back to the second page to #13.  Overall, my top 5 results increased 2 places with 5 of the top 5 results occurring in the first 25 places.  As a whole, I showed up 15 times in the top 100 search results. [Read more…]

Filed Under: How-To

  • « Previous Page
  • 1
  • …
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • 30
  • Next Page »

Find what you are looking for

Books I've Read

48 Days to the Work You Love
Being Wrong: Adventures in the Margin of Error
How Doctors Think
The Art of Possibility: Transforming Professional and Personal Life
Dirty Rotten Strategies: How We Trick Ourselves and Others into Solving the Wrong Problems Precisely
Brainstorm: Harnessing the Power of Productive Obsessions
The Creative Habit: Learn It and Use It for Life
A Book of Five Rings: The Classic Guide to Strategy
Wild at Heart: Discovering the Secret of a Man's Soul
Reality Check: The Irreverent Guide to Outsmarting, Outmanaging, and Outmarketing Your Competition
Startup Guide to Guerrilla Marketing: A Simple Battle Plan For Boosting Profits
Vagabonding: An Uncommon Guide to the Art of Long-Term World Travel
Seeking Wisdom: From Darwin To Munger
Multiple Streams of Internet Income: How Ordinary People Make Extraordinary Money Online
Thomas Paine: Enlightenment, Revolution, and the Birth of Modern Nations
The War of Art: Break Through the Blocks & Win Your Inner Creative Battles
The 4-Hour Workweek: Escape 9-5, Live Anywhere, and Join the New Rich
Where Good Ideas Come From: The Natural History of Innovation
Moonwalking with Einstein: The Art and Science of Remembering Everything
Build Your Own Wicked Wordpress Themes


Alan Reeves's favorite books »

Copyright © 2025  ·  BlueCapra.com  ·  Built on the Genesis Framework and Centric child theme   ·  Affiliate Disclosure

Copyright © 2025 · Centric Theme on Genesis Framework · WordPress · Log in