How do I extract data from a drop-down menu in each cell and place each information in a single cell and from there create a mail merge in a Word document?

Question

How do I extract data from a drop-down menu in each cell and place each information in a single cell and from there create a mail merge in a Word document?

Anonymous

I have three Word documents that need to be mail merged from data in an Excel spreadsheet. The challenge is to extract the data out of a drop-down list and into single cells. From there, I can perform a mail merge.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Hi Shari,

Thanks for posting in the community. We are happy to help you.

If you want to use Mail Merge to get data from an Excel workbook, you need to input the data in cells and set the range to a table. For the challenge you mentioned, have you entered data in cells? If you are referring to just getting the options in the drop-down menu, to my knowledge, it is not possible.

If my understanding conflicts with your meaning, please point it out and provide more details.

Sincerely,

George | Microsoft Community Moderator

Share via

How do I extract data from a drop-down menu in each cell and place each information in a single cell and from there create a mail merge in a Word document?

1 answer