Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-28-2017, 08:12 AM
Gwinnett Gwinnett is offline Mailmerge Directory - TableJoiner Macro Windows 7 64bit Mailmerge Directory - TableJoiner Macro Office 2013
Novice
Mailmerge Directory - TableJoiner Macro
 
Join Date: Feb 2017
Posts: 5
Gwinnett is on a distinguished road
Default Mailmerge Directory - TableJoiner Macro

Hello,
I have sucessfully used the macros in Macropod’s excellent Catalogue/Mailmerge Directory Tutorial to create some very useful reports. I have never tried to use the TableJoiner macro until recently and am having trouble making it work properly.
Macropod’s instructions are clear on how to use the macro, and I have successfully installed it per the instructions in Graham Mayor’s tutorial (http://www.gmayor.com/installing_macro.htm). However, when I run the TableJoiner macro nothing happens, i.e., the multiple tables created (1 per record) are not joined into one site’s table.

I am using MS Word 2013. The mailmerge code I am using creates tables grouped by site. The end product is 103 pages covering 70 sites. I thought the problem was the number of records (1442 in the Excel sheet) so I did a test on just the first 25 records (1 site). Still, the individual record tables do not join when I run the macro. I am stumped at this time.

Perhaps someone can see the error and point me in the right direction? Below is the TableJoiner macro code I am using and the macro supplied by Macropod. I have attached a copy of mailmerge code and a short test mailmerge output document.

Cheers,






Sub TableJoiner()
Application.ScreenUpdating = False
Dim oPara As Paragraph
For Each oPara In ActiveDocument.Paragraphs
With oPara.Range
If .Information(wdWithInTable) = True Then
With .Next
If .Information(wdWithInTable) = False Then
If .Text = vbCr Then .Delete
End If
End With
End If
End With
Next
Application.ScreenUpdating = True
End Sub
Attached Images
File Type: png Mailmerge Code HS-MS Recap.PNG (43.5 KB, 29 views)
Attached Files
File Type: docx Date1.docx (17.6 KB, 15 views)
Reply With Quote
 

Tags
macro, mailmerge, tablejoiner



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge Directory - TableJoiner Macro Word 2010 Macro to rename Folder in Directory staicumihai Word VBA 2 10-28-2016 03:01 AM
Mailmerge Directory - TableJoiner Macro How To Apply A VBA Macro to All Subfolders in a Directory of a docx. Extension jc491 Word VBA 8 09-11-2015 08:31 AM
Directory MailMerge with Category Grouped Lists on Labels screech Mail Merge 3 06-18-2014 11:41 PM
Mailmerge Directory - TableJoiner Macro Pictorial directory using mailmerge JohnFinNC Mail Merge 6 10-04-2012 06:36 PM
Mailmerge Directory - TableJoiner Macro Directory Mailmerge rohitjain80 Mail Merge 1 02-12-2012 03:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 AM.


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