Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 12-06-2019, 03:03 PM
macropod's Avatar
macropod macropod is offline Blank Lines in Mail Merge - Other Options not working Windows 7 64bit Blank Lines in Mail Merge - Other Options not working Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

For any other mailmerge main document, you would need to change the '8' in:
For r = .Rows.Count To 8 Step -1
to specify the top row to test and the '(2)' in:
If Len(.Cells(2).Range.Text) = 2 Then .Delete
to specify the column to test.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank Lines in Mail Merge - Other Options not working Mail merge returning blank field SHA Mail Merge 3 05-03-2019 01:54 PM
Blank Lines in Mail Merge - Other Options not working I am getting blank lines with Mail Merge rtcary Mail Merge 1 01-20-2018 02:07 PM
Blank Lines in Mail Merge - Other Options not working Mail Merge Macro - With Options? MacroNoob Mail Merge 1 09-08-2017 12:11 AM
Blank Lines in Mail Merge - Other Options not working Eliminating blank lines in mail merge (labels) BeerStud Mail Merge 1 11-28-2014 06:29 PM
Message Options - Mail Merge limitations nai0248 Mail Merge 0 12-09-2010 01:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:24 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