Word mail merge: Show only the Nth row of a table
How do I show only the Nth row of a table in a Word mail-merge?
My template is of this format:
{ MERGEFIELD TableStart:widgetList }
Foo: { MERGEFIELD foo }
Bar: { MERGEFIELD bar }
{ MERGEFIELD TableEnd:widgetList }
But I only want to see Foo and Bar for the Nth widget in the list. How would I limit the output to just that row of the widgetList table? Specifically, I need the last row.
I can't do anything clever with macros, or anything like that - I'm constrained to uploading an unadorned .docx with merge fields into Proprietary SystemⓇ, which will then spit out reports on request.
Relatedly:
the example template from Proprietary SystemⓇ uses this syntax:
{ MERGEFIELD widgetList!size }
to show the number of rows in the table. Is this standard Word behaviour, and is
sizethe only keyword which can follow the!? I tried to find documentation but my google-fu is weak today.
- can I sort the table at the mail-merge point, or must that be done upstream? I'd like to reverse the table if I can't restrict it to the last row only.
microsoft-word microsoft-word-2013 mail-merge
asked Dec 20 '18 at 18:28
Jack DeethJack Deeth
1013
add a comment |
How do I show only the Nth row of a table in a Word mail-merge?
My template is of this format:
{ MERGEFIELD TableStart:widgetList }
Foo: { MERGEFIELD foo }
Bar: { MERGEFIELD bar }
{ MERGEFIELD TableEnd:widgetList }
But I only want to see Foo and Bar for the Nth widget in the list. How would I limit the output to just that row of the widgetList table? Specifically, I need the last row.
I can't do anything clever with macros, or anything like that - I'm constrained to uploading an unadorned .docx with merge fields into Proprietary SystemⓇ, which will then spit out reports on request.
Relatedly:
the example template from Proprietary SystemⓇ uses this syntax:
{ MERGEFIELD widgetList!size }
to show the number of rows in the table. Is this standard Word behaviour, and is
sizethe only keyword which can follow the!? I tried to find documentation but my google-fu is weak today.
- can I sort the table at the mail-merge point, or must that be done upstream? I'd like to reverse the table if I can't restrict it to the last row only.
microsoft-word microsoft-word-2013 mail-merge
asked Dec 20 '18 at 18:28
Jack DeethJack Deeth
1013
add a comment |
How do I show only the Nth row of a table in a Word mail-merge?
My template is of this format:
{ MERGEFIELD TableStart:widgetList }
Foo: { MERGEFIELD foo }
Bar: { MERGEFIELD bar }
{ MERGEFIELD TableEnd:widgetList }
But I only want to see Foo and Bar for the Nth widget in the list. How would I limit the output to just that row of the widgetList table? Specifically, I need the last row.
I can't do anything clever with macros, or anything like that - I'm constrained to uploading an unadorned .docx with merge fields into Proprietary SystemⓇ, which will then spit out reports on request.
Relatedly:
the example template from Proprietary SystemⓇ uses this syntax:
{ MERGEFIELD widgetList!size }
to show the number of rows in the table. Is this standard Word behaviour, and is
sizethe only keyword which can follow the!? I tried to find documentation but my google-fu is weak today.
- can I sort the table at the mail-merge point, or must that be done upstream? I'd like to reverse the table if I can't restrict it to the last row only.
microsoft-word microsoft-word-2013 mail-merge
asked Dec 20 '18 at 18:28
Jack DeethJack Deeth
1013
How do I show only the Nth row of a table in a Word mail-merge?
My template is of this format:
{ MERGEFIELD TableStart:widgetList }
Foo: { MERGEFIELD foo }
Bar: { MERGEFIELD bar }
{ MERGEFIELD TableEnd:widgetList }
But I only want to see Foo and Bar for the Nth widget in the list. How would I limit the output to just that row of the widgetList table? Specifically, I need the last row.
I can't do anything clever with macros, or anything like that - I'm constrained to uploading an unadorned .docx with merge fields into Proprietary SystemⓇ, which will then spit out reports on request.
Relatedly:
the example template from Proprietary SystemⓇ uses this syntax:
{ MERGEFIELD widgetList!size }
to show the number of rows in the table. Is this standard Word behaviour, and is
sizethe only keyword which can follow the!? I tried to find documentation but my google-fu is weak today.
- can I sort the table at the mail-merge point, or must that be done upstream? I'd like to reverse the table if I can't restrict it to the last row only.
microsoft-word microsoft-word-2013 mail-merge
microsoft-word microsoft-word-2013 mail-merge
asked Dec 20 '18 at 18:28
Jack DeethJack Deeth
1013
asked Dec 20 '18 at 18:28
Jack DeethJack Deeth
1013
edited Dec 21 '18 at 13:22
Jack Deeth
asked Dec 20 '18 at 18:28
Jack DeethJack Deeth
1013
asked Dec 20 '18 at 18:28
Jack DeethJack Deeth
1013
asked Dec 20 '18 at 18:28
Jack DeethJack Deeth
1013
1013
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Seems TableStart:, TableEnd: and !size are all extensions provided by Proprietary SystemⓇ so I'll need to ask them for help. C'est la vie.
answered Dec 21 '18 at 14:30
Jack DeethJack Deeth
1013
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1386395%2fword-mail-merge-show-only-the-nth-row-of-a-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Seems TableStart:, TableEnd: and !size are all extensions provided by Proprietary SystemⓇ so I'll need to ask them for help. C'est la vie.
answered Dec 21 '18 at 14:30
Jack DeethJack Deeth
1013
add a comment |
Seems TableStart:, TableEnd: and !size are all extensions provided by Proprietary SystemⓇ so I'll need to ask them for help. C'est la vie.
answered Dec 21 '18 at 14:30
Jack DeethJack Deeth
1013
add a comment |
Seems TableStart:, TableEnd: and !size are all extensions provided by Proprietary SystemⓇ so I'll need to ask them for help. C'est la vie.
answered Dec 21 '18 at 14:30
Jack DeethJack Deeth
1013
Seems TableStart:, TableEnd: and !size are all extensions provided by Proprietary SystemⓇ so I'll need to ask them for help. C'est la vie.
answered Dec 21 '18 at 14:30
Jack DeethJack Deeth
1013
answered Dec 21 '18 at 14:30
Jack DeethJack Deeth
1013
answered Dec 21 '18 at 14:30
Jack DeethJack Deeth
1013
answered Dec 21 '18 at 14:30
Jack DeethJack Deeth
1013
1013
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1386395%2fword-mail-merge-show-only-the-nth-row-of-a-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
