
Power Query

August 3, 2020

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


Trusted Members
Moderators
Power BI

January 31, 2022

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
1 Guest(s)
