Mail Merge - Insert table and checkbox from Excel to word

sanket_sk

Board Regular
Joined
Dec 27, 2016
Messages
97
Office Version
  1. 365
Platform
  1. Windows
Dear All,

Hope you and your family are safe and sound!!!

I am working on a very small project where I need to circulate appointment letters.

I am getting a list of new joiners from HR in excel format, the task is to convert this information into a word document.

I know it's very easy using Mail merge however there is a twist.

In the appointment letter I will have to define their job area ( Zipcode ) which are very from 10 zip codes up to 295 zip codes, also need to put a tick on the Other eligibility criteria which are check box.

I don’t see these feature in normal mail merge ( Using Office 365 enterprise version), could you please guide me on this or provide a Macro to perform this task.

Attaching sample data and snap of letter in which we need to put information in the yellow highlighted area

Thanks & Regards,

Sanket

Book3
F
8
Sheet1
 

Attachments

  • Letter.jpg
    Letter.jpg
    96 KB · Views: 21

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,147,498
Messages
5,741,504
Members
423,663
Latest member
kaveh87rsh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top