rharri1972
Board Regular
- Joined
- Nov 12, 2021
- Messages
- 132
- Office Version
- 2019
- Platform
- Windows
Hello.. I have a spreadsheet that contains information that I have to make into labels. Currently I save from one sheet to another only the info i need on the labels... Part, Qty, PO, Job, Customer Name.
Open Word, mail merge and so on.
I would like to automate this from Excel. The report is an Open Orders Report. I need to, with vba, filter the "Order Date" column to only show the orders processed "yesterday" and am hoping I can also have a sub routine that will open word and set up the mail merge automatically as it it a tedious task doing it manually every day.
Is this possible?
Open Word, mail merge and so on.
I would like to automate this from Excel. The report is an Open Orders Report. I need to, with vba, filter the "Order Date" column to only show the orders processed "yesterday" and am hoping I can also have a sub routine that will open word and set up the mail merge automatically as it it a tedious task doing it manually every day.
Is this possible?