Study Platform for Banking, JAIIB, CAIIB, Promotion And Technology for dedicated Bankers...!!!

Thursday, 14 July 2016

Mail Merge : Combination of word with Excel

 In Mail merge we link the word  to excel data sheet  that help in writing a common letter to all, prepare review letter & many more…

Process : -

Prepare  a excel sheet with required data

Open the word with your desire sheet

Go to  >>

 Mailing
Ø  Start Mail merge
Ø  Step by step mail merge wizard

Step 1  Start document
Step 2  Select Recipient >> Browse ( select the Excel file ) > open > ok > ok
Step 3  Write your letter
Ø  More item
Ø  Put your curser where you insert the desire item >  insert
                                    (Insert all desire field one by one)

Step 4  Preview your letter  
Step 5  Complete the merge



For print

Go to
Ø  Finish & Merge
Ø  Print document
( Print as you desire )



              

            

0 comments:

Post a Comment

Facebook

; //]]>