VBA from another app: Suppressing Excel confirmation dialog?
After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
On Erro...Moving Transaction Logs to another Drive
I have a few questions regarding moving transaction logs...
1. When you move the transaction log location, should you also move the
system path location to the same place?
2. What file(s) does the System Path location include?
3. When either or both of these are moved, does the database have to be
dismounted? If so, how long does this operation generally take?
On Tue, 15 Aug 2006 18:47:41 GMT, "exx" <email@example.com> wrote:
>I have a few questions regarding moving transaction logs...
>1. When you move the transaction log location, sho...outlook 2007 runs slow
Outlook 2007 runs slow. Is there a way to speed it up.
Do you have the outlook performance update installed?
Are you using a Dell laptop?
Did you upgrade from an older version and are still using that profile?
http://www.slipstick.com/outlook/ol2007/slow.htm - install the update
listed at the end - also make sure all OS and Office updates available
through Microsoft update are installed. If it's still slow, try the various
solutions that apply to your situation.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Ta...can't send anything in Outlook 2002
I just sent a post asking for help because I can no
longer send email with attachments. After sending in the
post, I went back to Outlook and clicked on the
Send/Receive button just to check if I had any new mail.
I got the same message: "The operation failed". So I am
totally out of business with Outlook. How to solve the
Did it work before? Did you change anything in yr settings? Are you sure
your internet mail account settings are valid (correct username, pw,
"Marilyn Fogelquist" <fogel@cablespeed........go to next cell and paste question
I am writing a macro that is supposed to take certain cells from a
"interface" page, remove them, and paste to a string of cells o
another. That is easy, but I cant figure out how to make them go t
another set of cells, if the ones I recorded are filled.
' Macro1 Macro
' Macro recorded 8/4/2004 by Lane Lacy
ActiveWindow.ScrollColumn = 239
Application.CutCopyMode = False
Sheets("productivity&qu...Outlook Mobile Access Problem
Hi I've a big problem in Outlook Mobile Access.
I've a server exchange standalone withoput a front-end=20
I've configured the OWA web form authentication and SSL.
For OWA it's all right...everything is going right...
The problem is OMA
When I try to log on on oma I find the following error=20
message :"Unable to connect to your mailbox"
To solve my problem I've found in microsoft web site the=20
Microsoft Knowledge Base - 817379
Cannot Access Exchange Server 2003 by Using Outlook Mobile=20
Access When the
Exchange Virtual Directory Require...How do i get outlook to update hotmail account without reopening?
the tedster <the firstname.lastname@example.org> wrote:
Ask your question in the body of the message.
Without reopening what? Outlook? Hotmail? The short answer is "you
...Outgoing emails not sending for outlook express 2000
Can anyone help me?Everytime I try to send an email these
error messages pop up and I have no idea what to do;
The host 'SMTP' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'SMTP', Protocol: SMTP, Port: 25, Secure(SSL): No,
Socket Error: 11001, Error Number: 0x800CCC0D
The host 'POP3' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'POP3', Protocol: POP3, Port: 110, Secure(SSL):
No, Socket Error: 11001, Err...DB Emailing Questions
1) How do i format the message text of an email in Access. I used macro
builder - action = sendobject. Can you use code builder? if so, please give
me an idea of how the code will be like.
2) Also can i assign the email to have a recipient automatically or do i have
to write it down each time?
Thank you in advance.
Message posted via AccessMonster.com
On Jan 21, 11:51=A0am, "axm0035 via AccessMonster.com" <u56602@uwe>
> 1) How do i format the message text of an email in Acce...Office XP to Office 2004 Question
I am sure this question has been asked many times, but I've never had
occasion to look at Mac NGs before, so please accept my apologies.
I am a Windows XP user who is contemplating the change to a Mac. I have
Office XP Pro installed on my Windows machine, and I accept that I'll
need to get the Mac Office (Office 2004?) when I change over.
I understand that Word, Excel & Powerpoint files should migrate in a
fairly straightforward manner, but I am less sure about Outlook to
Entourage. (I'm assuming here that Entourage is the Mac 'equivalent' of
I h...Moving 5.5 server from one domain to another
Ex 5.5, sp4 on Win2000 sp4, Mcafee VScan8, Veritas 8.6 currently in NT4
domain. Have exactly the same config in another office except this Ex 5.5
server is the bridge end.
Have gone through the process of changing service accounts and that is
working fine and machine is using the new service accounts to run the
services, (ie using the new service account in the Windows 2003 domain), when
I drop out of "abc" domain and into "xyz" domain machine comes up fine, all
services start but after about 60 secs the information store stops, if I try
to start it manually I get er...Outlook 2003
I copied my PST file from my D: drive to my F: drive.
I then went into "Data File Management" to get the new location
recognized and to have all future mail sent to that location.
After doing this, my custom settings, like new folders, date
settings, columns, etc, are all back to their default settings.
Is there any way I can get my custom settings working again on the F:
Could you explain yourself a bit more? What custom settings are you refering
to? You mean views? And what new folder settings?
Also post your version of Outlook.
Robert Spar...How to do a mass download of names to Outlook address book
I have about 800 names and email addresses in an Excel
spreadsheet that I need to add to my Outlook address book.
Can anyone give me a hint on how to do this?
Save the Excel Spreadsheet as a CSV (Comma Separated Value) file and then in
the Address Box, Click, File, Import, Other Address Box, then click Text CSV
file and browse to it.
"Hal Segal" <email@example.com> wrote in message
> I have about 800 names and email addresses in an Excel
> spreadsheet that I need to add to my Outlook address book.
> C...MSN accounts dosen't work in Outlook.
I can't download my e-mails from MSN to Microsoft Outlook 2003.
I have setup the account correspondent to Microsoft Outlook 2003 Wizard, but
it still dosen't work.
Does anyone know where the problem can be?
Only the paid MSN and Hotmail accounts will work in Outlook and/or Outlook
Express. Are you supscribed to the paid service?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"hardharut" <firstname.lastname@example.org> wrote in me...outlook 2000 help file
Seems after I did added SP3 from MS upgrade site my help from outlook has
quit working. message is msohelp caused error in itss.dll. help works in ALL
other programs including outlook address book. I'm running windows 98 SE,
Office 2000 SB and IE 6.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03
...Pie Chart Question
Hi, I am tring to make a pie chart that needs to include 2 pieces of
information for one series.
I have two columns of information (number and value) that relate to one
person. There are 5 people all together.
How do I do this?
Technically possible, you might create a bar-pie chart or a pie-of-pie chart.
IMO, this would be a TERRIBLE idea. Pie charts should be forgotten, IMO,
because they often distort data and make it very hard to actually read the
My recommendation would be to make a clustered chart, a ...Outlook should be able to email MS CRM advanced find queries (grou
The only way to e-mail a group in MS-CRM is to use the Quick Campaign
function. The Quick Campaign has several disadvantages:
- attachments for emails are not possible
- this takes at least about 10 more clicks compared to sending a standard
- the quick campaign doesn't have the look-and-feel of Outlook to which
users are accustomed to
Therefore it would be great if you could select the emailaddresses from
groups retrieved from MS CRM into the TO:, CC: or BCC: field in a standard
Outlook email message. Actually you would make the advanced find queries
available to sel...outlook 2003 memory leak? /messages display as"none" and eats up memory
When a certian user opens outlook, and clicks on sort by
size, half of her e-mails disappear, and "none" is
displayed. She said this happened to her at home, except
she was on her normal view which is sort by date. The
only way that I can recreate the problem is to click on
sort by size.
If you click on one of the "none's" or even hover the
mouse over it, the memory will spike up! I had the
performance tab open while I was doing this, and the
memory being used was read at 1.46 GB! And if I close
outlook the memory drops down to normal. I took ...Debugger comes up when attaching files to Outlook 2002
I have a pro bono non-profit client running win xp sp3 & ms office pro.
Last week she reported that every time she tried to attach a file to an
outlook email, she received a dialog asking her if she wanted to start
the debugger. It never allows her to attach the file and if she goes
through with starting the debugger, she gets a variety of errors...
never a repeating error.
Anyone have any experience with this error?
...Outlook 2002/XP Folder List view question
Any assistance would be greatly appreciated. I have a user still using
Outlook XP and has the following issue.
Outlook does not remember the folder view settings. User has folders under
the Inbox folders and of those folders some are expanded and some are
collapsed. When he closes Outlook it does not "remember" the folder settings.
The user would like for Outlook to remember the settings because it has in
the past. Is there a way I can get this back?
...Outlook 2003 Contact data
Just starting using Outlook 2003.
When composing an email, when go to address the note, it appears that there
are 2 Contact files - 1 is "blank" and the other has lots of my contacts.
It is the latter contact file that I enabled to use as my address book.
Initially address book comes up the first one and I get error message. Then
I toggle to the second one and all the names are accessible.
How do I get rid of the one that appears blank, so only one contact file
appears when I go to address an email?
Les <email@example.com> wrote:
> When composing an e...Outlook 2007 Missing Mail
I have an office where we are noticing that if we look in Vista Mail that MS
outlook 2007 has missed many emails. Program restarts and reboots don't seem
to correct the problem, and both programs are using the same IMAP settings.
Is there a "helpful" little option in Outlook that prevents it from looking a
all email receieved to an account? Does anyone else have the same problem?
are there any similarities between the ones it misses?
"nano" <firstname.lastname@example.org> wrote in message
Just upgraded from Outlook 2000 to Outlook 2003.
Everything seems to be working OK !! BUT !
On the Outlook Today screen no images are shown.
If I go into the customise option, there are no images shown for the various
Also any changes I make in Outlook today options are not saved..
Any Ideas ???
Can anyone tell me why in Outlook 2002, when I send a
message it goes to the Outbox and sits there until I click
another folder or wait for a long time. The Send Message
Immediately is checked. I did apply SP2.
Any suggestions will be greatky appreciated.
...Questions regarding Data center operation
I have over 8 years of IT experience but very new to the Data Center
space and have 4 questions. If someone can answer, I would really
You can consider these questions more of a brainstorming ideas.
1. If a facilities capacity is re-classified as 5 MW lower than it was
previously, what needs to happen here?
2. We need to expand Network capacity at a facility by 2 times but for
only 20% more money, how can we do it?
3. Where to start if you are responsible for tech refresh in existing
4. During tech refresh planning you find out about a delay in delivery...