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...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...The mode function
I looked up the capability of the mode function and it said that the only
time it should return an #N/A value is when there are not two names, or
numbers in a range. I am not sure why but for the given stock market sectors,
the function below always returns a #N/A when it should return in this case
the name finance. Any suggestions?
Can't be used on text.
Gary''s Student - gsnu200908
"Do...Mail send to the wrong receiver
I've send to mail to my friends, the Email address is
correct; because I created it at my personal address
book. But after I send out the mail, this mail was
receive by one of my colleague.
May I know what's wrong with my Outlook 2000 and how to
solve it ?
Thank You !
I doubt it is an Outlook problem. Either you entered the address into your
address book incorrectly or you were given the wrong address to begin with.
Outlook sends to whatever server responds to the address's domain. From
there, it's out of Outlook's hands.
"...Match function with time
I am trying to use the MATCH function to find last train that I can
catch to reach my destination before, on time or just after a given
The arrival times are E1:E10 and also named as ArriveTime and is
formatted HH:MM AM/PM
The target time in H1 and is also formatted as HH:MM AM/PM.
For test purposes I am using 10:00AM and ArriveTime contains
09:59,10:00 and 10:01AM
Using =MATCH($H$1,ArriveTime,0) or =MATCH($H$1,ArriveTime,1) work fine
and both return the row (5), but =MATCH($H$1,ArriveTime,-1) returns #N/
A instead of the row of the earliest train after the target.
I am using Excel 2007
...SOP Blank Order Form
We are entering a new order and the customer has 2 Ship to Address ID's. We
have setup Address ID’s of Ship1 and Ship2, they are different physical
locations. We want Ship2 to print on the above report, but it is always
printing the Ship1 Address. On the order we have selected Ship2 for Ship To
Address ID: Is there something I'm missing. Any help would be appreciated.
...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,...Quartile Function
I would like to use a formula to return which quartile the given data array
falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%,
The quartile function only returns the value of the various quartiles, while
I need to know within which quartile the value falls.
Any help is appreciated.
On Tue, 15 Mar 2005 01:01:02 -0800, "tika528"
>I would like to use a formula to return which quartile the given data array
>falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%,
&g...Where can I get a copy of the Microsoft calendar control?
In Excel 97 I have a calendar control. Those files with the calendar control
do not work in Excel 2003, because I don'd have the calendar control in Excel
2003. Is there some type of calendar control for Excel 2003?
I think there's a link to a free calendar control at the bottom of Ron de
> In Excel 97 I have a calendar control. Those files with the calendar control
> do not work in Excel 2003, because I don'd have the calendar control in Excel
> 2003. Is there some ty...Help with Form code
Need help and not sure where to start. I have an input form with several
tabs. On the first tab is where the general vendor and customer info is
entered. I added a fourth tab to 'monitor' two of the vendor’s decisions.
Tab one has an option group with 5 programs. Tab 4 has an option group for
Yes we concur or No we don’t. There are nine radio buttons (not in a group)
that need to be checked (all reasons that apply) if we don’t concur. There
is also a comment text field that must be filled out if option groupConcur =
On tab 4, I’d like the option groupConcur, radio butt...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...(User Defined) Function for Copy&Paste?
Dear Excel Power Users,
I have a problem with copy of formated text to another sheet.
Cell contains multiple fonts and sizes but copies only the first
font and size as format for the whole contents
example: Sheet1!A1 : mahIgGABEI (a=alpha) (ABEI=superscript)
using the " =A1 " function in for example Sheet2:
Sheet2!A1=Sheet1!A1 becomes mahIgGABEI (all normal Arial)
using Copy&Paste works fine ! Can this be solved using a function
instead of Copy&Paste specific cells to other sheets by hand, I
cannot vindt the function doing what Copy&Paste does.
I've found th...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...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...Automatically send out of office reply based on "show time as" sta
Can you set Outlook 2007 to automatically send out of office replies if you
have appointments that show your time as "Out of Office"?
"CaroleCarlo" <CaroleCarlo@discussions.microsoft.com> wrote in message
> Can you set Outlook 2007 to automatically send out of office replies if you
> have appointments that show your time as "Out of Office"?
If you're using Exchange 2007 as the backend, you can specify start and end
times for when the OO messages will be sent, but it isn't...Getting Excel to return Hiragana using code/char functions
I have a Japanese computer which does this perfectly, but when I tried to use
the worksheet on an English computer with Japanese language enabled, it only
came up with errors. The code it was returning for the Japanese characters
was much to low & putting in higher codes meant it didn`t recognise it.
What can I do to make it work?
...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 ...Using a module to control multiple Forms' events
I have a navigation bar which exists on nearly all of my forms. It
has buttons to create new items, to search for items, etc.
But to make my navigation bar functional, I need to copy and paste the
EXACT same event code into about 15 forms - incredibly smelly code.
So I was wondering if anyone knows if I can use a module to set a
control's event code. Anyone know if this is possible in Access
>I have a navigation bar which exists on nearly all of my forms. It
>has buttons to create new items, to search for items, etc.
&g...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...Paste function is greyed out in the toolbar and I can't use ctl V
I have a problem the my paste function. Whenever I copy (copy seems to work
ok with the marquee and selection process) and then try to paste the data
into another cell, it won't let me. the Paste function is greyed out. The
worksheet is unprotected and I'm in Excel 2003.
...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