Log In
Register
Home
Power Query
August 3, 2020
Offline
Hello,
I'm using Power Query to create a table to use as a Word mail-merge data source. When I connect to the workbook from Word to select the data source, I can see the names of each worksheet (shown as a Table) but can't see the individual tables, which is what I want. I thought I'd previously been able to do this, but perhaps I've misremembered.
Could anyone please advise me if it's possible to select a specific table rather than an entire worksheet? I'd also be happy to connect to the underlying query, if that was an option...
Many thanks indeed.
Pieter
See Answer
Trusted Members
Moderators
January 31, 2022
Offline
I've been doing this many years and do not recall that you could ever select a table. Mailmerge looks at a single sheet to get the data from. I use PQ as well to generate tables for mailing letters to two different target groups of members in a club I'm active in. Each group's table get's loaded to their own sheet in the same workbook, and I have two letters in Word each merging with the relevant Excel sheet that contains only one table. Don't think you can do it any other way.
Answers Post
Power Query
August 3, 2020
Offline
Thanks Riny for the very prompt and helpful reply. My memory must be playing tricks and at least I now know that what I'm looking to do can't be done!
Thanks again and happy new year.
Pieter
1 Guest(s)
