Printing WORD docs from a form
I have a button on a form and I want it to print a Word mail merge document
that contains data from the database that is linked to my application.
I'm using the following code but always get a 5922 error - Word can't
open the source... All variable names contain valid data, so that's NOT
.Visible = True
.MainDocumentType = wdFormLetters
strConnection = "DSN=MS Access Databases;" _
& "DB...problem with BOLD. ITALIC...using Word as editor
I compose a msg using Outlook. Word is the editor. I set a word in bold
ot italic. I send msg to myselg, reading in Outlook. The bold or italic
is gone. What to do?
Are you sending the message as text only? If so all formatting will
disappear. If you want to retain your formatting you'll need to send your
messages as HTML. You can check this in your Outlook options.
Martin Sketchley | www.msketchley.pwp.blueyonder.co.uk
(remove EGGBEANSANDSPAM to reply by e-mail)
...Windows XP: Open file in read-only: Word, Excel, Visio
I'm often sharing files on a network drive with someone. Often, one
of us knows that we don't need to open a file for modification, and we
only need read-access. Is there a way to open a file in read-only
mode so that when someone does need to open it for modification, the
read-only user is not blocking that?
If there is not a way to do this native to Windows XP, is there a way
to do it from the three applications that we use most, namely Word,
Excel, Visio? All are 2003 versions.
I used to save files like this in "read only recommended" mode.
File|SaveAs|Tools|Ge...Not enough memory error trying to open a Word X file
Operating System: Mac OS X 10.6 (Snow Leopard)
Error message: "There is not enough memory or disk space available to complete the operation" when trying to open a Word X file in Office 2008 in Leopard or Snow Leopard on iMac that works fine in Word X despite resaving a new version. Any tips?
Not enough information to answer.
Check that OS X and Office 2008 have the latest updates applied.
Use Disk Utility to Repair Permissions.
Check the access your user ID has to the system Temporary folder (don't
worry about this if you ar...Function that returns the active Window
Hello to all,
Is there a function in dexterity that returns the name of the active Window?
Thanks for your help.
In short, No.
It is possible to write triggers on the activate event of windows to set
global variable to track the active dictionary, form, window.
You could register the triggers for all windows on a form when the Security
script is executed ad un-register them when the form closes. This would
avoid having to register triggers against every form and window in every
product on startup.
What are you trying to achieve, maybe there is anothe...ACTIVATE ACCESS from EXCEL?
Can I activate an Access session (database is already
open) from an Excel macro?
Here some code from MVP John Green that will activate a
certain database in Access. Watch the version issue. This
should get you started:
>Can I activate an Access session (database is already
>open) from an Excel macro?
...hiding cells with a certian type of formatting
How do I get excel to hide cells that has not been formatted in a row or
colum that I applied a format condition to.?
just for clarification...do you want the entire cell row or column to b
hidden, or do you want the text color of the contents of just that cel
to be changed to WHITE or whatever color would hide it given its fil
Excel_Geek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2642
View this thread: http://www.excelforum.com/showthread.php?threadid=39828
...Cannot upgrade to Word 2007 from Word 2002 as word crashes when tr
We have a word add in that programatically inserts an auto text table then
adds rows to it. This works ok in Word 2002 but occasionally crashes in Word
2007 - this is not a consistent crash when we carry out the same operation it
happens in no specific sequence. The only place we are able to track it down
to is the auto text table inserting rows. Word itself is crashing.
We are using COM AddIn written in VB6.
Does anyone know of any key differences/issues between Word 2002 and Word
2007 that could cause such an error.
Or is there a better way to attach a debugger/word debugg...Appointment(Activity) database design
In the appontment activity when I say required, I get a lookup to select the
Account,Contact,User,facility Equipment and Lead.The question is which table
and column these fields are mapped to.( I could manage to get the relation
for the regarding lookup.)
I need to make a report on this field hence is very important.
Thanks for the help in advance
...Active Directory Backup Queries
I'm investigating the Active directory Backup functions and am somewhat
confused. I have written a test program which I run on my machine (meteor).
I have 2 queries:
1) If I call DsIsNTDSOnline(), passing in either of our live servers (dabs
and galaxy) it succeeds and says that Active Directory is online. If I pass
in our test server (dstest), it fails with RPC_S_INVALID_BINDING.
MSDN for DsIsNTDSOnline() says that "The server must be the same computer
that this function is called from". Surely it should return
RPC_S_INVALID_BINDING for all 3 of the above cases since my machine...Word 2007 TOC Not saving settings...
When I use Word 2007 TOC, and I want to edit an existing TOC layout, etc. It
wont remember my settings.
I go to
Table of Contents
Insert Table of Contents
Then I make my chnages here, such as changing the levels of the various
styles and how they show up
Then I select OK, the TOC is created..
I then decide I don't like the changes I made, or I need to include another
So I go to
Table of Contents
Insert Table of Contents
The changes I made are no where to be seen. I have to start over from
What am I doing wrong,...Encoded Word Documents
We have recently purchased a new pc with windows 7 and have installed the
Microsoft Office software however when I got to open a PDF or word document
from a webpage a file conversion pop up box comes up and asks for me to
select the encoding that makes the document readable but none of them do.
even the windows default doesn't work......
You cannot open a pdf in Word. You need Adobe Reader.
What you're downloading from a web page probably isn't a Word
On May 27, 4:25=A0pm, Newuser <Newu...@discussions.microsoft.com> wrote:
> We have rece...Word Wrap: Where is it in Word 2007?
I have Googled and Googled and cannot find any page that tells me where
Word Wrap is. For such a basic feature you'd think it would be under
On Mon, 18 Jan 2010 18:55:28 -0600, "Gary Gary" <email@example.com>
>I have Googled and Googled and cannot find any page that tells me where
>Word Wrap is. For such a basic feature you'd think it would be under
The reason you aren't finding anything is that word wrap is automatic
in Word unless you turn it off, or possibly if something is broken.
Wha...Where are my saved word?
I open the attachment directly, it is .doc and edit it in a loong time, what
I ask is when I press save button and it show nothing so I think it succes.
And I close it!! I can't find it now, could you help me ????? Thanks!
It is gone. When editing an attachment, you /must/ save it to your HDD
first, edit it and then reattach it.
Imperial Beach, CA
"smezsc" <firstname.lastname@example.org> wrote in message
>I open the attachment dire...Bulk E-mail with Non-Word Attachment
I need to be able to send a bulk e-mail (not from a template) with
attachments of a number of different document types to a group of contacts
(could be from a Saved View or Marketing List). Direct E-mail, Quick
Campaigns and Mail Merge do not seem to be able to do this. Is there another
Take a look at this blog
On May 16, 11:57 pm, DStella <DSte...@discussions.microsoft.com>
> I need to be able to send a bulk e-mail (not from a tem...An error occurred while retrieving the list of users in Active Directory
hoe to fix this problem?
> hoe to fix this problem?
...word 2002 compatibility with Windows 7
My niece is handicapped and her new computer has Office 2007 on it. She
would like me to install word 2002 on her Inspiron 546. Is this possible?
Yes, if it is licensed for another computer. If it is an OEM version, it
cannot be installed on any but the system with which it was sold.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Sharon F" <SharonF@discussions.microsoft.com> wrote in message
> My niece is handicapped and her new computer ...Word 2007--pesky black dotted line
I have this moderately thick, black, dotted line running between paragraphs
on my page. I have no idea how to get this thing to go away. Please, could
you tell me what to do to get rid of it?
Mary Sauer MVP
"John" <email@example.com> wrote in message
> I have this moderately thick, black, dotted line running between paragraphs on
> my p...Formula to extract the last word from a cell
Anyone know of a formula that will extract the last word from a cell.
For example if cell contains the text: Best available title
How could I produce the result: "title"
(And preferably be able to fill the formula down the column to get the
last word from other cells in the column as well.)
Thanks for any suggestions.
"Dave K" <firstname.lastname@example.org> wrote in message
&...Default DOCX file to open w/ Word 2007 and DOC to open with Word 2
Hi, I am trying to convert several hundred mail merge documents from Word
2003 to Word 2007. Currently, if I double click a document to open it, it
opens in whichever version of Word was run last. What I would like, is for
..DOC files to open in 2003 and .DOCX files to open with 2007. I've tried to
change the file types to do this, but can't make it 'stick'. Any suggestions?
To prevent the two Word versions from "competing" over the file associations, see the "Hacking the Registry" section of the article at http://www.gmayor.com/Toolbars_in_wor...copying Arabic into Word document on Mac
I am trying to copy and paste an Arabic word from the web into a
multi-lingual Word document on my Mac but am having terrible trouble.
It always comes out either backwards (left-right) or with the letters
not correctly joined up (an Algerian colleague tells me). I have tried
making the web page I am copying from into a PDF first, but doesn't
Any advice greatly appreciated.
> I am trying to copy and paste an Arabic word from the web into a
> multi-lingual Word document on my Mac but am having terrible trouble.
> It always co...XmlTextReader URL Limitation???
I am feeding XmlTextReader a URL that returns the XML that then gets parsed.
The URL forms a query that affects how much data is returned in XML but not
the format of the data.
The problem is that when the URL string exceeds about 163 characters
(strange number) XmlTextReader seems to choke on it and it doesn't seem like
any XML is actually being returned and the code throws an exception on
reading the first element. Shorter URL strings seem to work fine. Strings
longer than ~163 chars work fine when pasted into a browser, so the server
is returning good XML.
Sorry for the long post......limiting number of words in textbox in Word 2007
I created a Textbox in MS-Word 2007 by going
to the Developer option->then chose Design Mode,
then Legacy Tools->Text box Field. The MultiLine
and Enterkey properties are True and the rest
are default values.
Is there a way I can limit the number of
words to a certain number? I realize there is a way to limit the
of characters in the Textbox by the Maxlength value. Also, is it
possible that a message
appears when the user exceeds the maximum length informing
him about that. Do I need to use VBA code or do the inbuilt
features of word allow me to do that?
The short ...Rules
I've created an Outlook rule which automatically sends a
reply to senders if they have included an attachment and
the email is over 200KB. This works.
However I only want to send this automatic reply if the
attachments are not documents of type zip or pdf. I've
tried "except with selected properties of documents".
This does not include an option for document type. I've
treid document subject, title, presentation format, etc,
but these don't work.
How can I only restrict this automatic reply to only
emails with attachments which aren't zipped or pdf? ...microsoft word
is it possible to create a macro to open up word and copy and paste some data from excel into it. Thanks
Debra Dalgleish has an example at:
It's a way of copying comments in a worksheet to a word document. But you can
see the structure nicely.
> is it possible to create a macro to open up word and copy and paste some data from excel into it. Thanks