| Mail Merge Next Record IF 1 of #, 2 of #, 3 of # Posted: 05 Feb 2014 02:47 PM PST I have a spreadsheet that lists items, total amount of those items, and then calculates the number of boxes needed to ship particular items depending on how many items fit in the box. The recipient wants labels on each of the boxes. So if they want 100 of a product that fit 10 in a box, the label would need to have:
Item: «Description» P.O. «PO» – Box 1 of «Boxes»
But I would like the merge to say "Box 1 of 10" and then merge to "Box 2 of 10", "Box 3 of 10", "Box 4 of 10" etc.
I would like a page break at the end of each new box # amount. Box #s vary, but I would be happy to have up to 10 figure out, and I can cut/paste and search/replace for higher #s (which is what I do now... lots of cut/paste, search/replace.
I have played with this, making a merge with a different page for each # of boxes and set it up as something like:
«Next Record If Boxes is = 2» Item: «Description» P.O. «PO» – Box 1 of «Boxes»
Item: «Description» P.O. «PO» – Box 2 of «Boxes»
I just can't seem to figure out how to get it to do what I'd like to do. Any help to save me tons of time would be greatly appreciated!! |
| Microsoft Word-- This document could not be registered. It will not be possible to create links from other documents to this document. Posted: 05 Feb 2014 02:42 PM PST A while ago, I started getting the message in the title for SOME documents. I just repaired my Office Home and Student 2010 (incl. Service Pack 1), and it did NOT help.
What can I do to solve this problem?
I have Windows 7 Ultimate 64-bit.
Thanks for any suggestion,
Hans L
|
| PowerPoint slide number changes when pasted into Word Posted: 05 Feb 2014 01:02 PM PST I don't see this particular issue in any of the posts. I apologize if it has been answered; please point me
This is MSO 2013 on Win8 (64bit)
I have a PPT presentation. I have put the slide number in the lower right corner of each slide using the Insert. The slide numbers are correct; if I move a slide within the deck, its number changes correctly (and all other slides' numbers change correctly)
I right-click-copy an individual slide and paste-special (picture enhanced metafile) into a Word document. The slide looks fine, but the slide number in the lower right corner of the slide is changed. It doesn't matter which 'special' paste format I use, nor does it matter where in the Word document I paste the slide; the number is changed.
If I right-click-copy, paste-special a different slide, its number is also changed, but not to the same number as the first slide.
If I paste-special the slide into a different Word document, its number is changed to the same value as when pasted into the first Word document.
I have to assume it has something to do with the way that I'm specifying the slide number, but I'm following the instructions, namely: - while viewing the slide, click Insert. Select Slide number. on the picture, check slide number, then Apply to All
I have to say that this did not happen with MSO 2007 on Win 7 (64) which was my previous platform. Both the PPT deck and the Word document were originally created on that platform and moved to the new platform.
thanks,
|
| Page break in Word 2003 Posted: 05 Feb 2014 12:31 PM PST I have a word 2003 document with text boxes on page one and cannot get the cursor placed at the end of the page to insert page 2.
How do I insert a page break?
|
| Bug in <range>.MoveUntil Method (Word 2013) Posted: 05 Feb 2014 12:30 PM PST Consider the following code segment: <code> Do While rngCurrent.Start < iEnd ' iEnd is set to rngCurrent.end
If rngCurrent.Characters(1) = Chr$(32) Then
' found a blank.
Else
k = rngCurrent.Start
nChars = rngCurrent.MoveUntil(Chr$(32), wdForward) ' find the next blank
j = rngCurrent.Start
MsgBox "Before " + Str$(k) + " after " + Str$(j)
wCount = wCount + 1
End If
Loop </code> One expects j = k + nchars - 1 But run the code and I find that j is actually equal to rngSelect.end + nchars - 1. nChars is being returned correctly. Is this behaving as designed? |
| Word 2010 - line between columns is not being displayed Posted: 05 Feb 2014 12:23 PM PST I created a new document with two equal columns. In the Columns dialog box I selected Line between and whole document. The line does not display. I tried closing Word and opening it again. I tried to find some hidden Option in Backstage View that I might need to select - no luck.
Can someone give me some guidance as to what to try next? Thanks.
|
| Problems converting docx to PDF Posted: 05 Feb 2014 11:47 AM PST Help !! After many years I have finally finished writing my thesis - which is about 300 pages long with a number of tables and figures in it. In order for it to get printed I need to convert it to a PDF document from word. However, whenever I use the save as PDF file on word (either word 2010 or word 2007) something happens to the PDF document that is created. On various pages the text is affected: sometimes a figure is put in the middle of the text (when it should be in that place) or the text suddenly stops in the middle of a line. It seems to happen at the same points in whichever version of my thesis I use and whether the document is a doc or a docx. I am tearing my hair out trying to work out what to do next.
Can anyone help??? I'd be most grateful for any advice.
|
| Letterhead template header issues Posted: 05 Feb 2014 11:43 AM PST Ok so heres the issue. I am creating a letterhead template for a client. I have her logo sitting flush in the top left hand corner of the header, with her business name in the top right hand. In the footer I have her contact info and a red bar running across the bottom. In print layout while im working, it looks perfect. However when I click print, the logo in the header drops down and to the right about an inch each way leaving white space. The company name in the top right gets cut off. My red bar on the bottom disappears completely, and the contact info gets cut off. Any ideas? |
| Where to download Chinese(Simplified) Proofing tool for Office 2013 on Surface RT Posted: 05 Feb 2014 11:36 AM PST I can only find the proofing tool for normal Windows, which is .exe file. It won't run on Surface RT. Can someone help me find the link to the one that supports surface RT? Thanks
P.S. It's for Word |
| Product Key Posted: 05 Feb 2014 11:14 AM PST My laptop was running slow, so I had the whole thing formatted. It's running Vista Home Basic. I used Word 2007 a few times without any problem. Now, when I try to use Word, it asks for the 25 digit product key. If no key entered, I'm told Word may operate with some functionality missing. It will open a new document up, but will not transfer keyboard strokes to the page. When I input it,(Product Key), I'm told it's the wrong key. This is the number off the Microsoft label on the bottom of the laptop. I can't figure out what's wrong? Mo |
| Find in Word 2007 does not find the next instance in the document... Posted: 05 Feb 2014 11:05 AM PST I am trying to revise numerous footnotes in a document that all contain similar information. I want to use FIND to go through these footnotes by turn, so I can find the first one in the document, edit it, then find the next one and so on. I have done this without any problems before. Now for some reason it FINDs the first instance OK but then insists on jumping to a footnote near the end of the document when I ask it to FIND NEXT, rather than going to the next one containing the text. I have tried changing the settings from "find all" to "find down" but that hasn't made any difference. Can anyone advise me why this is happening and how to fix it, please?
|
| Capitalizing I in Word spellcheck Posted: 05 Feb 2014 10:18 AM PST This just started happening and was working fine before. When I type the letter 'i' and then do a spell check, it used to bring up the first option to change it to as "I" (capitalizing it). Now, all of a sudden, that's not even listed as an option anymore, the first option is "it". So, I have to go back and change all of them individually. I CANNOT have autocorrect or replace as I type options checked because it would often times autocorrect with the wrong words. Something happened between now and two months ago when this started happening. I made no changes to my spelling options and it's been working fine for over a year. Microsoft sent me instructions but none of which can help because I can't have autocorrect and replace this with this options. Why all of a sudden would capital "I", which would be the logical choice for being the first option to replace "i", disappear? If anyone can help, I would greatly appreciate it! |
| Format changes when changing Quick Styles Posted: 05 Feb 2014 10:18 AM PST I have Office 2007 running in Windows 7. I create documents in two different styles using Office Word. One document uses the following settings:
Page size is 5.25" X 7.25", margins are .5" X .5" X .5" X.5, the main font is Garamond 12, and paragraphs are justified. This style set is saved as Set - RTF.
The second set is saved as Set - PDF with only the following changes: page size is changed to Letter and the main font is Bell MT 20.
I create the original document using the RTF settings and after it is saved I then open the PDF set to change over the styles used in the document. Always before everything has stayed the same until I select the RTF style and change it to the PDF one, then remove the RTF before saving the document in it's new format. I had problems with my computer starting a couple of mornings ago and now every time I try to work on a document when I open the PDF styles all of my paragraphs go from justified to left. I ran a repair cycle on my Office program but it's still doing it. Can anyone tell me what is going on and how to fix it? I really need that original formatting to stay put until I change it.
|
| Microsoft office Posted: 05 Feb 2014 10:12 AM PST When I try to click on documents, a sign comes up that says "office is busy" try again later. What do I need to do? |
| Filesize crashes with all the images in *.docx Posted: 05 Feb 2014 10:08 AM PST I've got a .docx file where anything I place-in to it: it losses all or part of the images (they're visible as errors on screen).
File is: https://mega.co.nz/#!oQsDERRY!mTAWQezanxDJuwtwjbH9xTwnmO4MpqrOLzSxLh1FcUI
What TO DO?
It just happens with ALL the previous files, as such. I just don't know what to do.
It just reduces ALL the images. I've replaced them manually in the past, but a better solution has to be proposed as it's simply too much and saving all of them from previous document just doesn't makes sense (I rather won't have original copies of them).
I've checked every other solution. |
| Printing Hebrew characters and Pictures on same page. Posted: 05 Feb 2014 10:03 AM PST Why can't I print Hebrew characters and pictures on same page? One will print and not the other. However, they will not print at same time, on same page. |
| Documents revert back to read only after they have been used Posted: 05 Feb 2014 10:00 AM PST I have a home network between my Windows 7 and Windows XP. After several problems (I was scammed and then picked up some Malware, which has been removed) everything is almost fixed. However my documents in the Windows 7 are constantly reverting back to Read Only. They were all read only so I could do nothing with them but now I can turn the read only off. I don't remember how I did this. However, the next time I go to that document it is read only again and I have to turn it off constantly. How can I get this to stop?
I also have a nuisance message from WORD that pops up and asks me if I'm sure I want the program to allow changes to the hard drive on my computer every time I open WORD. Can someone help? |
| Templates in Word Posted: 05 Feb 2014 09:18 AM PST Ok i create templates for my work in Word 2007 and i use to be able to create the template and when i saved it save the printer settings so when i use the template it prints to letterhead without changing the printer options to letterhead only for that template. I now have to manually select letterhead each time i use the template instead of having it done automatically, and once done i have to make sure i either change the printer settings back to unspecified or close out word completly. Can anyone help me with this???? |
| Word 2010 dialogBoxLauncher Posted: 05 Feb 2014 09:09 AM PST Hi, I create a group in a custom tab using the Custom UI Editor, in that group I added a dialogboxlauncher. How can I activate the dialogboxlauncher so that it will launcher the group window when I click the down arrow? Any help is appreciated. <group id="customGroup" label="Style" > <button id=........... etc /> <button id=........... etc /> <button id=........... etc /> etc <dialogBoxLauncher > <button id="Group" /> </dialogBoxLauncher> Thanks, Steve |
| Track Changes Posted: 05 Feb 2014 08:56 AM PST Hi , I received an e-mail attachment Word 2007 document with tracked changes - which I accepted. However, now the pages of the document with changes will not print out for me, and will not show up in Print Preview mode. I have tried rejecting the changes but that is having no effect. I could re-type this one document but the problem is the Tracked Changes seems to have affected 38 other documents I did over the past week and I really am up against deadlines so do not have time to redo an entire week's work. Can anyone help. Thanks, Shirley |
| Word 2010 start up/installation/reboot issues Posted: 05 Feb 2014 07:21 AM PST I'm running Windows 7 and I've owned/used Word 2010 for the past several years. Today, I went to open Word and it says it has to apply updates, configure, etc.
...then is says the system must reboot in order to apply updates. I click "yes" and reboot and the cycle begins anew. I try to open Word, it says it has to apply updates, configure, reboot...
What have I done to this program and how can I correct it?
|
| How can you determine your exact position on the page like you could in WordPerfect? Posted: 05 Feb 2014 06:50 AM PST I have had some things I needed to do in Word where I needed to know my exact position on the page vertically or horizontally (like what line I'm on on the page or my horizontal position on the page so I could match it) but cannot figure out if I am able to see that in Word. This feature was a regular feature in WordPerfect 5.0 & 5.1 which I used to love. EVERY single position vertically & horizontally had a position number. Is there a way to determine that in Word? As a page layout designer I really need this feature? Does anyone know what I'm talking about and if Word does this at all and how I can turn it on if it does? Sorry if my words seem jumbled but having a hard time describing what I'm talking about. I used Word 03 & 10
Thank you |
| Cursor suddenly vanishes in the middle of typing on the key board of my Lenovo Desktop with Windows 7 Posted: 05 Feb 2014 05:26 AM PST Cursor suddenly vanishes in the middle of typing on the key board of my Lenovo Desktop with Windows 7. Suddenly when i look up I find that half of what I had typed never got entered in the word document or even email. This is very frustrating because I do two finger typing while looking at the keyboard.... need fix ASAP. thanks |
| Heading 1 Fonts and TOC Posted: 05 Feb 2014 05:02 AM PST Hallo aus New Jersey, My OS is Win Vista Business with MS Office Word 2007(12.0.6690.5000) SP3 MSO(12.0.6683.5000). I'm in the process of translating Deutshe Kultur from German to English. My Heading 1 and TOC works fine with default settings (Cambria(Headings) Font Size=14) but when I modify some parts of the text of my Heading 1 data(change font size as noted below) the change appears ok in the Heading 1 line but when I update the entire contents of my TOC it continues to display default settings font size. Is this normal? If so, can I just manually modify the text directly in my TOC? Example: Original Heading 1: FRIEDRICH DER GROSSE (1712-1786) - Gustav Freytag (1816-1895) TOC: FRIEDRICH DER GROSSE (1712-1786) - Gustav Freytag (1816-1895) Change Heading 1: FRIEDRICH DER GROSSE(1712-1786) – Gustav Freytag(1816-1895) TOC: FRIEDRICH DER GROSSE (1712-1786) - Gustav Freytag (1816-1895) Dates are not raised as shown in my Change Example ... guess the MS Community text editor did that when I copied/pasted from my document. Change Details: FRIEDRICH DER GROSSE (Cambria(Headings) Font Size=14) (1712-1786) (Cambria(Headings) Font Size=8) – Gustav Freytag (Cambria(Headings) Font Size=12) (1816-1895) (Cambria(Headings) Font Size=8) Thanks for your assistance! Joe |
| Equation Editor in microsoft office (word) 2013 is not showing equations properly . Posted: 05 Feb 2014 04:56 AM PST my microsoft word is not showing equation properly. Show different symbols instead of the symbols used in the equation. as attached in the below pic you can see that what happened with the equations. plz help me thanks.  |
| autotext Posted: 05 Feb 2014 04:42 AM PST We have an enormous amount of autotext which is in Word 2003 which will want to transfer into building blocks in Word 2010. Is there a way of extracting all autotext either into a document or printing off so that I can recopy it into the new version when it is installed ? Would be grateful for some help please. Margaret |
| Office 2013 0-3%CPU use Posted: 05 Feb 2014 03:01 AM PST as the title says, my office 2013 only uses 0-3% of the CPU, ALWAYS so, when doing anything, the CPU usage of the program never goes over 3% which also causes lag when doing anything on the document
comp spec Intel Core i5 3.2GHz 4GB ram Windows 7 x64 Microsoft Office Professional Plus 2013 x64 |
| Word 2010 Template with macros on network location not working Posted: 05 Feb 2014 01:22 AM PST Hi everyone, I have done extensive searching on this subject and have tried all the suggestions but I can't for the life of me get it to work.
I have created a template on a network location that can be accessed by other users within my group. This template contains a userform and some macros.
However, whenever I try to open the file, I receive the error "The macros in this project are disabled. Please refer to teh online help or documetation of the host application to determine how to enable macros".
In my main Word window, I get the Security Warning "Macros have been disabled." I cannot click the "Enable Content", as when I click the "OK" button in the message box, the yellow bar disappears.
I have tried adding the network location as a trusted location including using the full address (\\networkshare\ etc) but to no avail. The check boxes for "Allow network locations to be trusted" are all enabled.
I've run out of ideas. I don't want each user to take a copy of the file and save it locally in case I need to make some changes.
Are there any external factors that would prevent the macros opening? I believe it's not wise to "Enable all macros".
Thanks
|
| Creating Links to Specific Words Posted: 04 Feb 2014 08:07 PM PST Hello, Hope all is well. I generate a financial report every month comparing actual results to budget & I update a word doc narrative explaining variances to plan. The language doesn't really change month to month & I make references to the month end throughout the document.
Is it possible to create a reference link to a specific word? For example, if I change the month end date from December 31, 2014 to January 31, 2014 then all linked words would update as well? |
| Linking to Specific Cells in an Excel Workbook Posted: 04 Feb 2014 08:01 PM PST Hello, Hope all is well. I generate a financial report every month comparing actual results to the plan & I update a word doc narrative explaining variances to plan. The language doesn't really change month to month & I would love to set up some links in word so that balances update.
Is it possible to create a reference link to a specific cell in an excel workbook? Thus if the number in the cell changes then the number in my word document updates & changes as well?
So in the following statement, "the change of $50 million was driven by XYZ" The $50 million is linked back to an Excel workbook? |
| Microsoft Word Document with Works Spreadsheet in it Posted: 04 Feb 2014 06:50 PM PST I have a word document with a Works spreadsheet in it. I just bought a new computer with Windows 8 and Office 2013. I can open the word document but when I try to open the spreadsheet to edit I get this error.
The server application, source file, or item cannot be found. Make sure the application is properly installed, and that it has not been deleted, moved, or blocked by policy.
Any suggestions? |
| Turn OFF screen updating Posted: 04 Feb 2014 06:16 PM PST Hi,
I am using...
Application.ScreenUpdating = False
To stop screen updating, but where my Macro is updating Tables, the screen still changes.
Is their a way of turning off screen updating, so that whatever I am doing the screen truly does not update?
Thanks, Neil |
| MS Word 2010 -> Convert to PDF -> Ctrl + F (Find a word) doesn't work in the converted PDF file. Posted: 04 Feb 2014 05:17 PM PST Hello. I had earlier posted this issue, but answer wasn't quite solving this problem. I guess my question was not clear enough, so I'm re-uploading this issue with visual aids. 1) make a .txt file in MS word. 
2) Save as PDF 
3) Open the PDF and try to find a word through CTRL+F (Doesn't work) 
I hope this would be easy enough to understand. As it's seen, After converting .txt file into .pdf file through 'MS 2010 Word' and opening the .pdf file through 'Adobe Reader', CTRL + F doesn't work. Some of you can think this might be caused by 'Adobe Reader', but this issue occurs only in MS 2010 Word. It means it does work when we use MS 2007 Word for conversion with same 'Adobe Reader'. (CTRL +F works fine) Your support would be highly appreciated. Thank you |
| Word 2010 "I have four macros doing the same requirement" Posted: 04 Feb 2014 04:10 PM PST Hello from Steved
I need a little help please I have four macros doing the same requirement, Can I have a single macro, Thank you in Advance
From This
3 BLINDED BY DELI 78
To the Below
3 BLINDED BY DELI R45 78
They are MoveRatings, MoveRatings2, MoveRatings3, MoveRatings4
For MoveRatings I have .Text = "[A-Z]@>" finding a single word only For MoveRatings2 I have .Text = "[A-Z]@> [A-Z]@>" finds Two words. For MoveRatings3 I have .Text = "[A-Z]@> [A-Z]@> [A-Z]@>" finds Three words. For MoveRatings4 I have .Text = "[A-Z]@> [A-Z]@> [A-Z]@> [A-Z]@>" finds Four words.
Sub MoveRatings()
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "R[0-9]{1,}"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True
End With
Selection.Find.Execute
Selection.Cut
Selection.HomeKey Unit:=wdLine
Selection.MoveUp Unit:=wdLine, Count:=1
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "[A-Z]@>"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchAllWordForms = False
.MatchSoundsLike = False
.MatchWildcards = True
End With
Selection.Find.Execute
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.TypeText Text:=" "
Selection.PasteAndFormat (wdFormatOriginalFormatting)
Selection.Delete Unit:=wdCharacter, Count:=4
End Sub
|
