| Mail Marge with more than one record to a page Posted: 01 Feb 2014 02:44 PM PST I've made a mail merge that sends out an email to suppliers telling them that their invoice has been rejected for whatever reason and needs to be resubmitted. The simple mail merge I've done means that for each rejected invoice an email is sent out, so if a supplier had five rejected invoices they would get five separate emails. Is it possible to make the mail merge so it would only send out one email per supplier with all of their rejected invoices on? The number of rejected invoices per supplier varies so this wouldn't be a fixed number.
I've had a look on some of the previous discussions but I can't find anything that would help me. Many people have suggested add-ons to other users but this isn't an option that would work for me as I'm running the mail merge from a work pc and can't put add-ons onto it.
I did think something like this would help http://support.microsoft.com/default.aspx?kbid=212375 but my knowledge of codes etc isn't very good and I can't even get the { } brackets to appear so I didn't get very far with this, but the idea of having a check column did seem to be a good idea, I'm just struggling to implement it!
Any help would be greatly appreciated!
Thank you |
| Headers & Footers Posted: 01 Feb 2014 02:31 PM PST I want to create a different header on odd/even pages. I go to header, click on editing and click on different odd/even pages. Great. It works but at the same time it automatically changes my footer (to different footer on odd/even pages). I don't want different footers for the page numbers.
It there some way to unlink the two?
Thank you,
Mitch |
| How to Preserve Portions of "Find" Value Posted: 01 Feb 2014 01:45 PM PST I'm confused about some wildcard functionality in Word. I'm searching this value:
([a-z])^13([A-Z])
in an attempt to find all instances where there is a lowercase letter followed by a paragraph mark followed by an uppercase letter.
Here's an example:
would hold in the new Labor Cabinet, and they were surprised when I giggled.
I need to remove the paragraph mark, add a space, but retain all of the text of the words "new Labor."
I thought that I should just use " \1" in the Replace With text box but that results in ..."would hold in the neabor Cabinet, and they were surprised when I giggled."
I tried using some VBA like this but it also did not work:
Sub RemovePmarkAddSpace() ' ' RemovePmarkAddSpace Macro ' ' Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "^13([a-z])" .Replacement.Text = " \1" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll End Sub
Suggestions? |
| Microsoft office wont open. Posted: 01 Feb 2014 01:25 PM PST I tried to get into my documents also and they would not open. I went to programs and features like the pop up said to and looked for the repair button but all I can find is the uninstall button. Help please, thank you. |
| file size suddenly huge Posted: 01 Feb 2014 01:21 PM PST word file, one big table--8k entries, no graphics. after several table operations today involving only the addition of a few entries, my word file has grown from 1Mb to 13Mb. I've done everything I know re cleaning the file--no embedded fonts, inspected and removed all hidden, etc. a ny thoughts? |
| How Do I Find a Restored Document? Posted: 01 Feb 2014 01:20 PM PST I accidentally deleted a document, so I went to my recycle bin to restore it. When I hit restore, it said the document recovered in Word. I went into Word to look for it, and it wasn't there. Is there anything else I need to do? I also double checked the recycle bin, and it wasn't there either. It's also not in my Documents Recovered pane. This essay is due on Monday, so I need help quickly! |
| Printing linked documents from a master page Posted: 01 Feb 2014 12:51 PM PST I have a "master" page Word document into which I have inserted links to "chapter" Word documents. When I edit the master page, I see only icons for the linked documents as well as a little but of ancillary text. This is exactly what I want in an editting mode. But when I attempt to print the whole work (all chapters in the linked order), Word only offers to print the single master page with its icons.
Can I use the master page to cause the whole of the text work, and, if so, how?
Price Buhrman
|
| Office 2013 menus look too big on Surface Pro screen Posted: 01 Feb 2014 12:41 PM PST Hello,
I've recently installed Office 2013 on my Surface Pro. To my disappointment, I cannot find a way to customize menus appearance in any of the softwares included. The worst of it all is Word menus, in which the fonts look gigantic and get cropped in weird ways. Here's a printscreen, so you get the idea (menus are in portuguese):
Note the difference between the file name font size (upper header), and the menu fonts!
Is there a way to adjust that, that doesn't involve changing the screen resolution?
I appreciate any help.
|
| MS WORD, ON INSERTING A SCANNED DOC OR PICTURES Posted: 01 Feb 2014 11:56 AM PST I USED TO BE ABLE TO INSERT ON WORD A PICTURE OR IMAGE FROM THE SCANNER. NOW, WHEN INSERTING AN IMAGE, IT DOES NOT SHOW THE SCANNER AS ONE OF THE SELECTIONS ON WHERE TO GET THE SOURCE. HOW WILL THIS BE DONE THIS TIME? |
| Changing centimeters to inches in Word 2013 Posted: 01 Feb 2014 11:54 AM PST Does anyone know how to change cm into inches in in Word 2013 pagelayout/margins?
|
| Problem with Ink Tools Posted: 01 Feb 2014 11:35 AM PST I have the Surface Pro and Office 365. When I try to use the change the color of the pen (Ink Tools), the "More Ink Colors" option is grayed out. I need to select a color from that set of options or change the standard colors |
| Macro for header in Office 365 Posted: 01 Feb 2014 10:15 AM PST Hello,
I am trying to make macro in Office 365 to add my last name and page number in the top right header. I can't seem to get it to work correctly. It gives me run time error '5941', when I try to run it.
I apologize if it's messy coding, I'm not exactly sure which lines I can delete.
Thanks for the help! Here's what I have:
Sub Macro2() ' ' Macro2 Macro ' ' If ActiveWindow.View.SplitSpecial <> wdPaneNone Then ActiveWindow.Panes(2).Close End If If ActiveWindow.ActivePane.View.Type = wdNormalView Or ActiveWindow. _ ActivePane.View.Type = wdOutlineView Then ActiveWindow.ActivePane.View.Type = wdPrintView End If ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader Application.Templates( _ "C:\Users\username\AppData\Roaming\Microsoft\Document Building Blocks\1033\15\Built-In Building Blocks.dotx" _ ).BuildingBlockEntries("Plain Number 3").Insert Where:=Selection.Range, _ RichText:=True Selection.TypeText Text:="Lastname" End Sub
|
| How to get List style when I type in "1." then hit Enter Posted: 01 Feb 2014 07:40 AM PST When I start to type in a list, all I've ever done is type in "1.", then enter the text. Hitting the Enter key will then format that text as a list style, and give me a "2." to start the next line.
Now, however, when I do this, I get the numbers, but the text (after each number) starts a good inch or so away from the numbers. Also, the numbers themselves are not indented. And the style is Body Text.
How do I get Word 2010 to automatically format this text in a List style.
|
| Word 2010 Headings problem with final level digit Posted: 01 Feb 2014 04:11 AM PST Hi, I have a problem with my list Headings in Word. I want it to display:
1 1.1 1.2 1.2.1
etc
if I put Heading 2 straight after Heading 1, then it is fine. But if I have text in-between, I get:
1 text 1.2
Even if I don't have text between Heading 1 and Heading 2, when I go to the next level I get: instead of 1.2.1
I have tried going into the numbering and setting the list level number to 1 (it shows 2), but then all the indenting and formatting goes wrong and the whole document looks a mess. I have worked with the same template for years and have never had this problem, but now even my base template file is showing the problem and on both my computers.
Help please! |
| Microsoft Word won't automatically capitalise the first letter of each sentence i have to do it manually Posted: 01 Feb 2014 03:49 AM PST Whenever i write a sentence, all the letters are in lower case... I've tried to do the select all and sentence case each word but once i write more afterwards it doesnt work for those sentences. It's really annoying to have to do this for the first word of every sentence does anyone know how i can solve this problem? Thanks! |
| Keep getting error message about macros when I run Microsoft Word 2007 (I have Windows Vista) Posted: 31 Jan 2014 10:06 PM PST I keep having this problem when I run Word 2007 (I can still create documents, etc., but I have to try to close the darned error message several times):
|
| printing only comments in Word 2010 Posted: 31 Jan 2014 08:58 PM PST We've been using both Adobe Acrobat 11 professional and Word 2010 (Office 2010). I discovered that when working with Adobe Acrobat it is NOT possible to print only the comments added to a document; you wind up with the comments, and references to highlighting, and it prints this information out by page where the highlighting and comments (sticky notes in other parlance) appear. Very awkward and not useful.
So then I had the bright idea of converting the PDF to Word, and doing the commenting in Word. I'm unclear, however, if it's possible to print only the comments (not highlighted text), and to print them on one page (or however many pages it takes to gather and print the comments). Is it possible to do this?
The bookmark feature in adobe acrobat is really quite useful, but I use the bookmarks I make as an informal outline, but discovered that you can't simply print that outline/bookmarks in Adobe. (The workaround there is a screencapture and print).
Thanks! |
| Office 2013 Posted: 31 Jan 2014 08:18 PM PST Ever time I update or run system check my office 2013 disappears? |
| Combine Documents With Tracked Changes Posted: 31 Jan 2014 05:50 PM PST I have two documents. Document 1 has Tracked Changes and Comments. Document 2 has Tracked Changes that are different from the Tracked Changes in Document 1.
Is there away to combine the Tracked Changes in Document 2 with the Tracked Changes in Document 1 and have a Document that still shows both Tracked Changes? I have tried using the Combine command but that command forces one set of Tracked Changes to become accepted thereby losing them in the Combined document.
Any help would be greatly appreciated. |
| Word says no network. Everything else doesn't have a problem Posted: 31 Jan 2014 04:46 PM PST When I click the link to activate via the Internet, an alert box pops up telling me I have no network connection. Obviously I do, since I am using that connection to post this. How can I get Word on board with the program here?
|
| Table of Figures generated by "Insert Table of Figures" - is incorrectly (inconsistently) generating Hyperlinks to the local file name rather than an internal link. Posted: 31 Jan 2014 04:09 PM PST Table of Figures generated by "Insert Table of Figures" - is (inconsistently) generating Hyperlinks to the local file name rather than an internal link.
I have several Tables of Figures, each used to generate an index for different sets of captions for table and figures. Each Table of Figure field code was automatically generated using "Insert Table of Figures". I have hundreds of captions. All the captions field codes are automatically generated by "Insert Caption".
When generated, some (about 50%) of the entries in the table point to internal links and about 50% are links to the current file location stored locally. In addition to maintaining this file as a MS Word "source", the file is also saved to a PDF so that internal cross links, TOC entries, and Table of Figure entries are intended to be links to within the same document. This works for the TOC,and hyperlinks to bookmarks.
As near as I can tell the autogenerated captions are identical. For example, the caption:
"Fig. 1 - PDF Bookmarks – Scroll Icon" is auto-inserted.
When the field codes are toggled to see the field code entries, it expand to be this:
"Fig. { SEQ Fig.\* ARABIC} - PDF Bookmarks – Scroll Icon" and the corresponding entry into the table is this:
"Fig. 1 - PDF Bookmarks – Scroll Icon vi"
when field codes are toggled is visible as a link to my current document.
it expands to this:
"{ HYPERLINK "\\\\vmware-host\\Shared Folders\\Documents\\vSecurity 5.5 User Guide\\vSecurity 5.5 User Guide.rev1.10.docx" \|"_Toc378945129"}"
THE VERY NEXT FIGURE (ON THE SAME PAGE) is:
"Fig. 2 - Preview - View Menu"
which, viewing field codes is:
"Fig. { SEQ Fig.\* ARABIC } - Preview - View Menu"
The corresponding entry in the table is:
"Fig. 2 - Preview - View Menu"
which expanded is:
"{ HYPERLINK \|"_Toc378944130" }"
I actually edited the Hyperlink with the file reference, and looked again at the link by hovering over it.
It still was an external file reference !) I updated the table, and it restored itself back to the full hyperlink file
reference.
Please provide a work-around or advice - or a fix.
Thank you,
- Joel.
|
| SEQ field switch in figure caption numbering reverts back on its own Posted: 31 Jan 2014 03:24 PM PST I am using automatic figure caption numbering in a Chapter. However, I have situations where 2 figures have the same number (Figure 1-1. Sheet 1 and Figure 1-1. Sheet 2, for example). So I go into the SEQ field and change the /s 1 switch to /r 1 to restart figure numbering at 1, then update the fields. This works well for a while, but then after I insert a few more figure captions Word (rudely without my asking) changes my /r 1 switch back to an /s 1 switch and my figure numbering is messed up. I don't know what is causing this behavior or how to prevent it. This is not acceptable. Can someone tell me how to keep this from happening? Do I have to use the /r 1 switch on all the figure captions downstream from the initial use? Thanks, Allen |
