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
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 |