Hi! I have some file with module to create mail from VBA and send it with some body text. But I would like to put there also a table below the text with columns including datas from excel sheet name Arkusz1, columns from A to O. The issue is that the table should have dynamic range, so if user in cell A34 provide some index number, then table should be generated only with rows matching witch the text from user. Can you please help? I really do not know how to manage it.
Dynamic table just with rows matched with user request in mail from Excel to Outlook
- Thread starter junior95
- Start date
Thank you very much for your response. It's very helpful. But it's not fully resolved. Let's say that the user indicates number D2023/0001 and there are several such rows with the number D2023/0001 in the table, I would like those rows that have a number corresponding to the number indicated by the user to be displayed in the table in mail. Currently only the first one that matches will be displayed. Is it possible to set up like this?
