Extract and insert text data from excel table(s) in a (embed) Word document
Thank you for your response! I may not have been clear in my previous message, regarding the respective document. The main problem is that it's issued mainly for the workers from the production areas of the company. They don't use the mail in their activity, but execute only manual tasks. Thus the e-mail method is useless, because the certificate is delivered by hand. On the other hand, every certificate must specify the explicit name of its beneficiary, to be inserted in the specific area of the sheet. That's why I need a direct tool (drop-down list, macro etc.), linked directly to the the Excel sheet in order to extract the proper name from table(s) in the dedicated space from the file. As I mentioned, the certificate may be an external document or an embed one within a sheet of the excel workbook. I will be grateful if you could help me in this sense.
All my best,
Vladimir A.
|