Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2015, 02:03 AM
gmayor's Avatar
gmayor gmayor is offline Maintaining the first field, but changing the second fiel Windows 7 64bit Maintaining the first field, but changing the second fiel Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You can't do this with regular mail merge as you envisage. The easiest way to achieve it is to create a separate record for each month for each person i.e.

Jane Doe January 2015
Jane Doe February 2015
Jane Doe March 2015
Jane Doe April 2015
Jane Doe May 2015
Jane Doe June 2015
Jane Doe July 2015
Jane Doe August 2015
Jane Doe September 2015
Jane Doe October 2015
Jane Doe November 2015
Jane Doe December 2015
Bob Smith January 2015
Bob Smith February 2015
Bob Smith March 2015
Bob Smith April 2015
Bob Smith May 2015
Bob Smith June 2015


Bob Smith July 2015
Bob Smith August 2015
Bob Smith September 2015
Bob Smith October 2015
Bob Smith November 2015
Bob Smith December 2015
etc

Then it is a simple label merge.
Mailmerge with Word 2007/2010


If your label sheets are in multiples of 12 you can get away with inserting the name fiels alone, and fixed text for the dates, with a Next record field after every 12 records, but it is easier to create the worksheet with the data you require, given the power of Excel's copy down functions - especially as there are only 25 individuals.

The only other solution is to create the process in VBA to write values to the individual labels, but for that the label layout would need to be known. before you start as the variations are legion.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
labeling, new record



Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining the first field, but changing the second fiel Making a field with changing text based on mouse click. Evalis Word 1 01-23-2015 11:37 AM
Using Quick Parts >> Ref >> Field (Third word changing font) sonny49 Word 1 01-07-2014 10:01 AM
Maintaining the first field, but changing the second fiel changing date format in Bibliography field elly111sk Word 3 07-25-2012 06:54 PM
Changing Display Name in Inbox From Field amurray Outlook 3 04-18-2012 12:06 PM
Maintaining the first field, but changing the second fiel Changing the From field jerem Outlook 2 10-29-2010 03:04 PM

Other Forums: Access Forums

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