N/APosted on - 03/09/2012
I have to send e-mail to lots of people due to job purpose. For this purpose I was using mail merge in excel. Recently the mailings tab has been disappeared from the top of excel sheets. I have tried to bring it back by searching options but it did not work. So please someone help me solve this problem so that I can do my job with convenience again.
Mail merge problem with Microsoft excel
To use mail merge in MS Office 2007 complete the data in your excel sheet and save the excel. For example I have made the following excel and saved it:
Now go to the word document in which your draft mail is ready. And click on the mailing tab, select “start mail merge” and go to step by step mail merge wizard.
Mail merges window will open on the right hand side. Selective use and existing list from the select recipients list and click Next: Starting document at the bottom of the mail merge window.
Now select Use the current document from the Select starting document list and click Next: Select recipients at the bottom of the mail merge window.
Now select Use and existing list and click browse and select your excel from the Select your data source window. Select the sheet in which you have entered your data.
After selection of the sheet it will ask you what all row items you want to use with the help of the check box select the same and enter OK.
Now go to the Write & Insert Fields option on the menu and select Insert Merge Field.
All the column header in the excel will be present in this field. Place the cursor where you want the desired data to be inserted and select the same from the Insert Merge Field.
The data that will be inserted is displayed in between <<…..>>
After insertion of the desired data click on Next: Write your letter and then again click on Next: Preview your letters.
Here you can preview all your letters and exclude recipients also if required.
Now click Next: Complete the merge and your mail merge is completed.