I am going to create a macro that will allow Mr Gascoigne's company, (Shoes 'n all) to insert a different response into a template letter, so that the letter will contain the necessary information appropriate for the use.

Authors Avatar

Sam Flower        Macro’s and Toolbars        GNVQ IT

Macro/ Toolbar

I am going to create a macro that will allow Mr Gascoigne’s company, (Shoes ‘n all) to insert a different response into a template letter, so that the letter will contain the necessary information appropriate for the use.

        I am going to create 4 different Macros. They will input a short paragraph that will tell the reader about their credit bill to the company.

The 4 Macro’s will be:

  1. To open the Master Letter
  2. Telling the reader that their credit bill is up to date and that they hope that the customer will continue using the company to buy their shoes.
  3. Telling the customer that their credit bill is slightly behind and that the require the credit bill as soon as possible
  4. Telling the customer that they haven’t paid their bill for quite a while and that their credit account has been closed.
  5. A slogan that will appear in the footer.
Join now!

I first created a simple letter and put in ‘<’ where information will be inserted.  (See first of documents)

On the same document but on a different page I created the responses that will eventually be the different macros. (See second of documents)

I then saved the document as a ‘.dot’ file, as this then becomes the master copy.

Once they were created I had to start recording a macro.

I went to, file-> new and opened a blank document.

New was the time to start recording.

I wanted to record a macro that would ...

This is a preview of the whole essay