vlookup mail merge?

I am looking for a solution to help speed up the creation of shipping labels for some repeat work we do.  For this customer we are required to label each pallet or bin with specific information and in most cases there are close to 100 different labels required.

For each "Station" there are between 1-5 different line items that I would want to show up on each label.  So i guess what i am asking is whether or not there is a way to use an excel style vlookup to determine what shows up on each label or if there is another better way i could do this?

examples attached.


Denten McDougallAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

This expert suggested creating a Gigs project.
Not really. Mail merge needs a table-like input such as a spreadsheet, a Word  table, a data base table or a non-hierarchical query

However,  the datasource has a ConnectString property and a QueryString property, so it might be possible to create a complex query that will contain subqueries to emulate the  VLookups and use its SQL for the QueryString.

Alternatively, you could use VBA to create a temporary  intermediate spreadsheet and to run the  merge from that.

Either It would be more work than is justified by a question here,  It sounds like a candidate for a gig,.
Matt NicholasBusiness AnalystCommented:
Hi Denten,

From what I can see you have your data in Excel and also each label is indicated by the orders per station

Just add your data to a pivot table (CTRL+A and insert pivot table). Use the quantity in the values field of the pivot, PO# followed by station followed by BO in the rows section. Next once you have the layout, copy the entire pivot and paste as values into another Excel sheet.

This will give you better formatted data to use for the mail merge
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.