Welcome back to my journey to being 1st on Google.  This is the 97th 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, 96th Week update here (last week), and the ones in between on my Project page. Below are the results as of Sunday, 12-01-13 (click here to do your own search for Alan Reeves on Google):

• #2 - My Pinterest profile (no change from last week at #2)
• #19 - My Vizify profile (down 3 spot from last week at #16)
• #20 - My About page on BlueCapra (down 3 spots from last week at #17)
• #21 - My Vimeo profile (down 3 spots from last week at #19)
• #26 - My Blogspot page (down 3 spots from last week at #23)

This week I’m back on the front page at #2.  Overall, my top 5 results decreased 12 place with 4 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. Continue Reading…

Welcome back to my journey to being 1st on Google.  This is the 96th 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, 95th Week update here (last week), and the ones in between on my Project page. Below are the results as of Sunday, 11-24-13 (click here to do your own search for Alan Reeves on Google):

• #2 - My Pinterest profile (no change from last week at #2)
• #16 - My Vizify profile (down 1 spot from last week at #15)
• #17 - My Vimeo profile (down 1 spot from last week at #16)
• #19 - My About page on BlueCapra (up 1 spot from last week at #18)
• #23 - My Blogspot page (down 2 spots from last week at #21)

This week I’m on the front page at #2.  Overall, my top 5 results decreased 3 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. Continue Reading…

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:

You can also see this code on GitHub.  Here is a rundown of the function:

• Lines 6-8 declare the variables
• Line 10 sets up the variable to control the loop
• Line 11 makes sure the mail merge starts at the beginning
• Lines 13-30 is the loop that steps through the mail merge records
• Lines 15-17 sets up the file name if you are going to save the files (not necessary if you are only going to print)
• Line 20 saves the files if needed
• Line 26 prints the document
• and Line 28 moves to the next mail merge record

In your situation, you may need to adjust a few lines of code but if your mail merge is setup right, it should work.

If you have a chance to use this macro, leave me a comment and let me know how it works for you.

Welcome 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. Continue Reading…

Welcome 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. Continue Reading…