Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2016, 05:14 AM
Highlander01 Highlander01 is offline Adding sequential Number in a document that already has merged fields inserted Windows 10 Adding sequential Number in a document that already has merged fields inserted Office 2016
Novice
Adding sequential Number in a document that already has merged fields inserted
 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 14
Highlander01 is on a distinguished road
Default Adding sequential Number in a document that already has merged fields inserted

Hi All

I need some help if at all possible.

I have created a document and inserted the merged fields that I require from a data source (excel spreadsheet). One of the merged fields is a class number (ABCD1234). I would like for the system to add a hyphen and a sequential number (-1,-2, -3 etc) following the class number once the document is merged.

Just to explain why.



I have a locally produced certificate which needs a unique reference number at the bottom. In order to give the certificates a unique number it is my intention to use the class number (ABCD1234) followed by hyphen 1 (-1) and so on. The outcome would be for the unique number to look like this:

ABCD1234-1
ABCD1234-2
ABCD1234-3
Etc

Any help would be greatly appreciated.

G
Reply With Quote
  #2  
Old 01-16-2016, 02:46 PM
macropod's Avatar
macropod macropod is online now Adding sequential Number in a document that already has merged fields inserted Windows 7 64bit Adding sequential Number in a document that already has merged fields inserted Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,891
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

All you need do is insert the class number followed by a hyphen then a MERGESEQ or MERGEREC field.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 01-17-2016, 04:49 PM
macropod's Avatar
macropod macropod is online now Adding sequential Number in a document that already has merged fields inserted Windows 7 64bit Adding sequential Number in a document that already has merged fields inserted Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,891
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

You also asked about this in another thread: https://www.msofficeforums.com/excel...l-numbers.html

Please don't ask what is essentially the same question in multiple threads.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 01-19-2016, 12:33 PM
Highlander01 Highlander01 is offline Adding sequential Number in a document that already has merged fields inserted Windows 10 Adding sequential Number in a document that already has merged fields inserted Office 2016
Novice
Adding sequential Number in a document that already has merged fields inserted
 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 14
Highlander01 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You also asked about this in another thread: https://www.msofficeforums.com/excel...l-numbers.html

Please don't ask what is essentially the same question in multiple threads.
Yes Paul sorry about that. I initially thought to do it in a word document then decided it would be easier to add a column to my spreadsheet and then add the merged filed to my word document.

Thank you very much for your help. I will try your solution.

Kind regards

Gordon
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding sequential Number in a document that already has merged fields inserted Turn OFF auto-adding file path as default alternative text for inserted objects Sergey SPb Drawing and Graphics 7 04-24-2017 11:25 PM
Can slides be inserted after adding narration? soula PowerPoint 0 02-04-2015 04:43 PM
Sequential Numbering on Tickets Multiple number Sequences skitchen Word 2 10-01-2013 06:41 AM
Labeling sequential forms with a unique number krau0231 Word 1 10-18-2012 03:33 PM
Adding sequential Number in a document that already has merged fields inserted Is there a limit to the number of labels that can be merged inOffice 2010 djsn Mail Merge 3 06-22-2012 05:52 AM


All times are GMT -7. The time now is 02:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft