PRACTICAL FILE

IT APPLICATIONS IN BUSINESS LAB

NAME: HITARTH MAHENDRU

COURSE: BBA
SECTION: A
BBA CODE-111
BATCH – 2021-24
EMAIL ID – hitarthmahendru@[Link]
 MAIL MERGE

A mail merge is a method of taking data from database, spreadsheet, or other

form of structured data, and inserting it into documents such as letters, mailing
labels, and name tags. It usually requires two files, one storing the variable data
to be inserted, and the other containing both the instructions for formatting the
variable data and the information that will be identical across each result of the
mail merge.

Mail Merge is a handy feature that incorporates data from both Microsoft Word
and Microsoft Excel and allows you to create multiple documents at once, such
as letters, saving you the time and effort of retyping the same letter over and
over.

For Example, in a form of letter, you might include instructions to insert the
name of each recipient in a certain place, the mail merge would combine this
letter with a list of recipients to produce one letter for each person in the list.
You a can also print a set of mailing labels or envelops by doing a mail merge.
Most major word processing packages ( e,g. Microsoft word) are capable of
performing a mail merge.
For labels, for example, you would construct a source document containing the
addresses of the people you wish to print labels for and a main document that
controls where each person's name, address, city, state, and zip code will go on
the label. The main document would also contain information about how many
labels are on a page, the size of each label, the size of the sheet of paper the
labels are attached to, and the type of printer you will use to print the labels.
Running a mail merge with the two files results in a set of labels, one for each
entry in the source document, with each label formatted according to the
information in the main document.

A mail merge has four basic steps:

1. Creating a template document.
2. Creating a data source
3. Adding placeholders in the template document for the variable
information.
4. Merging the template and the data source.

A mail merge can be used to print labels with the standard layout while
adding personalised details during the merge. A Mail merge is an
excellent way to print address labels, but can also be used to create
personalised name labels or gift tags or to print product labels that include
standard text alongside the relevant product details for each item.
 MAIL MERGE APPLICATION
Question: Write a formal invitation letter to your business stakeholders for an
annual meet?
INVITATION

To,
«FirstName» «Last Name»
«Address_Line_1»
«Address_Line_2» «City»
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
«Greeting Line»
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
 MAIL MERGE OUTPUT

To,
Krishna Aggarwal
88, Preet Vihar
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Aggarwal,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
To,
Shuauya Malhan
12. Krishna nagar
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Malhan,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
To,
Anhad Chawla
76, Lagpat Nagar
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Chawla,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
To,
Aditya Chawla
78, Patel Nagar
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Chawla,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
To,
Sagar Kapoor
356, Laxmi Nagar
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Kapoor,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
To,
Ritik Khurana
13. Geeta Colony
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Khurana ,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
To,
Abhinav Mahendru
25, Rajouri Garden
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Mahendru,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
To,
Mohit Kapoor
45, Anand Vihar
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Kapoor,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)
To,
Vikram Arora
65. Kirti Nagar
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear Mr Arora,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru
To,
Dev Verma
100, Rajdhani enclave
Delhi New Delhi
Operational Manager
Fashion Express
29 January,2022
Subject: Invitation for an Annual business meeting
Dear MR Verma,
It is with great pleasure that we invite you to the annual meeting on 3
February 2022 at Ashoka Hotel at 1300 hours.
Kindly confirm your presence by 1 February 2022.
Looking forward to seeing you.
Sincerely,
(signature)
(Hitarth Mahendru)