V22.0004 Computers in Principle and Practice

Assignment 8 (Excel #2)

Mailmerge || Macros || Toolbars || What to Hand In

Mailmerge

Your website is now all set up and you want to let your friends and relatives know that it is there!

1)Make a "Contacts List," which is a database of a few friends and people that you know.

FirstName LastName Email Address1 Address2 City State Zip Phone Comment

 

Harry Potter hpotter@hogwarts.edu Number Four Privet Drive Little Whinging Surrey 110181 998-1101 Student

Macros


2) Next, use the Mail Merge tool to make a form letter that you could send to a number of friends.


3) Then Merge the document to create the merged form letter.


4) Send the following three files as email attachments to grader email account:
  1. The Original Excel Data base which includes the macros and the toolbar
  2. The Word Form Letter
  3. The Word Merged Letters

Here are the email addresses for assignment submission for the various sections:


Working with Toolbars in Excel

Assign the macros to a new toolbar along with a button that has a link to your website. Update 12/11/06: Your instructor will advise you whether this additional button is required.

On a PC:

On a Mac:

3) Attach the toolbar to the worksheet

In the CUSTOMIZE menu for Toolbars, select your toolbar, and then select ATTACH. Use the COPY button so that the name of your toolbar appears in the right-hand column. Remember to save your workbook again after attaching the toolbar.