ICT July 2012

[Ravichandran]

Dear July 2012 ICT batch students, Please share and upload all your assignment task and your classroom discussions in this forum. Dont use any other forum as it is closed as of now.

Dr.Ravi

[0hqgdhz8j9y4a]

 Name: Siti Farhana Sheikh Yahya

 I/D : 7145/11

 Block : 2

[01a09z6btz4eg]

[1wj1m2sviohae]

 

 

[0imo6yvjboacm]

Today, I have learned Mail Merge. The process begins by creating a Microsoft Excel document which consists of a number of variables. Then, a letter is constructed using Microsoft Word and the previous spreadsheet created is merged with the letter by using the Mailing option. By doing this, we are able to create multiple documents from only one document.

[1ka2uz6vkwhbu]

Today, I learned how to mail merge.  It was a fantastic experience. I created a document in Microsoft Words and linked Excel into my document. 

[Foo Jane Fang]

Hello, I have learned how to mail merge. I created a list in Microsoft Excel and then typed my documents in Microsoft Words. Then I inserted the merge field and it's done! I have 5 documents with the same content but different recipients, date and venue.

[2q0ae0fj7t1bi]

Name: Nurshaffira

ID no:7234

block:1

Today I did an excel document which includes the name, date and venue under block a, b and c. After that, I did a short and simple letter under a word document. Then I browsed the excel document I did earlier on to my letter by inserting merge field. Lastly, i previewed all the results.

[0lvc7jm2mntqk]

MAIL MEEEEEEEEEEEEEEERGE

Open up an Excel document and name your columns according to what info you need! Fill it up! Link it to your Word Document!

It's that easy!

[14rgli0b14po3]

Mail merging:

• Open Microsoft Excel
• Type in the variables and details (eg: Name, Venue and Date)
• Save under Book1
• Open Microsoft Document
• Click on Mailings
• Click on "Start Mail Merge"
• Click "Step by step Mail Merge Wizard
• Then click "Next: Starting document" on the bottom right
• Then click "Next: Select Recipients"
• Under "Use existing list", click Browse
• Select the file that you had saved earlier on
• Write your letter
• Add in the name, venue and date by clicking "Insert Merge Field"
• Save it
• Then post it up!

 

YAY.

[2tecba0a6z20f]

Name : Lakhsmi

ID : 7268

Block : 1

The mail merge concept is rather easy to understand. The first step in the procedure would be to create the manipulated variables in rows and columns in Microsoft Excel spread sheet. This file is then saved. A formal letter should be then typed in using Microsoft Word. Before typing, click the Mail Merge icon at the top left corner of Word. Choose step by step wizard and it shall navigate you from there after. 

[3n32c9bcv3oju]

Merge Mail:-

1. Create an Excel document. Fill the first row of the Excel worksheet with details i.e. - name, date and venue.

2. Fill in the details according to their rows and columns. Save the excel file.

3. Open Microsoft Office Word and click Mailings, followed by Start Mail Merge >> Step by Step Mail Merge Wizard.

4.Click step 1, followed by step 2 at the bottom of the newly opened window and click browse >> select the Excel file saved earlier >> Sheet 1 >> OK.

4. Write the letter and fill in the details (name, date and venue) by clicking on Insert Merge Field.

5. Finally, preview the letters by clicking on the arrow beside the number dialogue box on the top of the page.

[1wj1m2sviohae]

Today, we were thought on how to use mail merge using Microsoft Words. We were given an example shown on the projector as a guidance on how to use it. Later on, we were given a task to do similar activity on our own. The steps are as folows;

Using the Microsoft Excel software, the details to be inserted in the mail were filled in the first column and first row. Once that is done, save the file.Next, using Microsoft words, select mailings and click 'start mail merge' and followed by 'setup wizard' button. A sidebar will appear and the click the 'browse' option. Select the Excel file saved earlier and click sheet one.Lastly, type in your letter and click the 'insert merge field' button to insert your selected choice of names, dates, time and etc, based on the contents written in the Excel file earlier.