Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Number Sequencing
Is it possible to force the merge sequencing to start at a number different
from 1? For example for various memos we do at work, they begin with 1 at the beginning of the year, and each note gets the next number. So if I want to merge a bunch of notes to various offices, I'd like to start with the next number in our note system, which could be 21, for example. Is there a way to tell the merge to start at 21, for example? So far I've only been able to get mergerec to start at 1. Thanks for your advice. Alison Lewis |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Number Sequencing
If the number isn't in the data source then your best bet is probably to
nest your MERGEREC field inside a formula (=) field that adds in a number that you could supply in various ways, e.g. using a FILLIN/ASK field, one of the built-in property fields which are easy to update using File|Properties. You would have to know which number you wanted to start with. e.g. { ={ MERGEREC }+{ FILLIN "Enter the first record number" \o } } Where all the {} are the special field braces you cn insert using ctrl-F9 Peter Jamieson "Alison" wrote in message ... Is it possible to force the merge sequencing to start at a number different from 1? For example for various memos we do at work, they begin with 1 at the beginning of the year, and each note gets the next number. So if I want to merge a bunch of notes to various offices, I'd like to start with the next number in our note system, which could be 21, for example. Is there a way to tell the merge to start at 21, for example? So far I've only been able to get mergerec to start at 1. Thanks for your advice. Alison Lewis |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Number Sequencing
Maybe you should be using the technique in the article "Creating
sequentially numbered documents (such as invoices)" at: http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Alison" wrote in message ... Is it possible to force the merge sequencing to start at a number different from 1? For example for various memos we do at work, they begin with 1 at the beginning of the year, and each note gets the next number. So if I want to merge a bunch of notes to various offices, I'd like to start with the next number in our note system, which could be 21, for example. Is there a way to tell the merge to start at 21, for example? So far I've only been able to get mergerec to start at 1. Thanks for your advice. Alison Lewis |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Number Sequencing
I've never used macros before, so I can't follow the article regarding
creating sequentially numbered documents. I tried to just paste in the AutoNew template that the article gives into a Macro (after I clicked Create under Macros), but I got an error. Do you have any insight on how to work with macros? Alison "Doug Robbins - Word MVP" ha scritto: Maybe you should be using the technique in the article "Creating sequentially numbered documents (such as invoices)" at: http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Alison" wrote in message ... Is it possible to force the merge sequencing to start at a number different from 1? For example for various memos we do at work, they begin with 1 at the beginning of the year, and each note gets the next number. So if I want to merge a bunch of notes to various offices, I'd like to start with the next number in our note system, which could be 21, for example. Is there a way to tell the merge to start at 21, for example? So far I've only been able to get mergerec to start at 1. Thanks for your advice. Alison Lewis |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Number Sequencing
I figured out a fix based on your article on the mailmerge. I just basically
merge the doc twice, saving it each time and using different sources each time. Works... Thanks, Alison "Doug Robbins - Word MVP" ha scritto: Maybe you should be using the technique in the article "Creating sequentially numbered documents (such as invoices)" at: http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Alison" wrote in message ... Is it possible to force the merge sequencing to start at a number different from 1? For example for various memos we do at work, they begin with 1 at the beginning of the year, and each note gets the next number. So if I want to merge a bunch of notes to various offices, I'd like to start with the next number in our note system, which could be 21, for example. Is there a way to tell the merge to start at 21, for example? So far I've only been able to get mergerec to start at 1. Thanks for your advice. Alison Lewis |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to limit the number of characters in a mail merge field | Mailmerge | |||
How do I make footnote numners static in a mail merge document? | Mailmerge | |||
How do I maintain number formatting in a mail merge? | Mailmerge | |||
Number of pages incorrect while doing mail merge | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge |