Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Mail Merge in Word?
MailMerge in Word (Next Record Question)?
Anyone know how to jump to the next 7th record? I'm mail merging a document from data in excel, the Next Record rule works perfect BUT I don't want the very next record, I want every 7th record.
Instead of:
Record 1
Record 2
Record 3
I want
Record 1
Record 8
Record 15
Next Record is 1 by 1, I need 7 by 7.
Anyone has any idea how to do this? Very little information online about it.
Thanks very much!
2 Answers
- ?Lv 77 years ago
Merge normally advances by a single record. You may be able to add a bunch of dummy « NEXT RECORD » fields, one after the other, to advance through unneeded records without printing anything.
- PartieHonteuseLv 57 years ago
Try the SkipIf http://office.microsoft.com/en-us/word-help/field-...
Edit: this has an example http://word.tips.net/T000287_Conditional_Processin...
In your excel datasheet create a new column (if it doesn't already exist) and name it record_no (record number) and from top to bottom do 1-x (where x is your last record in the excel sheet). Then use the skipif function to skip the record if it doesn't equal 1,8,15,22,29,etc.etc.etc.