Pages

Search

Microsoft Word - Merge cells in able with vba macro

Microsoft Word - Merge cells in able with vba macro


Merge cells in able with vba macro

Posted: 17 Jan 2015 02:53 PM PST

I have a table that I want to have repeat on pages of a report. Rather than copy and paste I would like to use a macro.

I can create the macro with the table, formatting etc., but cannot find guidance to merge cells.

eg., In my three column, multiple rows table

I need to merge cells as below

   
  
     
     

I am almost there, but as I need this for a report I thought I would ask for some expert help :)

Regards Jan

How to create an index of an entire text, i.e. of all words in a word (2013) document?

Posted: 17 Jan 2015 02:45 PM PST

In order to find (missing) keywords, count frequencies etc. I need to make an index in Word documents of the entire text of that document, of every word from 1 letter onward.

At first I tried to work with a concordance file (search and replace to get every word on a separate line) , but that is very unpractical because of all the multiple entries and the fact that they are case sensitive, meaning they all have to be copied with a capital letter.

Here and there on the internet I found some references to macro's, but they do not work (at least not in v. 2013). I also found a reference on this site saying that (in word 2007) no macro would be needed, but following the link I found no answer....

I hope someone can help.

Word 2010 right-click context menu opens then closes immediately

Posted: 17 Jan 2015 12:47 PM PST

Hello,

I am editing a Word DOCX file that came from another computer. I saved it to my PC with editing enabled.

When I right-click in the document the context menu opens for a moment then closes again. 

This occurs also with files created on my PC.

How can I fix this problem?

My operating system is:

Microsoft Windows 7 Home Premium 6.1.7601 Service Pack 1 Build 7601

Microsoft Word 2010 (14.0.7140.5000) SP2 MSO (14.0.7140.5002)

Thanks!

Word 2013 not opening with windows 8

Posted: 17 Jan 2015 11:43 AM PST

Word 2013 is not opening in windows 8 either in normal or safe mode.  I have tried deleting the ABBYY FileFinder file and still no joy.  I have spent the day searching through all threads and support through the Microsoft support pages but nothing helps.  I get the We're sorry but word has run into an error that is preventing it from working correctly.  Word will need to be closed as a result.  Would you like us to repair it now?

When I select the repair option nothing works.  I also get the same message when trying to open in safe mode.

All other programmes like Excel, PowerPoint and Access all open without issues.  Please help.

Merge - only first record printed to ALL labels

Posted: 17 Jan 2015 10:34 AM PST

Windows 7

MS Office 2010

Mail Merge - Labels

Task: 6@ labels/page, 48 records

Problem: all 48 labels contain only the first record

When I merge to edit before printing, or even print a single page (6 labels) of the first six records, I only get the first record on all labels. If I search for any other record they are all there, they just don't fill the merge document.

Any suggestions?

Thanks!

Microsoft Word Mail Merge Issues with Excel Files

Posted: 17 Jan 2015 09:12 AM PST

Using the Mail Merge function in Word to develop an envelope for a mass mailing using an envelope template.  Using an excel file for the database with the Mail Merge function.  Works OK, but in one of the fields...the zip code field in this case...I find on some records the zip code gets inserted OK, but on others it just shows as a zero.  See example below.

Mr. Sanjay Gupta
Vice-President, Platform Development, Major Appliances
Haier America, Inc.
1800 Valley Road
Wayne, NJ 0

In looking through the zip code field, I find the zip codes with "pure numbers" like 30303 merge OK into the envelope document.  Others with an zero in the first position in the zip code as well as zip codes with a hyphen in it like 30303-4567 print out like above....just a zero.  At first I thought the excel field with the zip code in it needed to be changed to a number format field vs. general.  However, doesn't make a difference; zip codes that aren't "pure numbers" still print out like zero when merged.  Any ideas?

Regards..Rick

Batch process word files in a folder to set top margins

Posted: 17 Jan 2015 09:00 AM PST

I got the following code from the net and changed it from changing paper size to setting top margins of word documents to suit my needs

Sub ChangeTopMargin()
Dim myFile As String
Dim myPath As String
Dim myDoc As Document

'Change to the path where your documents are located.
'This code changes ALL documents in the folder.
'You may want to move only the documents you want changed to seperate folder.
myPath = "C:\Users\Rajesh\Documents\Clinical Material\OPD"

'Closes open documents before beginning
Documents.Close SaveChanges:=wdPromptToSaveChanges

'Set the path with file name for change
myFile = Dir$(myPath & "*.doc")

    Do While myFile <> ""

    'Open the document and make chages
    Set myDoc = Documents.Open(myPath & myFile)
    myDoc.PageSetup.TopMargin = 168

    'Close and saving changes
    myDoc.Close SaveChanges:=wdSaveChanges

    'Next file
    myFile = Dir$()
    Loop
    MsgBox "Process complete!"
End Sub

Now when I run this code after saving the file and closing code editor, the existing document closes but nothing else really happens. Ideally each of the word files in the folder OPD should be opening, get changed, saved and closed till the Process Complete message box comes up. I am out of my depth here. I will appreciate any help.

Thanks

After a mail merge, can the file's Save As name be prepopulated with merge data?

Posted: 17 Jan 2015 07:47 AM PST

When we want to send out a letter, we merge a template letter with a single person from our database, and the letter fills right in. Then we save the letter for our records. When we go to save the merged letter, it starts with a default name of "Form Letter1". Then we have to manually change it to something else, like "Smith - Intro Letter - 2015".

Problem is, doing that each tie we send out a letter takes time, plus as it turns out different people as using different schemes for file naming.

Is there any way to have the merge filename prefill with something like "<last name> - Intro Letter - <current year>" so that when someone goes to save it they don't have to enter in a name at all?

Thanks.

Is there a bug in StoryRanges?

Posted: 17 Jan 2015 06:27 AM PST

Hello, most of my reports include multiple sections in which headers/footers are unlinked. I created this file with two sections and unlinked the headers/footers. I put some text in header/footer of second section.

In contrast to the statement at http://msdn.microsoft.com/en-us/library/office/ff197823%28v=office.15%29.aspx "Returns a StoryRanges collection that represents all the stories in the specified document.", ActiveDocument.StoryRanges does not refer to header/footer story ranges if the header/footer of the first section is empty.

Please Run This Makro with this file

Sub ListStories()

Dim sR As Range

For Each sR In ActiveDocument.StoryRanges

Debug.Print sR.StoryType

Next sR

End Sub

It will return 1, 12, 13, 15,16 instead of 1, 7, 9, 12, 13, 15, 16



help with needing to reinstall microsoft word without a product key.

Posted: 17 Jan 2015 04:23 AM PST

Hi

I bought my laptop about two years ago.

I had to completely refresh my computer without losing my files. 

I now need to reinstall Microsoft office 2010.  problem is I no longer have my product key and never had a disc to install it.

any ideas how to get it please

thanks

P

The "Auto fill / auto suggest" file names shortcut associated with opening a Word document has stopped working.

Posted: 16 Jan 2015 11:38 PM PST

* Not sure if this makes sense, but until about a month ago - whenever I would Open a Word document - typing the first few letters of its file name would result in the blank field being filled up with suggested file names already in the folder I'm trying to access, e.g., it was a "shortcut," - the blank field in which I would enter the file name would momentarily turn into a drop-down suggestion list of available documents in the folder - adjusting itself after each succeeding letter being typed.

* For example, if I wanted to get at a document with a long file name called, "poster inventories and frames.docx," until about a month ago, I didn't have to type every word in this file name to open the document.  Word 2010 used to instead "auto-suggest" the documents to open based on the first few letters of the document file name being entered.  I could then easily see suggested documents highlighted in blue until it hit the only available match - and I could click and instantly access it.  It was a real handy shortcut.

* I really don't know what to call this shortcut function; it is not auto-correct, but it was like visiting a search engine that suggested words as you type, but occurring "offline" within Microsoft Word while opening documents.  BTW, I'm not talking about the Recent Documents function which lists frequently opened files.  The behavior I'm describing used cover any document I would try to open in a target folder, regardless of when it was last modified/viewed/created.

* I've searched everywhere for an answer and have come up empty.  I suspect it might have something to do with the normal.dotm file but I can't find any options for what I'm describing even in the broad Word Options or Word Help sections of my program to restore this behavior. 

* I hope what I'm describing makes sense.  Anybody familiar with what I'm describing?  If you do, please let me know and thanks! 

Best, David in San Diego.

Microsoft Word

Posted: 16 Jan 2015 04:21 PM PST

I have installed Microsoft Office 2010 on my computer, which is Windows 8.1.  When I try to open a document I get the message that Micrfosoft 2013 needs to be purchased and the document will not open.  How do I get this message to go away and have documents open with the Microsoft Office 2010 that I have installed?

Microsoft Word 2010 font drop down not working when computer is added to the domain

Posted: 16 Jan 2015 03:11 PM PST

I have been asked to resolve a problem with Microsft Word 2010.  The font drop down works fine locally but when it is added to the domain the option is unavailable.  Does anyone have any experience of this or any suggestions?

Thanks

Thomas

Working with office offline

Posted: 16 Jan 2015 07:29 AM PST

Hello,

I would like to be able to open a word document even when I do not have an internet connection. All my documents are saved in my computer and not in my Onedrive. Moreover when I try to open a document while offline I get a window saying that I can enter my product key instead, however the pop up window with the message saying " Getting your new office ready for you" doesn't seem to be able new office ready for me... Also, every time I open a document ( with internet connection) my account is being verified. Why is this?

Could you please give me a clear answer with the steps to follow in order to be able to use my computer even though my connection internet is gone please, saving everything as a pdf is not the most efficient use of my microsoft office.

Thank you.

How can I check what's mail that exchange is dropped? - Microsoft Exchange

How can I check what's mail that exchange is dropped? - Microsoft Exchange


How can I check what's mail that exchange is dropped?

Posted: 03 Jun 2008 08:02 PM PDT

Thanks Leif, but Forefront only display the mail contain virus rather than spam

"Leif Pedersen [ MVP]" wrote:
 

Spammer use fake reply mail address make me got junk mails

Posted: 03 Jun 2008 07:55 PM PDT

Thanks Leif, so does anyone suffer from this stuff as me? any workaround or
something can be done to make improvement?

"Leif Pedersen [ MVP]" wrote:
 

Exchange Domain Controller

Posted: 03 Jun 2008 07:29 AM PDT

Thanks John

"John Oliver, Jr. [MVP]" wrote:
 

Calendar View Inconsisteny

Posted: 30 May 2008 06:38 AM PDT

Hi,

Thank you for helping me clarify the situation.

This issue may occur if:

1. There is anything wrong with the Public Folder store tion and OWA
didn't get the latest Public Folder free/busy information from other
server.
You may check if the OWA log on the same Exchange server that with your
Outlook clients. Also check the Event log for more information about Public
Folder tion.

2. There is any interface problem between OWA and iPhone.
Since OWA can show all other calendar normally including all Windows Mobile
devices and we do not have the expertise to work on such phones, I'd like
suggest you contact Apple for further assistance. Generally, we only work
with Windows based Devices.

At the same time, I am still researching on this issue and it is under
investigated. I will reply to you as soon as there is any update from me.

Thank you for your time and cooperation!


Best regards,
Robbin Meng(MSFT)

Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security

================================================== ===
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Buggy enable-StorageGroupCopy (SCR)

Posted: 29 May 2008 03:12 AM PDT

Looks like the fix is still being developed. I had read something that said
it was ready, but it appears that it was incorrect. My apologies for the
confusion. I'll keep an eye on this hotfix and post back here when it is
available.

--
Regards,

Scott Schnoll
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no
rights. Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

"christian reibnegger" <microsoft.com> wrote
in message news:com... 

Restored DB won't load in RSG. Help!

Posted: 28 May 2008 09:40 PM PDT

what version of Exchange? you should not need to run eseutil /cc...what
kind of backup are you restoring from? an online backup? errors in event
log? Have these mailboxes been moved to a different server, or the accounts
deleted, by any chance? how critical is the data you are seeking? if it's
really critical and you cannot get the restored DB to mount, you can either
contact MS product support, or go with something like Quest's Recovery
Manager for Exchange, which might help...depends on some detail...

--
Susan Conkey [MVP]



"Jon Doe" <net> wrote in message
news:com... 


Is a Windows Cal needed

Posted: 28 May 2008 09:44 AM PDT

On Wed, 28 May 2008 09:44:00 -0700, Rafavic
<microsoft.com> wrote:
 

You can't ask these kind of questions here. Go and ask a real-live
legitimate Microsoft authorised reseller.

Errornous limits message

Posted: 27 May 2008 08:30 AM PDT

Thanks Oliver - you were right on target. Approximately 1.5 hours after
making the change, the limits message went away.

"Oliver Moazzezi [MVP]" wrote:
 

Error with mailbox recovery center on exchange 2003 sp1

Posted: 27 May 2008 02:02 AM PDT



"Milind Naphade" wrote:
 

Sorry but it doesn't works. I havn't explaned it good but
when I say "The email address is removed to the user profile in AD" I mean
there is no more exchange attributes on it.
I tryed tree time to remove the echanges attributes. The wizard always
finised fine, but I still have the problem.

anyway, thanks to try to help me :D
if you have some more ideas, feel free ^^

Public folder default message type

Posted: 26 May 2008 10:43 PM PDT

Any suggestions please?



"Tarun Arora" <com> wrote in message
news:com... 

Exchange SMTP connector question

Posted: 24 May 2008 08:47 PM PDT

but both servers works perfectly with other outsiders via the e-mail gateway. This is what I don't understand..anything suggestion to check ?
"Ed Crowley [MVP]" <org> wrote in message news:phx.gbl...
Mail for def.com should route out the connector, and the def.com server should accept that mail. This is not a relay situation. The relay denied suggests a problem with something like recipient policy.
--
Ed Crowley
MVP - Exchange
"Protecting the world from PSTs and brick backups!"

"Johnny " <com> wrote in message news:phx.gbl...
Yes...both are exchange servers...I think that should work but NDRs was generated once the messages hit the connector for remote delivery in MTS
"Ed Crowley [MVP]" <org> wrote in message news:up%23$phx.gbl...
That should work. Is def.com's mail server an Exchange server?
--
Ed Crowley
MVP - Exchange
"Protecting the world from PSTs and brick backups!"

"Johnny " <com> wrote in message news:%phx.gbl...
Hi Ed

Here are the connectors' information on both servers. Hope you can help me to identify the problem. Thanks alot.
-----------------------------------------------------
on abc.com mail server

Connector Name : Connector to the Internet
Address Space : *
Cost : 1
Smart Host : [IP Address of Internet e-mail gateway]

Connector Name : Connector to def.com
Address Space : def.com
Cost : 1
Smart Host : [def.com mail server's IP address]
-----------------------------------------------------


-----------------------------------------------------
on def.com mail server

Connector Name : Connector to the Internet
Address Space : *
Cost : 1
Smart Host : [IP Address of Internet e-mail gateway]

Connector Name : Connector to abc.com
Address Space : abc.com
Cost : 1
Smart Host : [abc.com mail server's IP address]
-----------------------------------------------------

"Ed Crowley [MVP]" <org> wrote in message news:phx.gbl...
Describe how you have these connectors configured.
--
Ed Crowley
MVP - Exchange
"Protecting the world from PSTs and brick backups!"

"Johnny" <com> wrote in message news:phx.gbl...
No.. .abc.com's server recipients policy contains abc.com and def.com's server contains def.com of course... and they work perfectly both receiving and sending to other domains via the e-mail gateway.

The NDR was generated immediately when sending e-mails from abc.dom to def.com and from def.com to abc.com with the next connectors on both servers.
"Ed Crowley [MVP]" <org> wrote in message news:phx.gbl...
Both domains are in the recipient policy on both servers? Each server should have a recipient policy with only the domain for which it accepts mail.

Explain exactly what you're doing and when you get the NDR.
--
Ed Crowley
MVP - Exchange
"Protecting the world from PSTs and brick backups!"

"Johnny" <com> wrote in message news:phx.gbl...
Yes... I am pretty sure because abc.com and def.com are in the Recipient Policy lists on them respectively.
"Ed Crowley [MVP]" <org> wrote in message news:%phx.gbl...
And when you send a message to a def.com recipient from your Exchange 2003 abc.com server you get a relay denied? Are you sure that you've specified the right smart host, i.e., a server that's able to receive mail for def.com?
--
Ed Crowley
MVP - Exchange
"Protecting the world from PSTs and brick backups!"

"Johnny " <com> wrote in message news:phx.gbl...
yes...I have specified the smart host pointing directly to the "def.com" mail server its the IP address.
"Ed Crowley [MVP]" <org> wrote in message news:phx.gbl...
Let's focus on one direction. From the abc.com's server, you've set up a connector with address space "def.com". On that connector, jhave you specified a smart host?
--
Ed Crowley
MVP - Exchange
"Protecting the world from PSTs and brick backups!"

"Johnny " <com> wrote in message news:phx.gbl...
Our company has been using E2K using a single SMTP connector with address space "*" redirecting all e-mails to our e-mail gateway without any problems. This domain is currently handling abc.com. We recently trying to setup another organization in the intra-network with E2K3 which will handle def.com sharing the same e-mail gateway. We tried to setup an additional SMTP connector on both servers to route e-mail between abc.com and def.com without passing through our e-mail gateway with address space "abc.com" (on E2K) and "def.com" (on E2K3) but keep getting 550 relay denied message when trying to send e-mails between these 2 domains (in different organizations and servers) but without any problems sending e-mails to any outsiders (all others will be send to our e-mail gateway as usual). Does anyone know what have I missed to make the second SMTP connector working ?

Thanks
Johnny

exchange tools and vista

Posted: 23 May 2008 02:26 AM PDT

Another option is run VirtualPC, install a Windows XP or Windows Server VM
and run the tools there.
--
Ed Crowley
MVP - Exchange
"Protecting the world from PSTs and brick backups!"

"plomkiolki" <com> wrote in message
news:com... 


Searching Contacts in OWA Issue

Posted: 21 May 2008 09:03 AM PDT

Ok Thanks,

That explains why I can't search contacts like I do in outlook but why isn't
it even an option for me on the drop down menu?

Thanks,

TKE402

"Oliver Moazzezi [MVP]" wrote:
 

Microsoft Word - How to Change Multiple Documents at Once.

Microsoft Word - How to Change Multiple Documents at Once.


How to Change Multiple Documents at Once.

Posted: 16 Jan 2015 02:46 PM PST

I am using MS Office 2010 and need help with the following.

I have a word file with 200 individually addressed letters to clients and need to change the following without doing one letter at a time.

Date on each letter

Body of text


Keep colors and formatting when copying and pasting word documents 2013

Posted: 16 Jan 2015 02:04 PM PST

My original saved document (docx) has a few different colors and I'm using fonts, paragraphs, and styles to personalize/structure it.

I copied and pasted this original document to another new blank page and a lot of my formatting isn't on the copy.  

Can you direct me on the steps to take to get an exact same copy?  

Thank you,

Vic

 

Type and Read Japanese Characters in Word 365

Posted: 16 Jan 2015 01:40 PM PST

I have Office 365 and am trying to read Japanese Characters in a Word doc. I have a couple questions.

My friend who is Japanese is writing a translation in Japanese of some English words for me. I need to then take those into Photoshop. So I want to understand how best that she can write in Word and then share that doc with me and what language pack we both need to write this out? 

I have Office 365, so maybe it would be easiest to create a doc online that she could just type in directly herself? Not sure if that language pack is supported though. Just trying to make it as easy as possible.

Thank you.

Microsoft Word Language- -> set proofing language -> "do not check spelling or grammar" not working in document

Posted: 16 Jan 2015 01:24 PM PST

I have a document with several computer software code listings.  Some people make these documents with images, but it is much more useful to paste code that in turn can be copied and pasted by the reader or even oneself.

I have tried very hard to use the spelling and grammar by selecting the appropriate region and using Language- -> set proofing language  -> "do not check spelling or grammar".  At first it appeared to work, but after many such sections were selected, it stopped working as if I hadn't set it at all.  I tried saving the document.  I tried re-doing these selections many times, still it doesn't say work.

As another recommended post says the box won't stay checked.

But more fundamentally, it just doesn't work.

Is there a cure for this problem?


Alternatively,

Is there any other way to mark a section of a document as computer software code (or in some instances mathematical or scientific equations) and get spelling and grammar check to leave them alone?   One still needs the rest of the document to be checked!

Thanks in Advance!

MS Word text converted to gibberish

Posted: 16 Jan 2015 01:16 PM PST

Suddenly 46 pages of notes in a document of several hundred pages turned to gibberish that cannot be reconverted by a font change.

Here is a sample, which has been copied and pasted resulting in a copy that looks like it does in the text excpt that the vertical rectangles in  my document don't show the letters and numbers:\

H0^0g0‹0°0¼0Ä0Û0è0ó0&191?1w1ƒ1‹1¢1¯1º1ù12E2L2g2[1]373A3L3Œ3±3

ï3'4¢4¬4½4Í4
5­5^5g5ˆ5·5Á5í5*62

6g6x6ˆ6¨6´6½6Æ6ù6

7797Z7Ÿ7Ä7Ê7858T8°8959C9M9V9^9™9Â9Ð9à9ý9e:o:u:¤:²:㪻㫄㫞㬠㬼㭐㭗㭞㭥㭬㭳㭺㮁㮋㮞㯑㯪㯴㰀㰘㰨㰹㱈㱐㱣㱱㱸㱿㲆㲍㲔㲛㲢㲬㳘㴒㴲㴿㵕㵤㵾㶙㶯㹼㺹㻐㻘㻥㻻㼔㼠㼱㽏㽝㽡㽥㽩

㽵㽹㽽㾁㾅㾉㾍㾑㾕㾙㾝㾡㾥㾩㾭㾱㾵㾹㾽㿁㿅㿣쀀

Čげそほれクナビュヲヸㅯㅼㆉ㆜ㆢ㇓㈁㈇㈹㉅㉕㋮㌧㍦㎐㎙㎨㎵㎾㏏㏢㏲㐋㐔㐬㐶㑈㑹㒅㒕㒪㒺㓇㓤㓹㔌㔜㔵㖙㖤㖹㗓㗫㘄㘵㙅㙽㚛㚡㚳㛋㛔㛦㛳㛼㜍㜙㜥㜶㝁㝎㝙㝦㝱㝾㞃㞍㞚㞟㞩㞲㞹㟉㟖㟨㟷㠃㠍㠘㠨㡇㡕㢔㢛㢢㥬㥿㦇㦏㦔㦤㦵㧋㨭㩎㩷㩾㪻㫙㭁㮤㰊㱶㳒㴳㵢㶒㶱㸔㹺㻣㽕㿁퀀Ā〭ゆペㄏㄻㅚ㇆㈟

㊢㋎㋭㍙㏅㐱㒝㔉㕵㗝㘲㘶㘺㘾㙂㙆㙊㙎㙒㙖㙚㙞㙢㙦㙪㙮㙲v6z6~6‚6†6£6­6´6Ä6Î6Õ6è6î6      737@

G7N7X7d7n7{7‚7‰7"7™7¨7È7î7ø78848J8c8q8|8Š8ž8°8¼8Ì8ß8ü8

9!9A9]9Á9ü9

In 30+ years of word processing, mostly on MSW, I've not encountered an error quite this serious. Regrettably both the local and remote backups of the document were saved with this mess before it was discovered.

This has occurred just a few months before a major system-wide upgrade here including a current edition of Word. I need to finish a major project before a huge system replacement.

Does anyone have any ideas as to what this is, how it might have occurred, whether the original can be recovered, and/or how to prevent it from happening again? I hate to think that I have to check every page of a 500 page document every single time before saving it.

With thanks in advance,

JT

Oregon

Mail merge to PDF

Posted: 16 Jan 2015 01:06 PM PST

I want to use the following code in a working word mail merge doc. It fails at

  If Trim(.DataFields("Last_Name")) = "" Then Exit For  (The requested member of the collection does not exist)

If it means any thing my source workbook has the following headers

LAST NAME FIRST NAME ADDRESS CITY ST ZIP  CONTRIBUTIONS

Sub Merge_To_Individual_Files()

Application.ScreenUpdating = False
Dim StrFolder As String, StrName As String, MainDoc As Document, i As Long, j As Long
Set MainDoc = ActiveDocument
With MainDoc
  StrFolder = .Path & Application.PathSeparator
  For i = 1 To .MailMerge.DataSource.RecordCount
    With .MailMerge
      .Destination = wdSendToNewDocument
      .SuppressBlankLines = True
      With .DataSource
        .FirstRecord = i
        .LastRecord = i
        .ActiveRecord = i
        If Trim(.DataFields("Last_Name")) = "" Then Exit For

        StrName = .DataFields("Last_Name") & "_" & .DataFields("First_Name")
      End With
      .Execute Pause:=False
    End With
    For j = 1 To 255
      Select Case j
        Case 1 To 31, 33, 34, 37, 42, 44, 46, 47, 58 - 63, 91 - 93, 96, 124, 147, 148
        StrName = Replace(StrName, Chr(j), "")
      End Select
    Next
    StrName = Trim(StrName)
    With ActiveDocument

      .SaveAs FileName:=StrPath & StrName & ".pdf", FileFormat:=wdFormatPDF, AddToRecentFiles:=False
      .Close SaveChanges:=False
    End With
  Next i
End With
Application.ScreenUpdating = True
End Sub

.PDF only option in Open dialog box

Posted: 16 Jan 2015 01:04 PM PST

I think I'm looking for a setting on the machine or in Word which is running on my office-mates computer because this doesn't happen on any other computers in the office. 

We have a locked form with a macro which adds a file to the document.  The macro button, when selected, opens a dialog box where the attachable files live however instead of allowing this user to see "All Files", ".PDF" is selected and is the only choice.  The files which can be selected are all Word files so since it's looking for *.pdf files only, these selections are not visible.  I'm wondering how to get this switched back to "All Files" in the dialog box for him instead of just ".PDF".  (This is the drop down button on the bottom right next to the File name: box just above the Tools button, "Open" button, and "Cancel" button.  In other programs this is labeled, "File Type".) 

I'm wondering if there's a setting in Word that got flipped somewhere to only open PDFs for some reason.  I know it's not the macro as this is not the behavior on anyone elses machine.  Does anyone know if there's a setting somewhere which says, "When opening files only open PDF files" or what might be causing this behavior? 

Thanks for your help.

-Dax

xe field codes

Posted: 16 Jan 2015 12:35 PM PST

  How do I remove the hidden text ie xe codes from word 10.  

I inserted an index table which I have now removed. The field codes remain but it does not affect the home tab view. But when I go to print via file , print I suddenly have 5 extra pages which upsets the page numbering . I think it is the xe codes which are visible in the print preview and print when I print a page, but not in the home view which increases the number of pages.

Office 2010 Word Custom Dictionary - Add a word

Posted: 16 Jan 2015 11:53 AM PST

I have Windows 7 and Office 2010.

I want to add a word to the custom dictionary that has mixed case. I live in Australia and my Internet Supplier is iiNet. When I proof a document with their name in it, it is always highlighted for possible correction. (I don't want to check the box about mixed case as I use other mixed case words as well) 

I do not get the option to add the word during the spell check process.

I can add any word to the custom dictionary that has four mixed case letters but when the fifth letter is typed, the "Add" box greys out.

Not a big problem but a definite annoyance. It also has me wondering about French words as a lot of their surnames have mixed case and I doubt I should have to load a French dictionary to overcome this problem.

Give some love to academic/scientific users

Posted: 16 Jan 2015 11:22 AM PST

There is no way to submit lengthy suggestion to Microsoft, hence this forum entry.

Give some love to the academic/scientific community. (Feature request to Office 15, Office 16, Gemini)

The equation editor (when typing the equations) absolutely rocks, however there is a direly missing feature. It is virtually impossible to write a proper particle physics or general relativity paper without the Feynman-slash notation. The back-end is completely capable of doing it (see my post at http://answers.microsoft.com/en-us/office/forum/office_2010-word/want-to-write-using-the-equation-tool-with-feynman/8d498a8a-0225-471c-9a5d-aacb6670b0eb). We would like a "\fslash" control that would overstrike a "/" character over the last group, similar to how "\bar" works.

Numbered equations! It's a joke how there are feature requests for numbered equations in Word 2007 (!!!) forums, but still no support. People tend to write macros for inserting single row, triple column tables with the center column holding 85% of the page width and the equation caption Cut+Pasted into the third column. This is tedious.

Custom anchors to equations/figures/bibliography entries, and custom bibliography etc. styling. Nearly all scientific journals accept only LaTeX, all due to this problem. The few that provide .doc or .docx templates don't use proper anchors or bibliography. That is because they cannot be styled. Even the simplest, and most widely used style of bibliography entries appearing as [15] is not possible, because Word only allows round braced (15) style (which is ok for equations, but not bibliography). Giving heaps of prebaked stylings is not enough. Allow for customzing both anchors and the appearance of the collections. (TOC, Bibliography, etc.)

Although most likely this is not the exact place to post, but hope it makes it to the right place: the Windows Phone 8.1 version of Office completely lacks the equation renderer. Equations render blank spaces, making us convert all our stuff to PDF, redering the Office App pretty much useless for both Word and PowerPoint presentations.

Word 2013 Enforce/Re-enforce Unchecking "Remove personal information from file properties on save"

Posted: 16 Jan 2015 11:16 AM PST

As a default in Word 2013 the checkbox "Remove personal information from file properties on save" located in Trust Center Settings is checked, because of this any documents saved will be scrubbed of user names for comments made when using "Track Changes". When opening the document after a save the comments will all show "Author".  

If the check is removed from "Remove personal information from file properties on save" it is again checked after running the "Document Inspector". 

How can we remove the check from the box and enforce this even after the "Document Inspector" is ran?  I cannot find any reference to this in Group Policy and we are using O365 Pro Plus Click to Run install so initial settings cannot be made during the install. 

Thank you 

Microsoft word Document Word 97-2003, 2 question pure text & text with small images What MS should I be using ?

Posted: 16 Jan 2015 10:59 AM PST

My first question is that I opened Word 97-2003 document and in ALL cases it states that this document is a word 97-2003 document and can't be edited

So as created on a PC  what  Microsoft word documents (year) should I  be creating these documents as I have just been say copying a document in part as 97-2003 the new document is that also

Finally the un-editable W 97-2003 document if ALL text is displayed correctly formatted highlights except for Non edit perfect

If the document has any photo or images  which are 3 at most the text is left justified and only 10 characters wide so this question would be ONE NEAT column of words.

Any document W97-2003 with images created on a PC sent to myself as an attachment to a email ONLY on PC is 100%  EDITABLE  and displayed as it should, BUT if viewed after download or via office is essentially just one column 10 characters wide

Question

What microsoft Word version should I be using on a PC that if I do need to edit on my windows phone I can

ATM

No images display on phone is OK                             NOT EDITABLE

With images a column "10" display NOT, NOT! ok        NOT EDITABLE

Thanks

Can't unpin docs from Word taskbar

Posted: 16 Jan 2015 10:14 AM PST

When I right-click the Word icon in my taskbar, a list of recent documents pops up, as well as a few I pinned for easy access. But there are a few documents pinned which I cannot unpin. 

I right-click the pinned document, and select "Unpin from this list"...

But it just flashes orange and does nothing. I have been able to add new pinned documents and unpin these, but over the last several months a few documents have refused to unpin. I deleted one or two of these documents from my computer files, but they still refuse to unpin (they didn't unpin when the documents were still present, either). 

Suggestions? I'd really like to get rid of these documents - having a pinned list is not helpful if I can't remove the documents later. 

Automatically generating text from one text box to another

Posted: 16 Jan 2015 09:28 AM PST

Hello,

Is it possible to write text in one text box, then have a 2nd text box automatically generate the same text? I'm think they would have to be linked somehow (not like in a newspaper where the run-off text continues into the 2nd text box), or perhaps entering an IF field or formula of some sort?

Thank you in advance!

What happened to the Office.com ClipArt feature in Office 2013?

Posted: 16 Jan 2015 08:49 AM PST

The only option available in the Insert>Online Pictures is the Bing Search bar.  The Office.com clipart bar was available in December, and is now missing.

Also, is there a place to sign up for update notices.  When teaching, it would be nice to know if a feature you are using is no longer available before you send a class to the link/tab etc. 

Flashing Cursor in Word 2010

Posted: 16 Jan 2015 07:10 AM PST

We recently added new network copiers and installed the drivers on each PC on campus.  Now, when using Word 2010, the cursor flashes constantly.  I tried removing the copier, downloading a new driver and reinstalling, but the issue persisted.  I changed the default printer and the cursor goes back to normal.  Is there any other way to fix this?  I have some users for whom selecting the correct printer is a bit of a challenge.  Thank you!

MS Word Templates

Posted: 16 Jan 2015 06:54 AM PST

I have a template where an employee's first and last names are entered in text boxes. Is there a simple way to "pick up" that data and display it elsewhere in the template (so that they user doesn't have to enter it multiple times)? We are using Word 2010 and 2013, so I need something that works in both. Thanks!

MERGESEQ using data from Excel

Posted: 16 Jan 2015 05:58 AM PST

HI,

This would be my first post so go easy if this is a silly question! i also apologize if i have uploaded this to the wrong place, i have uploaded to the word Sub but had no joy.

I currently have a working mailmerge but would like to speed it up.

in my data record (Which i am pulling from excel) there can be multiple records for the same individual, this means once the merge is finished, they will receive multiple emails whereas i would like each individual to receive only one. there may be a list of 100 records but only 10 recipients.

i have found articles referring to MERGESEQ but i have not have much joy.

I have sorted the table alphabetically and also labelled the headers correctly. I would like the "Salesperson" column to be the "key".

I have uploaded my code in mail merge and my table headers and hope that someone can help me! i have been tinkering for AGES! I am open to other suggestions to get the result i am looking for?

Table Headers - http://imgur.com/29qMjyr&nSfV8XC#1

MERGESEQ - http://imgur.com/29qMjyr&nSfV8XC

When i merge the above MERGESEQ code, the output is simply "Hi,"

This is my currently working Merge:

http://imgur.com/8KJQoaS

Textbox Value Set

Posted: 16 Jan 2015 05:58 AM PST

Using Word 2010 form. Need to set value of textbox to the same value as another textbox on the form.

How can I have the mark up margin in only part of a document?

Posted: 16 Jan 2015 04:21 AM PST

I need to combine two word documents into one. One has been marked up and has the mark up margin with comments in it. The other has not been marked up and when I copy and paste the marked up document into this one the mark up margin appears in the entire document. Is it possible to keep the mark up margin for only the originally marked up  part and not the rest?

The reason I need to do this is for an academic assessment submission that requires both things to be presented in one document.

Word 2013 - delete a wavy line

Posted: 16 Jan 2015 04:00 AM PST

How can I rid my diocument of this wavy line please?

i want to give formula that if theaverage of four numbers is greater then 60 then in the next cell it print "a", if greater then 45 then "b" and "c" for remaining. how could i get?

Posted: 16 Jan 2015 03:46 AM PST

same as tittle

Object in Page Header does not display correct

Posted: 16 Jan 2015 01:53 AM PST

Hi Experts

I have created a document in MS Word 2013 and added a Text Box object in the header of the document that serves as a watermark. The text box is rotated 45 degrees and the position of the object is set to align right relative to the page horizontally and with an absolute position of 3,1 cm below the page. This should ensure that the object is placed in the upper right corner of the page regardless of the page orientation.

However if I insert this object in a document with multiple sections - some in portrait and others in landscape - it seems that the object is not being displayed correct in the Print Layout. On pages in landscape the object is moved to the left somewhat aligning to the same position as the object on pages in portrait. But if I open the header or print preview the object is moved back and shown correct.

Any ideas?

Word crashes/not responding when inserting radio button

Posted: 16 Jan 2015 12:53 AM PST

Hi,

Whenever I try to insert a radio button, Word stops responding and crashes. I haven't got any issues with other control forms.

Any help is much appreciated :-)

Kind regards,

Hugo

How do I get my first page to print from Tray 1 and the rest from tray 2?

Posted: 15 Jan 2015 09:55 PM PST

Hi,

I need a button on word that allows me to print my first page of the document on a thicker letterhead paper in Tray 1. Then the rest of the pages on thinner paper in Tray 2.

How do I do this?

Thanks

Word only printing the left half of an A5 page!

Posted: 15 Jan 2015 09:28 PM PST

When I print a page of A5 (14.8 x 21.0cms) writing in Word 2013 (and Windows 8.1) only the left hand side of the writing appears – and that shows on the right hand side of the A5 sheet.

  • I have been assured by the Epson Printer technician that as the Test Page prints correctly (right across the page) that it is NOT a driver fault, nor a printer fault;
  • I have made sure that the printer settings page in Word is set correctly—that the margins are correctly set and that the format is set to 'Portrait';
  • However, there seems to be a conflict in the 'Custom Page Size' tab (within the Print 'Settings' section), as it shows a red exclamation mark, even though the size shown/set is 14.8 x 21.0 cms (which is the correct size for an A5 page).
  • Further, in the 'Page Setup' page, in the 'Paper' tab, under 'Paper Size', only three options are given:  Letter;   A4;   Custom Size.   In previous versions of Word, I always had the option of selecting any number of page sizes!   Yet even specifying a set of page measurements (14.8 x 21.0) under the 'Custom Size' heading, it still only prints half a page of writing!
  • In exploring further on the document to be printed, and clicking on the area alongside the document, a border suddenly appears around the document.   This to me, looks suspiciously like an A4 sized page in 'Landscape' format—with the A5 document that I want printed fairly in the middle of this larger sheet on its side!!!!!       
  • Printer is the Epson Stylus Fax/Printer CX6900F

So I need advice on what adjustments/upgrades/downloads that are needed to enable me to print an A5 page correctly.    I have always been able to print the same (sized) document on all previous versions of Word.

Saving ipad word document to computer offline

Posted: 15 Jan 2015 08:12 PM PST

Hi all. I'm fairly new to the ipads etc, and have recently downloaded the ipad "word" app, as well as excel, powerpoint etc. My laptop at work is on a wired connection, thus no wireless for the ipad. I'm wondering the best way to transfer these word documents between my laptop and my ipad, without an internet connection. Would like to avoid dropbox/cloud etc if possible, as these may need my ipad to be on an internet connection. I can physically connect my ipad and laptop with the white cord, but that's about it. Please help.

Mark :)

Double clicking word file brings to "Open file with ..."

Posted: 15 Jan 2015 07:22 PM PST

After re-installing Microsoft Office, I am not able to open file with double clicking.  Instead I need to pick a programme it shown in the dialogue box.  There must be some setting I haven't done.  Could anyone help please?  Many thanks.

Best regards

Kathy

Office for iPad has a critical bug in latest update!

Posted: 15 Jan 2015 06:37 PM PST

All,

I notice my iPad updated MS office apps for iPad today. So, I went to open word on my iPad, provided my login and password, and then tried to access my documents on OneDrive. The connection dialog box came up "Connecting" and then disappeared again and then reappeared again in an endless loop. I had to quickly push the cancel button on the connection dialog box when it appeared again to terminate the connection. I rebooted my iPad, rebooted the app many times, and also tried a different Internet connection, and the problem still persists -- no joy!. This same problem occurs when using Excel and PowerPoint. Is anyone else having this problem? The office apps for me are totally useless now!

-L

name of corrector is changed to "author"

Posted: 15 Jan 2015 01:12 PM PST

Hi,

I sent a WORD2013 document for review by colleagues and they made corrections. 

The corrections (an comments) were "marked" with their names when viewed on their computer (example: "John deleted" or "John - comment".

However, when I received the document (sent by e-mail), all names ("John" and the like) were replaced by "Author".  So, even though I could see the corrections (and the comments), I could not see who did them. 

To check for a problem due to the sending the document by e-mail, I made my-self come corrections and then sent the document to me by e-mail.   In the file I received, my corrections were marked correctly (by my name). 

Did my colleague make something wrong or this a problem of WORD 2013 configuration ?  How wan this be corrected ?

Regards,