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: 18
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 offline 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: 21,956
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

All you need do is insert the class number followed by a hyphen then a MERGESEQ or MERGEREC field.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-17-2016, 04:49 PM
macropod's Avatar
macropod macropod is offline 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: 21,956
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

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
[Fmr 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: 18
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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:15 AM.


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