Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2022, 12:46 PM
Alexsander Alexsander is offline Count number of Records in TableStart/End merge Windows 11 Count number of Records in TableStart/End merge Office 2021
Novice
Count number of Records in TableStart/End merge
 
Join Date: Jun 2022
Posts: 2
Alexsander is on a distinguished road
Post Count number of Records in TableStart/End merge


Hi

I need to count the number of records generated in the TableStart and TableEnd in a Report in the last line of the document like "ITEMS: 28". I managed it by using MERGEREC but it assigns the number of the record to each and every record between TableStart and Table End.
Attached Files
File Type: docx teste.docx (19.2 KB, 6 views)
Reply With Quote
  #2  
Old 06-13-2022, 04:42 PM
macropod's Avatar
macropod macropod is offline Count number of Records in TableStart/End merge Windows 10 Count number of Records in TableStart/End merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Since you're using a third-party addin for your merge, you're limited to whatever tools it provides.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-14-2022, 04:18 AM
Alexsander Alexsander is offline Count number of Records in TableStart/End merge Windows 11 Count number of Records in TableStart/End merge Office 2021
Novice
Count number of Records in TableStart/End merge
 
Join Date: Jun 2022
Posts: 2
Alexsander is on a distinguished road
Default

We upload the .doc to the Apiquery, it counts as a 3rd party software? The only thing we do is disply the data from the SQL using The table end mergefield. I thought there was a way to count using bookmarks and refs, but I gues i will make SQLs for subreports just for counting the number of records. Hope it doesn't increase the cost of the report too much. Thanks for the reply
Reply With Quote
  #4  
Old 06-14-2022, 04:57 AM
macropod's Avatar
macropod macropod is offline Count number of Records in TableStart/End merge Windows 10 Count number of Records in TableStart/End merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

TableStart and TableEnd fields are not part of a standard Office installation - they are provided by third-party addins such as Salesforce/Conga, Aspose, and RSA Archer.

A workaround would be to use a macro triggered by the mailmerge to count the number of rows in each table, then output those values in the appropriate locations.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count number of Records in TableStart/End merge Show total number of records mailmerge eduzs Mail Merge 1 11-24-2020 09:04 PM
Count number of Records in TableStart/End merge Mail merge skipping even number records Marcia Mail Merge 1 07-07-2020 06:39 PM
Count number of Records in TableStart/End merge count a number of cells based on the beginning of a order number Kubi Excel 2 08-06-2017 08:54 PM
Count number of Records in TableStart/End merge How do I mail merge records into table columns with more than one merge field? tech123 Mail Merge 1 04-26-2017 07:13 PM
Count number of Records in TableStart/End merge When using a 'Master' template, if number of records change, subsequent records will not be read MailMergeConfused Mail Merge 5 07-28-2016 05:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft