Hi Excel expert friends,
I want to create separate letter for each person who has 'W' remark in column 'J' on 'Data' sheet. The person's name in is in column 'F'. I want the name of person 'column F' as a file name for each one. If there is a dash sign in column 'J' then I don't want to create a letter for that person. I want to do it by using mail merge function in word.
I'm in a urgent need of a macro to perform this mail merge to create letters for the persons who has a 'W' remark. Therefore, I request you experts to assist me to achieve this target at the earliest positively.
The word file is in 'INPUT' folder.
I want to save all letters for the persons in 'OUTPUT E' folder.
Any help will be highly appreciated.
Thanking you inn antici-0ation.
Bookmarks