last numbers of the record dilbert firestorm <scanb31[ at ]bytemeati-55.com> 12/26/2008 7:46:15 AM is there anyway to include the last # of a record on a label? I'm trying to get the label to show as 1/10, 2/10,, etc. from a table. -- Dilbert Firestorm Opus is my Hero!

Re: last numbers of the record "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/26/2008 9:02:36 AM There is no way to do it using fields. Probably the easiest thing to do is just enter the number of records as a number. If the data source was Excel, you could add another column in each cell of which you inserted the Count() function. -- 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 "dilbert firestorm" <scanb31[ at ]bytemeati-55.com> wrote in message news:ZpudnaVuZt0rEcnUnZ2dnUVZ_j6dnZ2d[ at ]xfoneusa.net... [Quoted Text] > is there anyway to include the last # of a record on a label? > > > I'm trying to get the label to show as 1/10, 2/10,, etc. from a table. > > -- > Dilbert Firestorm > > Opus is my Hero!

Re: last numbers of the record Peter Jamieson <pjj[ at ]KillMAPSpjjnet.demon.co.uk> 12/26/2008 9:03:37 AM What type of datasource is your table? which version of Word? Peter Jamieson http://tips.pjmsn.me.uk dilbert firestorm wrote: [Quoted Text] > is there anyway to include the last # of a record on a label? > > > I'm trying to get the label to show as 1/10, 2/10,, etc. from a table. >

Re: last numbers of the record dilbert firestorm <scanb31[ at ]bytemeati-55.com> 12/26/2008 4:42:35 PM Peter Jamieson wrote: [Quoted Text] > What type of datasource is your table? which version of Word? > > > Peter Jamieson > > http://tips.pjmsn.me.uk > > dilbert firestorm wrote: > > is there anyway to include the last # of a record on a label? > > > > > > I'm trying to get the label to show as 1/10, 2/10,, etc. from a table. > > > Its Excel I think. I don't have access to the work computer, but it is part of the Microsoft Office package. -- Dilbert Firestorm Opus is my Hero!

Re: last numbers of the record dilbert firestorm <scanb31[ at ]bytemeati-55.com> 12/26/2008 4:51:48 PM Peter Jamieson wrote: [Quoted Text] > What type of datasource is your table? which version of Word? > > > Peter Jamieson > > http://tips.pjmsn.me.uk > > dilbert firestorm wrote: > > is there anyway to include the last # of a record on a label? > > > > > > I'm trying to get the label to show as 1/10, 2/10,, etc. from a table. > > > my mistake. I'm doing this off of a word processor. Its microsoft word, not excel. I don't remember what version of word it was. the data source is mostly dates & numbers. there is a mail merge switch that sort of lets you append a text to the mailmerge field, but the thing is I'd have to cut & past for each table cell if I remember to do this. If I don't, the labels are wasted. -- Dilbert Firestorm Opus is my Hero!

Re: last numbers of the record "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/26/2008 8:27:35 PM If you know the number of records, you have type it (and any other text that you require onto the first label of the sheet, and then use the "Update labels" facility to propagate the set up of that label to the other labels on the sheet. -- 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 "dilbert firestorm" <scanb31[ at ]bytemeati-55.com> wrote in message news:7fGdnU8VU4edkMjUnZ2dnUVZ_hCdnZ2d[ at ]xfoneusa.net... [Quoted Text] > Peter Jamieson wrote: >> What type of datasource is your table? which version of Word? >> >> >> Peter Jamieson >> >> http://tips.pjmsn.me.uk >> >> dilbert firestorm wrote: >> > is there anyway to include the last # of a record on a label? >> > >> > >> > I'm trying to get the label to show as 1/10, 2/10,, etc. from a table. >> > >> > my mistake. I'm doing this off of a word processor. Its microsoft word, > not excel. I don't remember what version of word it was. the data source > is mostly dates & numbers. > > there is a mail merge switch that sort of lets you append a text to the > mailmerge field, but the thing is I'd have to cut & past for each table > cell if I remember to do this. If I don't, the labels are wasted. > > -- > Dilbert Firestorm > > Opus is my Hero!

Re: last numbers of the record Peter Jamieson <pjj[ at ]KillMAPSpjjnet.demon.co.uk> 12/26/2008 11:06:42 PM If the data source is Word, there's no particularly easy/automatic way to get the record count - you may be able to find it in Edit Recipients fairly easily and insert it in the Mail Merge Main document, but that's about it. (For other types of data source you can consider inserting a DATABASE field, outside the table of labels, that does a SQL SELECT count(*) FROM thedatasourcetablname, but even that will not help if you are doing selections in Edit Recipients). Peter Jamieson http://tips.pjmsn.me.uk dilbert firestorm wrote: [Quoted Text] > Peter Jamieson wrote: >> What type of datasource is your table? which version of Word? >> >> >> Peter Jamieson >> >> http://tips.pjmsn.me.uk >> >> dilbert firestorm wrote: >> > is there anyway to include the last # of a record on a label? >> > > > I'm trying to get the label to show as 1/10, 2/10,, etc. from a >> table. >> > > my mistake. I'm doing this off of a word processor. Its microsoft > word, not excel. I don't remember what version of word it was. the > data source is mostly dates & numbers. > > there is a mail merge switch that sort of lets you append a text to the > mailmerge field, but the thing is I'd have to cut & past for each table > cell if I remember to do this. If I don't, the labels are wasted. >

Re: last numbers of the record dilbert firestorm <scanb31[ at ]bytemeati-55.com> 12/26/2008 11:15:01 PM I don't have access to word as I'm on vacation, but will this idea work? make another column and use that column for the number since I know the exact # from the inventory. the entire column would be filled with "13" as last number. This prolly would work. Is there a better way to do this? Peter Jamieson wrote: [Quoted Text] > If the data source is Word, there's no particularly easy/automatic way > to get the record count - you may be able to find it in Edit Recipients > fairly easily and insert it in the Mail Merge Main document, but that's > about it. (For other types of data source you can consider inserting a > DATABASE field, outside the table of labels, that does a SQL SELECT > count(*) FROM thedatasourcetablname, but even that will not help if you > are doing selections in Edit Recipients). > > Peter Jamieson > > http://tips.pjmsn.me.uk > > dilbert firestorm wrote: > > Peter Jamieson wrote: > >> What type of datasource is your table? which version of Word? > >> > >> > >> Peter Jamieson > >> > >> http://tips.pjmsn.me.uk > >> > >> dilbert firestorm wrote: > >> > is there anyway to include the last # of a record on a label? > >> > > > I'm trying to get the label to show as 1/10, 2/10,, etc. from a > >> table. > >> > > > my mistake. I'm doing this off of a word processor. Its microsoft > > word, not excel. I don't remember what version of word it was. the > > data source is mostly dates & numbers. > > > > there is a mail merge switch that sort of lets you append a text to the > > mailmerge field, but the thing is I'd have to cut & past for each table > > cell if I remember to do this. If I don't, the labels are wasted. > > > -- Dilbert Firestorm Opus is my Hero!

Re: last numbers of the record "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/27/2008 8:41:40 AM Is this any easier than manually inputting the number and re-propagating the labels? The problem with editing the data source in this way is that it only works if you merge the full data source. It completely falls apart if you only merge part of the data. One possibility is to store the variable number in a docvariable and use a docvariable field to display the total record count.e.g. { MERGEREC }{ DOCVARIABLE varLabelCount } Use the following macro to update the docvariable before running the merge to produce 1/229 Dim oVars As Variables Dim sAsk As String Dim i As Long Set oVars = ActiveDocument.Variables sAsk = InputBox("Total number of labels for this merge", "Labels") oVars("varLabelCount").Value = _ "/" & sAsk For i = ActiveDocument.Fields.Count To 1 Step -1 With ActiveDocument.Fields(i) If .Type = wdFieldDocVariable Then .Update End With Next i http://www.gmayor.com/installing_macro.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> dilbert firestorm wrote: [Quoted Text] > I don't have access to word as I'm on vacation, but will this idea work? > make another column and use that column for the number since I know > the exact # from the inventory. the entire column would be filled > with "13" as last number. This prolly would work. > > Is there a better way to do this? > > Peter Jamieson wrote: >> If the data source is Word, there's no particularly easy/automatic >> way to get the record count - you may be able to find it in Edit >> Recipients fairly easily and insert it in the Mail Merge Main >> document, but that's about it. (For other types of data source you >> can consider inserting a DATABASE field, outside the table of >> labels, that does a SQL SELECT count(*) FROM thedatasourcetablname, >> but even that will not help if you are doing selections in Edit >> Recipients). Peter Jamieson >> >> http://tips.pjmsn.me.uk >> >> dilbert firestorm wrote: >>> Peter Jamieson wrote: >>>> What type of datasource is your table? which version of Word? >>>> >>>> >>>> Peter Jamieson >>>> >>>> http://tips.pjmsn.me.uk >>>> >>>> dilbert firestorm wrote: >>>>> is there anyway to include the last # of a record on a label? >>>>>>> I'm trying to get the label to show as 1/10, 2/10,, etc. from a >>>>>>> table. >>>>> >>> my mistake. I'm doing this off of a word processor. Its microsoft >>> word, not excel. I don't remember what version of word it was. the >>> data source is mostly dates & numbers. >>> >>> there is a mail merge switch that sort of lets you append a text to >>> the mailmerge field, but the thing is I'd have to cut & past for >>> each table cell if I remember to do this. If I don't, the labels >>> are wasted.