Forum Discussion
Using VBA to find rows that contain specific information in a column and automatically emailing it?
Have a sheet with 30k rows of customer requests and trying to figure out how to use VBA to find requests that have a specific account number in column G and then emailing each corresponding row conta...
Jss88 I recommend you check out this video tutorial. They have a great template for doing a mail merge but using excel and therefore able to use filters in excel to determine the mail merge criteria (or at least that is what I seem to recall):
https://www.youtube.com/watch?v=URF3ikW0Svc
- Awesome, thanks for the direction. I will give it a try 👍
