Hello, I have a large inventory list I've created in excel. I need a macro to create X number of labels from data in the table. It has 13 columns and a running number of rows. I've been looking around for a few months now but haven't found anything that works for me. Is this even possible? does it need to be done in parts? VBA code is all new to me so any help would be awesome!
The Macro needs to:
The Macro needs to:
- Identify specific records on the 1st sheet (titled: Storage Log):
I have a status qualifier value in column M (header: Storage Status). The macro needs to identify and work with only rows with the text "Boxed Up" in this column. - Pull information from specific columns for the labels:
I don't know if this is relevant but it needs the data in columns B,D,E, and H. - Set up for a mail merge:
This is the tricky bit. I have a quantity value in column C that will be how many labels I need generated for that entry(row). The macro can not tamper with the original table if it needs to create duplicate records. It can create a new sheet as long as it can push it to the last tab or if possible use a designated sheet to work on. - Run the merge from excel to an existing ms word template:
I have a template set up for the labels already so I'd like to use that if possible. We'll call it labeltemplate.dox. Its an avery 5963 label template with the merge fields in place and formated. - Clean up after itself:
When the merge is done I would like it to erase any changes it made to the original excel file.
