Mail Merge Macros

Now that we’ve constructed the letter for Task 2 of Unit 2, we’ll practice creating several macros today. Using the exemplar material, we’ll create macros to insert a date, an address, a header image and a signature. A quick start guide as to how to create a macro in Word 2007 is available from the University of Wisconsin, and for an explanation of the VBA coding, Suite101.com is a sound start. I’ve created a short document with code to cover the practice macros we’ll be doing today, and there’s a link to a website which has many other VBA code examples.

Next week we’ll start by creating a customised button to run the “Signature” macro and then create a template of the mail merge letter. Thereafter, everything we’ve done must be written up with screen shots and annotation. Remember NOT to crop your screen shots, as your letter must be seen in the background.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: