Thanks for all the help, but I seem to have solved it.
If you use ActiveDocument.MailMerge.EditDataSource, then that switches the active document to be the data source table (which is initially set up empty because I have no records in my datasource). I can then edit ActiveDocument.Tables(1)...
Yes I agree, if I wanted to store this data I would use Excel. This query isn't about data storage (sorry if I wasn't clear enough). It's about generating a set of identifying labels in a particular format for printing. The people generating the labels will know that they have 'n' options for...
:D normally I'd be skeptical of a statement like that too. But this needs to be simple to use, and run on a range of systems across a wide geographical area. (Almost) everyone has word, and since the setup for the labels is already in word, it made sense to mail merge the table of labels into...
Hi,
I'm trying to create a number of sets of labels. Each set will have all combinations of a set of options eg.
[a-e][1-5][m-p][2-4] would give a list of labels a1m2, a1m3, a1m4, a1n2 etc...
I've not done any vba before, but thought this might be the way to go, since these will need to be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.