Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-22-2011, 08:48 AM
karen h karen h is offline skip duplicate letters Windows XP skip duplicate letters Office 2003
Novice
skip duplicate letters
 
Join Date: Feb 2011
Posts: 8
karen h is on a distinguished road
Question skip duplicate letters


I have a mail merge, merging from Access. The query selects everyone who has expired items in their records. This prints on a report so I can send a letter letting the people know what is expired.

I want the letter to only use the address info the first time it shows up in the query. I have the report to refer to in order to add auto text into the letter about each item that is expired but I don't need 10 letters to the same person, one for each item that is expired.

I have tried placing a next record at the end of each letter but this only skipped every other record, not what I was looking for.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up recurring months to skip some months etc. dwelch@ykfireprevention.c Outlook 0 11-30-2010 10:15 AM
How to skip the credential checking step charleslt1900 Outlook 2 08-19-2010 04:02 PM
Added letters to body message kawzie Outlook 1 07-12-2010 11:00 AM
individual merge letters ahmed_tr Word 2 06-27-2009 11:18 AM
skip duplicate letters sending personal letters misteroffice Word 3 12-23-2008 08:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:59 PM.


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