Word icon

Mail Merge in Word+Excel using VBA

mail merge

Over at Automated Word Mail Merge I have a sample workbook for creating a mail merge in Excel using VBA, but I've felt the example wasn't the best. So I produced another, and here it is.

Continue Reading: Mail Merge in Word+Excel using VBA »

Excel iconWord icon

Create Hyperlinks for Email

hyperlink

Often I'll need to email a hyperlink to an Excel workbook to a group of people. I want them to be able to click on the link to open the file. There's the manual way and the VBA way. Here I'll show you both.

Continue Reading: Create Hyperlinks for Email »

Word icon

Twitter From Word too!

Someone took out the Twitter stick and hit Microsoft Word as well. Enjoy this version of the MS Office Twitter client at word + twitter. The page is in Hungarian but if you use a translation service, you can make it through well enough. Just download the Word doc in the post and take it out of design mode.

http://legalalien.org/blog/index.php/2009/02/15/word-twitter/

Update 7/16/2009: The page seems to have disappeared. But it's easy to recreate the Twitter code in MS Word. If anyone wants it, let me know.

Automation iconWord icon

Simple Word macro/button to print out a form

Happy April Fool's Day!

Here is a simple macro in MS Word that you can use to print out a document to the default printer.

Continue Reading: Simple Word macro/button to print out a form »

Automation iconWord icon

Automated Word Mail Merge from Excel

Greetings,

I just updated the site with some code for automating the mail merge to Word process. Check it out here:

Excel Mail Merge

Enjoy,
JP

Site last updated: February 9, 2012