• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28

Wjec alevel ict Creating a mailmerge

Extracts from this document...

Introduction

AUTOMATED DOCUMENTS (Mail Merge) DOCUMENT DESIGN What is the Purpose of the mail merge and who is the intended user This letter was designed with the intention to invite clients of Warley painters and Builders to the Warley Washout event on the 20th November 2008 that is being held at the NEC Birmingham called. As the letter is going to be used to invite company directors and executives to try and entice them into carrying out decorating and building work. To do this the mail merge not only contains a letter but also a table of pre-calculated facts and figures that are imported into the table. The mail-merged letter must therefore be professional and in order to do this it will follow the format of a business-letter with the name and address of the contacts all on the left hand side. Ethos Warley Painters and Builders are trying to portray a professional image, and therefore I had tried to design a commercial appearance to it. It must also show the amount of money that people can save if has any hope of making company directors and executives to try and entice them into carrying out decorating and building work in the new product. To help convey the professional image of Warley Painters and Builders I have ensured that I have inserted the company logo, and a self designed watermark into it. ...read more.

Middle

This formula adds up all of the values above. This is the 10 amounts that will be brought in from the mail merge Testing of the Subtotal before VAT The formula used in this mail merged example was to add up the column of values below. Adding up the values it should give an example of 33,950 �8000 �6750 �4650 �750 �6800 �7000 VAT Calculation This field calculates the VAT based upon the amount of the total from the previous field. This is calculated by using a product calculation. To do this I inserted a field and placed in the formula {=product(b15,17.5%)}. This screenshot shows the formula after it has been inserted This screenshot shows a calculation of formula for VAT as you can see the value is �5941.250. To test the calculation I used the calculator accessory and did the calculation based upon the above amount this matched the calculation that appeared in the table. Amount after VAT calculation The amount after VAT calculation is a sum to add up the two fields the subtotal before VAT, plus the VAT field. To create this calculation I added a field and inserted the formula {=SUM(b15,b16)}. Testing the Amount after VAT calculation As you can see from the screenshot below that calculation brings back a figure of �39,891.25. To test the calculation I added up the two values from the VAT field and the Subtotal before VAT using the accessory calculator and it gave me a figure of 39891.25. ...read more.

Conclusion

named it Insert_Signature_field: The recorded macro Insert_Signature_field does the following procedure: * Open the file "signature field.doc" * Select all of the text in the File * Copy all of the selected text * Close down the file "signature field.doc" * And display the mail merge template mailmerge.dot * Paste the copied text into the current file STOP MACRO Visual Basic code for Macros added to this document The screenshot below shows the Visual Basic code for the three macros that I have created for this mail merge document. Modification of the toolbar to add new Macros The standard MS WORD(tm) toolbar was then modified to include a new icon for each of the three macros that I have just created To do this I selected the Tools menu from the Microsoft Word Toolbar and chose the options Customise > Commands > Macro as shown below. The three new macros where then dragged and dropped onto the toolbar. To modify the image for each of the macros I right clicked onto each of the buttons added to the toolbar and then selected Edit Button Image as shown below. MACRO 1: Open a new mail-merge blank with mail merged address fields of customer The following screenshot shows how the Macro_New_Mailmerge button was modified on the toolbar MACRO 2: Insert Washout Text The following screenshot shows how the button Insert_Washout_Text was modified on the toolbar. MACRO 3: Insert_Signature_field The following screenshot shows how the Insert_Signature_field button was modified on the toolbar ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Information Systems and Communication section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Information Systems and Communication essays

  1. Marked by a teacher

    Investigating a Transactional Website (www.latestdvd9.com)

    4 star(s)

    This could also be a huge difference for the website, because there are many people who prefer watching Bollywood films, which does not only include people from South Asia, but even from Western Countries. Suggestions for Improvements I would suggest the website starts adding and selling films outside Hollywood, because this would increase their sales by a huge amount.

  2. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    may be regarded as a issue and not include it with my solution. Another method I will use to gather the clients and user requirements will be a questionnaire. I will give this questionnaire to both client and user. The questionnaire will contain a set of closed and open questions

  1. A2 ICT CouseWork

    We have not actually incorporated validation or verification into our forms, but nevertheless we have created a table to show how we will test our validation and verification, as expected all our tests will fail. Link + Code Testing- The Link + Code testing involves testing our Html and PHP

  2. Analysis Tools

    It differs from the flowchart as it shows the data flow instead of the control flow of the program. It shows how data information flows through the organisation. It shows what the system will do, not how it will do it. It shows the data stores used by the system.

  1. User Guide to my minibus hire database.

    The record will then be completely deleted from the database. Deleting a minibus record To delete a minibus' record simply click the "Delete Record" button as shown in the screenshot above. A warning message will then appear as shown above asking you to confirm the deletion of the record, click

  2. Applied ICT - How Comet Stores could use ICT and a CCTV system.

    the customer with what he wants and to understand what the customer wants and tries to help out . As a company having huge stock and very a lot of customers with many regular customers who has registered in this company, as a company you would always have a website, in this website you can buy and order products delivery.

  1. Wjec alevel ict creating a website

    - Font Geneva, Arial, Helvetica, sans-serif, style 4 and text colour #FFFFCC size normal Middle panel text, Default Font, no style, size normal, colour #000000 Warley Contact Webpage "Painting and Decorating FREE QUOTE" (Header) - Heading 1, style 5, colour #FFFFFF, size normal "Painting and Decorating FREE QUOTE" (body of text)

  2. Applied ICT in business scenario answers

    any problem you can not go to the old system to compare and modify it. Or with pilot running, which would occur if in some departments run the new system while in orders the old one. In this case this is impossible since only one department uses computer systems.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work