Getting error User input data error. Sheet name requested does not exist.

Hi friends,

I want to create a word letter for all entries which has a 'W' remark in column 'J' on data sheet. I'm getting error as follows:

User input data error. Sheet name requested does not exist. Folder: D:\WORD\file: LETTER.xlsm Sheet name requested:

Any help will be highly appreciated.

Thanking you,

Hello friends,

If it is not possible then please do suggest me a macro to create letters for all entries which has a 'W' remark in column 'J' an separate file for each entry/person using mail merge. The file name should be the name off person in column 'F' on 'Data' sheet. The workbook is attached post no. 1.


Thanking you,