Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2014, 09:19 PM
macropod's Avatar
macropod macropod is offline Mail merge problems Windows 7 64bit Mail merge problems Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
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

The 'Update all labels' process should propagate the setup from the first label to all others on the page. If it doesn't do so, you should still be able to copy the content from any of the populated labels and paste its content into the others (just make sure each label ends up with only one «NextRecord» field.



Two additional points:
1. DDE is old technology that has been superseded by both ODBC and its successor, OLE DB. You should only use DDE as a last resort, as it only works with the first worksheet in the workbook, and only for named ranges that names that reference the first sheet and have either workbook scope or the same scope as the sheet.
2. The Address Block often does a poor job of managing address layouts, including being unable to suppress blank lines in an address. You're generally better off inserting the required mergefields, where required, and using the available switches, etc. for controlling blanks lines, etc.

PS: Please post mailmerge questions in the mailmerge forum (to which I've moved your post).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Problems jmac12 Outlook 2 07-04-2018 01:14 PM
Mail merge problems Mail Merge is Deleting objects in my header and footer during the merge bgranzow Mail Merge 9 06-05-2015 05:03 AM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Mail merge problems Problems with mail merge Joanne Mail Merge 1 09-29-2013 07:24 PM
Mail merge problems Merge to e-mail: two problems MartinD_UK Mail Merge 15 06-19-2012 11:23 PM

Other Forums: Access Forums

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