Forum Discussion
mjazdzewski
Nov 23, 2021Copper Contributor
Merging rankings from Excel into Word
I have employee ranking evaluations that I must merge into a Word letter. The ranking is based on years of service. So I have six people with an excellent evaluation. The person with the least am...
HansVogelaar
Nov 23, 2021MVP
Either add a column with the ranking and another column with the number of people (the latter would have the same value in all rows) to the source range, or add a column that displays 1 of 6 etc.
You can then use the two columns or the single column in your mail merge.
mjazdzewski
Nov 23, 2021Copper Contributor