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...Formatting Lost in Excel 2007
I've spent a lot of time googling but all I really came up with is
that it may be due to links (which I have deleted) so hopefully
someone out there will have an answer.
We have a very large workbook that has been used since before 2005
that we have never had a problem with. Two months ago, we started
using Excel 2007 but had no issues. In about mid-April when opening
the file, all of the formatting is gone! So we assumed someone saved
it as the wrong file so we copied an older version of the file and
reformatted the entire thing. Saved it and reopened and no f...where is that save data feature for backup?
On sql 2005, where is that console that allows me to save my data
to a directory for easy backup? If I remember correctly, I can set this
on a schedule too? I was shown this a few years back, and for
my life I can not remember where it was. :'[
ToddAndMargo (ToddAndMargo@invalid.com) writes:
> On sql 2005, where is that console that allows me to save my data
> to a directory for easy backup? If I remember correctly, I can set this
> on a schedule too? I was shown this a few years back, and for
> my life I can not remember where it ...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)
...Using Outlook for AOL e-mail #2
I have set up my Outlook to handle my AOL e-mail as per
the instructions on the Microsoft web page:
I see my inbox. The problem is when I try to send an e-
mail, I get:
Task 'AOL E-Mail - Sending' reported error
(0x800CCC7D): "Your outgoing (SMTP) server does not
support SSL - secured connections. If SSL - secured
connections have worked in the past, contact your server
administrator or Internet Service Provider (ISP).
I talked to 3 different support people at AOL, and they
have no idea.
I...E-mails; First letter of each line is Capitalized
Seems as if every first word
on everyline automatically becomes upper case?
How do we shut this off/
Sigh... what version of Outlook are you using and do you have Word being
used as the editor? Have you looked at the autocorrect options if you are
using Word? What troubleshooting have you already tried so we don't repeat
things that did not work?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
After searching google.groups.com and findi...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...Autofill
When I click the black plus mark to autofill a column, instead o
calculating the formula that I entered in the first cell, it repeat
the same answer as in the first cell. How to avoid this?
should I try reinstalling excel software?
Sometimes, I get correct answers without problems. If this becomes
problem if we employ the whole excel sheet? Once I used all columns an
about 100 rows. After that, I have this problem.
Let us say, that we need to multiply the first 2 columns. the correc
answer needed is in the 3rd col. and the wrong a...Exchange Only mail not going.
Server = 2003 Std
Exchange = 2003 Std
Clients using SMTP & POP to/from various ISP's,
Exchange is the central archive for company. But will eventually be ONLY
Email addressed via Exchange goes nowhere. Some sit in X400 queue, others
Email from Administrator account. (No SMTP to ISP, ONLY an Exchange account)
Not on any queue, but Outlook claims it was sent.
Email To Administrator From Administrator using X400 address vanishes
Email To Administrator From Administrator using SMTP address vanishes.
Email To working client From Administrator using X400 o...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...Work Flow
Is it possible to prepare E-mail for the customer by using work flow?
I don't want to sent e-mail just prepere it.
Regards Mark P.
Funnily enough....you can create a marketing campaign in crm 3.0 and add a
email activity. When you deploy the emails to your contact list they will
not be sent out. In your words they have been prepared for the customer.
Microsoft CRM MVP
"Mark" <Mark@discussions.microsoft.com> wrote in message
news:C3C15E5C-E60A-4764-BF39-1B1B649EC60C@microsoft.c...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,...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.
"...Why does Outlook mark RSS feeds as junk mail?
I can't tell if this is a double post as IE closed the tab automatically.
After corruption on my mail profile or OST, which ScanPST and SanOST did not
fix, re-importing email from Exchange into Outlook 2007 leaves me with
-custom categories lost
-message flags lost
-duplicate folders, the default being empty, the secondary with my Outlook
-all my RSS feeds being marked as junk mail (junk mail filter set on Low)
When RSS is stored in the mailbox, this is normal behavior. It's usually
better to turn off filtering until the ost is recreated.
Did you...Creating Hyperlinks for excel spreadsheet
Hi Excel Gurus,
I'm stuck with a prb creating hyperlinks in Excel.
The way we do is -
1. We load the data in an vb array eg: arr(rows, cols)
2. Supply this array to the excel using the below method,
excelapp.Range("A1:G1000").Value = arr
This will copy all the data in the array to excel sheet.
3. One of the columns in the array "arr" will have a hyperlink code.
Eg: arr(0) = "Data0", arr(1) = "Data1", arr(2) = "Data2"
arr(3) = "Data3", arr(4) = "Data4", arr(5) = "Data5"
arr(6) = &qu...Mails sending but not being received
Sending emails from Windows Mail with a POP3 account to external accounts but
they are not being received. No rejection messages, they send as usual. Also
receiving emails from these external accounts without any problem. Have
tested 2 alternative Hotmail and Gmail accounts I have, same results.
Have contacted the POP3 service provider, they have tested the account and
sent mails from my email address to my alternative accounts successfully.
Am working on Vista, never had this problem for last 14 months until 2 days
Anyone have any idea as to why this is happening?
Th...Importing OE6 mail rules to Outlook 2000
I recently migrated from Ooutlook Express 6 to Outlook
2000. I used the import facilities to import all my mail,
accounts, etc.. But the massive mail rules I had on OE6
(screening SPAM) only came across with the first excluded
word! The rules are of the form ' if 'xxx' or 'yyy'
or ...., then delete it'
What I get in Outlook 2000 is only 'if 'xxx' then delete
it. All the other SPAM trigger words did not import. Any
...Filling in Cell above with Data from below
Have data where I need to fill in A1 with A2 Data, A3 with A4 and so on:
Need it to end up like:
How can I do this?
visit www.ExcelGoodies.com If A1 and A3 are blank:
Select A1:A4. Press Ctrl+G. Click special, blank.
Start typing a formula:
Then press the down arrow key. This should finish the formula and create:
Press Ctrl+Enter to apply formula to all currently selected cells.
If needed, you could then do a copy, paste special - values only.
If A1 and A3 are not blank, but you want every other line copie...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...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...Referencing other Office programs in a Excel VBA App
I din't like the way my previous post sounded, so i'm reposting...
My Excel VBA programming is decent enough when I'm only working with
However, I'm trying to expand my knowledge base and frequently I wish
I could better interact with other Office programs, such as Outlook,
in my Excel VBA apps.
To better illustrate my question, here's a piece of code that works
great (it populates a user form list with Outlook addresses) but I
don't fully understand.
Private Sub UserForm_Activate()
Dim x As Integer
Set objOL = CreateObject("...Help please
When running excel (and word). A cell will suddenly fill with a series of dots
and then random words like this:
...............he man place ther world
Does anyone recognise this?I've just installed Norton Pro and it hasn't found
any viruses. Surely though I have one. Can any one help?
Perhaps Speech Recognition is turned on. It might make text appear
Choose Tools>Speech>Speech Recognition
(if it had a check mark, it was turned on)
> When running excel (and word). A cell will suddenly fill with a series of dots
> and then ...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...