We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

The Mail Merge Essay Sample

essay
  • Pages: 9
  • Word count: 2,209
  • Rewriting Possibility: 99% (excellent)
  • Category: system

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Introduction of TOPIC

My granddad, Sam Screen, runs a local video and game rent or buy shop and he is finding it hard to update all the customers about returning late videos or games, because of the large amount of customers he has received over the years he has had the shop.

The customers who have not sent back the video/game will get a notification letter of a continuous 6 hour fee, if a customer is abroad it will be a daily fee. One of our customers name is called Adam Sate, his phone number is 07658548358 and he lives in 117 Edgware Road, London, Middlesex, I17 H1O

One way I could help him is to just write out the letters by hand and then send them out to the customers, another way I can help him by using mail merge so he could write 1 letter but when completed he would have (if needed) 10 letters ready for printing then mailing. Using mail merge this will also help him by keeping a documentation of all his customers, addresses and phone numbers for future reference.

The advantage of using ICT over manual methods is that you can write out the letter you want, copy it and paste, it for however many letters you want then you can type in all the addresses, names and also prices. Another advantage of using ICT is that instead of typing out the letter and copying and pasting then typing in the names, addresses, phone numbers ect… it is that you can type up a letter use mail merge and you have the equivalent of (if needed) 10 letters but only having to write 1.

I am going to have 4 quantitative objectives. The first one I will do is save all the customers to a database so that you can access all of the customer’s information quickly, the second is to type up all the letters leaving out names, addresses, dates (for when film was bought) ect…, the third will be to fill in the gaps using mail merge and finally the fourth, be able to print off the letters addressed to all the customers.

Analysis

Hardware

The type of computer system I need to solve the problem is a desktop because it has more memory space and in effect stores more data, the output devices I am going to use is a printer to print off the letters and also a screen to see what I am typing. The input devices I am going to use is a keyboard, to type up my information, also a mouse to get to a file or a program I need to type up information also I will use a scanner to input data such as complaints or other information. For the storage I am going to use is a Maxtor 60GB Hard Drive and has got a Basic audio and video system. For the other hardware of my computer I am going to use a fast but cheap processor such as the Intel Core 2 Duo E6300 for the graphics card it will be extremely basic such as the Nvidia 6600 witch outputs to a 15.4″ Screen.

Software

The first software I will be using the software Microsoft access and the facility I will be using is called mail merge. I will be putting in all the information and also filtering, the next software I will use is called Microsoft word to write down my report and I will use Microsoft word to use mail merge to write down the letter I want and then using mail merge to add in all the information I want e.g. name address ect…

Input

The information I need in order to solve the problem is;

* Names

* Addresses

* Phone numbers

* Video/game rented

* Date Video/game taken out/request date to be brought back

Method of collection: The method of collection I will be using will be in a number of ways. The first way will be in a survey form getting information from people and then details put onto information cards which will then be saved onto a database. Another way I will use is also using old information cards and again saving the information onto a database

Error checking: The way I will make sure the information I have collected correct is first:

Use spell check to see if the addresses are real.

I can

also proof read the information personally. Give the information

Sorry, but full essay samples are available only for registered users

Choose a Membership Plan
to the customers when they come into the shop for a final check.

Processing:

You maybe asking how I am going to do this?

Well I will be starting by first of all organizing all of my customers invoices and information and put them in alphabetical order, after that I will use a device (such as a scanner) which links to a piece of software turning the picture of the Membership details into data which is then inputs the details such as videos, name and address into a complicated Microsoft access database. If this does not work I will have to put in the man power to convert all of the data manually into the computer system, once this is done I can move onto using my facilities such as Microsoft Access so I can start customizing my database and use my other facility Mail merge to create and test out the invoices or queries

No

Yes

No

Yes

No

Yes

No

Yes

No

Yes

No

Yes

No

Yes

No

Yes

Yes

No

No

Yes

Output:

I will now be talking about the various functions that the PC will actually produce for me. The first is screen based; this is so that I can see what I am doing on the PC. The second is printed; this is so that when I have finished my work (Mail Merge letter) I can have it on a sheet ready to be sent off.

The paper size I am going to use is A4 this is because if I have a too small piece of paper everything will be squashed together and hard to read, and if the piece of paper is too big it is a waste of money, it will need a bigger envelope which will cost more money and when the customer opens the envelope the sheet will bee to large to handle.

The colour of the text will be in black because it is cheaper and also more professional than any other colour (like blue or yellow).

There are only going to be two different outputs that will be required the first is the screen, and the second is the printer. These will be used at when there is a new customer that wants to take out a video, and/or if a customer has an overdue video a notification letter will be sent.

Backup Strategies

The backup strategy that is most suitable for backing up the data stored on the computer is a USB flash drive; this is because flash drives are impervious to scratches and dust and mechanically very robust. The data that will be stored on the USB will be weekly updated incase the data on the PC is lost/deleted.

Security

Because the computer has important information that the customers do not want displayed to public eyes, I must use a very strong security system, this will enable me to put passwords on all the files of information I want to be protected and also on the logon screen. This will ensure that if anyone does get onto the computer everything is password protected, and a lot harder to get onto.

Implementation

Evaluation

The original problem that I needed to solve was updating all the customers that had taken out a video or game and had failed to return the video or game, and I have infact solved this problem that had occurred.

– Save all the customers to a database so that you can access all of the customer’s information quickly.

– Type up all the letters leaving out names, addresses, dates (for when film was bought) ect.

– Fill in the gaps using mail merge

– Be able to print off the letters addressed to all the customers.

I can say that I have solved these problems and I will now explain how I had solved these problems.

For the first objective I had used the software called Microsoft access this had allowed me to set out all the different categories that I had wanted in my database e.g. names, video/game, return date. ECT… and I could also go to the customer I wanted very quickly.

When it came to the second objective, I opened up a software called Microsoft word and went onto a tab called mail-merge and used this to type up my letter and in this process type multiple letters just by typing only one letter.

The third objective was to fill in all the information using mail merge e.g. names, video/game, return date. ECT… this was done because I had first used the software called Microsoft access an I could link this software to mail merge.

The final objective was to be able to print off all the letters that I had just created for each customer, I did this by simply clicking on the top hand left corner and selected the print icon and printed off one of each letter.

For my design I had made several changes. These changed had consisted of moving the company details to the bottom of the page (as a footer), the logo at the top of the page in the centre, the customer address at the top of the page above the contents of the letter, and finally the signature and the name of the manager underneath the contents of the letter on the left hand side.

I made these changes to the design because it made the letter look extremely untidy, and I also made these changes because all the information was all over the letter and really confusing to look at.

Dear Mr Jordan Ezekiel,

I think that your method of helping me organise all of my customer’s information and writing out all of the letters was quite helpful and it also made giving out letters to customers a lot easier and it also saved a lot of time. Based on the problem beforehand these solutions were very helpful. One other problem however, is that I have so search through all of the customers return dates every day and this can take up a lot of time. In addition to the new system I have an idea of making ID cards for each customer or a new customer.

Yours sincerely,

Mr Sam Screen

Further improvements to this work is that I could use the software called Microsoft Excel and I will use this software so that it indicates when a video/game is overdue, and after this if there is a website their will be a managers account and this will also automatically update on late videos/games and this will be in date order.

We can write a custom essay on

The Mail Merge Essay Sample ...
According to Your Specific Requirements.

Order an essay

You May Also Find These Documents Helpful

Totalitarianismand political regime

Is it rational to use totalitarianism as a political regime of the state? This essay is devoted to the essence of totalitarian regime. I will try to find main features, which are necessary to build this system in the state. Moreover, I will try to find out whether the countries, where totalitarian regime has ever existed, are viable. First of all, it is important to give a definition to the term «political regime». Many scholars, for example, P. Schmitter and G. O’Donnell, H. Laswell and G. Golosov, dedicated their works to this issue. But I consider that the definition of Jean-Louis Quermonne, French political scientist, is the most precise of all. In his opinion, political regime is «all the ideological, institutional and sociological elements that contribute to shaping the government of a given country for a specific period». I chose it, because his definition is the most common in European political science....

McDonald's business operation system

In this essay, I will be discussing the importance of Data, information, and Knowledge within an organization and I will also define each one of the components thoroughly. Data, Information, and Knowledge. To begin with, there are many authors with different definitions of data, information, and knowledge. Ralph M. Stair and George W. Reynolds (2012, p.5-6.) Defines data as facts and figures that have not been modified and processed by an organization, an example of data in a business industry would be employee's personal details such as phone numbers, date of birth, name, and address. Further, data needs to be relevant, accurate and useful to an organization because not all data is reliable and useful. Therefore, it must be processed and put into more convenient form for the users. This is known as the transformation of data into information. Ralph M. Stair and George W. Reynolds (2012) illustrates that information is data...

Functionalism working system

As Britain industrialised from the late 1800s forward the prototype of family changed. In pre-industrial times they were called extended families, normally being three generations living under the same roof, they needed to have large families to be able to work large amounts of land. Therefore, when industrialisation began, and everybody needed to move to the cities, extended families were no longer needed, but mobile families instead, one´s that could follow work opportunities wherever presented. The mechanical solidarity within the extended family social structure transformed into an organic organism. The reduction of members to a father, mother, and children fitted society’s needs and was the origin of the nuclear family in a capitalist society. In 1949 George Murdock, an American anthropologist and sociologist, defined four functions a nuclear family performs, stable satisfaction of sex drive, meaning parents would have a monogamous relationship which prevented conflicts in society. Reproduction of the...

Popular Essays

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?