 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2006Re-number on a merge
Hi this is my first post on this forum so please be gentle. I am using Office 2000. I a merging to word from excel. the excel speet has various catagories some which are not populated. When I merge I need the populated cells to be numbered. If I use numbered bullet points it will miss out the numbers of cells not populated so, assuming cells 1, 3 and 4 are populated) I get data like: 1 First 3 Third 4 Forth Where what I need is 1 First 2 Third 3 Forth I have been told that the German version of word automatticaly re-numbers but I can't seem to get this to work in the English version. Any ideas or help please. Thanks.  Signaturemerger Hi Merger, > I am using Office 2000. > [quoted text clipped - 17 lines] > re-numbers but I can't seem to get this to work in the English > version. Ummm. Is this a catalog type of merge? Do you have any IF fields stuck in there somewhere? Are you merging to a new document, or directly to the printer? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) Hi, It is a catalogue type of mailing with 11 catagories and 11 products. No "If" fields or any other functions. I am merging directly to a printer however, if I needed to, I could merge to another document. Signaturemerger Is this numbering problem in Excel or in Word? Also, it's news to me that you can execute a catalog merge directly to a printer. I do not think that is possible, at least not with Word XP and later. My experience is that if in Excel you have the following in the cells in a column One Three Four where there is an empty cell between the One and the Three, if you merge that information into a Word document via a catalog merge and you apply numbering to the mergefield, what you will get is 1 One 2 3 Three 4 Four How are you going about getting 1 First 3 Third 4 Forth SignatureHope 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 > Hi, > [quoted text clipped - 4 lines] > I am merging directly to a printer however, if I needed to, I could > merge to another document. Hi Doug, In Excel I have a similar to this set up Name,Address1,Address2,Catagory1,Catergory2,Category3,Category4,Etc So imagine the fields populated but in the Categories some fields ar empty. So I merge using <<Category1>> <<Category2>> <<Category3>> Etc. In Word I have the numbered bullet points set against these fields Word then leaves out any unpopulated field but still seems to coun them so if Category 2 is empty I get 1 Category1 3 Catagory3 In the file I am dealing with I have 11 Categories and 11 Product which need the same treatment. The file also has 10,000 records bu this may go to 100,000 so I would like to get away with manuall getting rid of all of the blanks in the spreadsheet. Does this make sense? Thank -- merger In the merge, don't you get 1 Category1 2 3 Catagory3 That is what I get under those circumstances While it is still not really clear how you wish the data to be presented, given the volume of data you are talking about, I would be using Access and a report in Access. SignatureHope 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 > Hi Doug, > [quoted text clipped - 25 lines] > > Thanks I get this if I use autonumber but not bullet point numbering. I just need the data to be listed in 2 single columns, so basically as it is shown below. We do not have Access installed on the server!! Doug Robbins - Word MVP Wrote: > In the merge, don't you get > [quoted text clipped - 39 lines] > > Thanks Signaturemerger Hi Merger, OK, I think I'm following you... The reason the numbers appear to be "skipped" is because Word is automatically suppressing lines that contain ONLY a merge field, and that merge field is "empty". I can duplicate that behavior. Now, when I merge something like this to a new document, then lines with the "empty" fields are removed, and the document automatically renumbers. Try that? > In Excel I have a similar to this set up > [quoted text clipped - 21 lines] > > Does this make sense? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.