Pages

Search

Microsoft Word - Mail Merge - Labels per page & formatting

Microsoft Word - Mail Merge - Labels per page & formatting


Mail Merge - Labels per page & formatting

Posted: 12 Dec 2014 03:28 PM PST

Hello and thank you-

I am having two problems in trying to create labels from a mail merge.  The first is that somehow random spaces get added in when I link my data from Excel, even though the source formatting is consistent.  For example:

I want this:

John Smith

ABC Company

1234 Main St

City, State Zip

And occasionally with some labels I get this, or something else equally as unexpected:

John Smith

ABC Company

1234 Main St

City, State Zip

Second,  I am using the Avery 5162 template with 14 labels per page.  I have ~90 contacts to print labels for.  After I have linked my Excel data, and set up the fields, the first page looks correct except for the above issue.  However, each subsequent page begins at the contact one after the first contact of the previous page, and continues in order...

So for John, Sarah, Mike, and Abby, and assuming 3 labels per page, I get:

John Sarah Mike

Sarah Mike Abby

Mike Abby

Abby... producing 1 whole page for each of the contacts.

Heeeellllp!  I don't want to type 90+ addresses in by hand, this is 2014.

Using Cut/Paste to record macro in Word 2010

Posted: 12 Dec 2014 03:20 PM PST

I used to be able to create macros by cutting/pasting text (record/Ctl V/stop recording). Now, it just overwrites all the prior macros where I used cut/paste. I see that I can insert/object/text from file, and move text over from a file. But I just want sentences or paragraphs, and don't want to save a ton of little files that are just the text I need.  I've looked all over on line without success. Window 7 Pro.

Solution? Thanks.

Automating captions

Posted: 12 Dec 2014 01:44 PM PST

I am trying to automate the captions in a report template. I need the captions to start renumbering from 1 in each portion of the report. Each report will include information on a varying number of floors in the building being discussed. For the 24th floor, I want the caption to start at 24-1. For the 5th floor, I want the caption to start at 5-1. For the mezzanine level, I want the caption to start at M-1.

In trying to do this, I defined a bookmark FloorA which contains the floor number of the first floor in the report. Then I modified a caption from 24 { SEQ 24 - \* ARABIC} to { REF  FloorA } - {SEQ {REF  FloorA } \* ARABIC } . Unfortunately, this evaluates to 24- Error! Bookmark not defined. Caption

Since the first REF field evaluates as expected, the bookmark must be defined. What am I doing wrong?

The intent is to edit the contents of the FloorA bookmark and have the captions automatically update so the user doesn't have to edit the numbering of the caption fields individually.

How do I open "filename._docx files"?

Posted: 12 Dec 2014 01:22 PM PST

I'm running Windows 7 and Word 2010 and have been receiving word files with a  "._docx" file type.

I can't open this and there is no possibility of making an association in control panel.

Is there a way to open these files or do I need a later version of Word?

ActiveX and Building blocks Word 2010

Posted: 12 Dec 2014 11:53 AM PST

Please forgive me if this is a simple question, I am new to Word VBA and everything I have learned I have learned online from groups such as these. I'm using Windows 7, Word 2010.

I am creating a template (.dotm), which uses User Forms, Building blocks and ActiveX checkboxes. Based on the selection created in the User Form, building blocks are inserted into the document. In one of the building blocks, I have inserted 4 ActiveX checkboxes. I have code that hides/shows bookmarked text based on the checkbox that is 'checked'. As long as I don't close the file, the building block will insert as it should. As soon as I close the file (and Word), when the file is opened again, I try to insert this building block. I then get the 'too many edits' error. I have enough disk space and my temp folder is fine.

Which leads me to my question... Can ActiveX Checkboxes be used in Building Blocks? I have tried to use the Checkbox Content Control, but I cannot add code to VBA to hide/show my bookmarked text for it.

Any help would be greatly appreciated. Thank you!

microsoft word 10 starter edition update received 12/10/1014 now word directory not showing in windows explorer

Posted: 12 Dec 2014 11:34 AM PST

On December 10 2014 a pop up window appeared saying that I had an update to word starter edition 2010.  Since applying this update I am unable to see my word files directory in Microsoft explorer.  I can still get to the files from inside word or by doing a search for the file.  From the search screen I am able to see the file properties and it is not checked as a hidden file.  This is a problem because I am now  unable to make a backup of just this directory or just individual files in the directory.   How can I correct this problem?

Card design shrinks when I place it in Word 2013 Text Box???

Posted: 12 Dec 2014 11:09 AM PST

Before I was required to upgrade to Word2013, I was  able to print out an 8.5 x 5.5 Christmas card in Text Box. Now when I try to do that, Word 2013 shrinks the size, which destroys the look of the card. 

Word 2013: Change Compare/Legal Blackline Settings?

Posted: 12 Dec 2014 09:27 AM PST

How to I change the manner in which Word will identify the changes between two documents to make them more obvious?

My settings have the changes in a very pale blue with a shadowed strikethrough.  It's very difficult to see on the screen and almost impossible to see in a print out.

I can't find anywhere to change this.

Any suggestions?

Print Preview In WORD 2013 Has Been Slowed Down - How Do I Speed It Back Up Again?

Posted: 12 Dec 2014 09:00 AM PST

 

In WORD 2013 when print previewing a document Microsoft seem to have slowed up the speed at which the screen paints so that there's a delay between one page and the next.

 

How (if possible) do I change the speed so that there's no discernible delay between painting one page in print preview mode and the next?

 

Thanks in advance for any replies.

 

Printscreen Into an image file

Posted: 12 Dec 2014 07:46 AM PST

How can I transform an image that I made it with printscreen in Word into an image file(e.g. jpg) ??

Thank you in advance

Find and replace a space in between 2 index fields

Posted: 12 Dec 2014 07:41 AM PST

Hi Everyone

I thought I had double spaces in my word 2010 document but find and replace didn't find any. Looking deeper, I found some of my index fields have a space in between them.

I've tried different variations of ^dXE(space)^dXE but cant work it out.

I have {XE "some text"}(space){XE "more text"}(space)even more test. When fields are hidden, the 2 spaces look like a double space

How do I remove the space but keep the XE field as in

{XE "some text"}{XE "more text"}(space)even more text

Hope that makes sense and thanks in advance

JT

Ctrl+V in Word

Posted: 12 Dec 2014 07:28 AM PST

When I'm trying to paste something in a word file , Ctrl+V doesn't do anything.

Although, I made use of Ctrl+V to paste an image in this forum and it worked properly.

Can anyone tell me what to do in order to make Ctrl+V in Word work properly?

Thank you in advance.

Proofing tools are not working in Office 2013

Posted: 12 Dec 2014 06:43 AM PST

My Windows 8.1 and Office 2013 are in english. The region settings are set to germany. I've downloaded and installed the proofing tools for german language. But the proofing tools are not working. When i go in Office to options -> language proofing for german is not installed. When i go to Programs and features the proofing tools are installed. How do i get the proofing tools working in Office 2013 ?

Attaching docs

Posted: 12 Dec 2014 03:11 AM PST

How do I attach multiple documents to be shared via email?

Highlight multiple words

Posted: 12 Dec 2014 02:29 AM PST

I want to highlight treaty and custom in a word file in one time. Is this possible with Find and Replace?

Thanks in advance

Insertion Of Label (ActiveX Control) Now Causes Warning To Appear - Fix Needed

Posted: 11 Dec 2014 10:44 PM PST

 

Hans has given a temporary fix for subject problem here:-

 

http://answers.microsoft.com/en-us/office/forum/office_2007-word/insertion-of-label-activex-control-now-causes/0dd2de7a-dae8-4988-8243-dea305688f75?tm=1418279620698

 

 - but the .exd files have to be cleared out every time you want to insert a Label (ActiveX Control).

 

Can we have a permanent fix for this so that Label (ActiveX Control) can be inserted without having to clear .exd files each time?

 

Thanks in advance for any replies.

 

No OneDrive with Word for iOS

Posted: 11 Dec 2014 10:06 PM PST

I'm trying to access OneDrive within Word for iOS on both an iPhone and iPad. I've successfully logged in but when I try to access the contents, all I get is the message "Folder contents have changed.  Your view will be refreshed.". But no documents ever appear. I have already tried resetting and reinstalling Word. What can I do to access OneDrive? 

Microsoft Works

Posted: 11 Dec 2014 06:53 PM PST

Hi,

 I wonder where I can get a copy of Microsoft Works. Is there anywhere you can get it free? You shouldn't have to pay for it because it's old and unsupported. I have a copy of Works 6 but when I open Microsoft Word it asks for a product key. What can I do?

Number formatting in text form controls and using formulae

Posted: 11 Dec 2014 06:16 PM PST

I have a simple form that used the Legacy Tools.  The form, amongst other things, summed numbers that users input into preceding cells.  The input cells are Text Form Fields where the Type is set to Number and the Number format can be defined.  Each cell can also be bookmarked (eg, a , b, c), so that the summing is easily done by inserting a Formula =Sum(a,b,c) and the Number format can also be defined in the Formula.

I am now trying to replicate something similar in a new form that contains the Word 2013 Form Controls, but the new tools don't seem to have the Legacy features such as number formatting and bookmarking.  I could use the Legacy Tools in the new form, but I thought I read somewhere that the two types shouldn't be mixed in the one form.  Is this correct, and if so, is anyone able to suggest how I can achieve my aim using the new Form Controls, please?