Auto Filter problem
I am using the auto filter for a particular column to sort out differen
medical programs. When I click the drop down and click a program, i
doesnt show me ALL the lines that say this particular program. Why is
Message posted from http://www.ExcelForum.com
maybe some hidden characters in these lines 8e.g. additional space
"jkb724 >" <<firstname.lastname@example.org> schrieb im
> I am using the auto filter for a particular column to so...Outlook does not save the e-mail addresses entered
I am using Outlook 2000 SR1. When entering a new contact, it does not save
the e-mail address along with the other information logged in. I have tried
substituting the contact's name with the e-mail address to send e-mail, but I
get an error message that it does not recognize the contact name. How can I
...Apple Mail not working right???
Ok, so I installed Office:Mac 2004, now all of a sudden, my Apple Mail
(the Apple provided email application) dock icon no longer shows me
how many messages I have waiting! VERY irritating!!
This sequence of events started last night when I first installed
Office, and then lo and behold when I opened Word for the first time,
all of these fonts got installed. I'm an Extensis Suitcase kind of
guy. I don't really like all those fonts in my system folder. I've
even disabled all the other "stock" fonts except for Geneva and Lucida
Grande. I also had Arial enabled since that...Send campaign e-mails from a queue
Direct e-mail allows e-mails to be sent from a queue using the e-mail
address given by the queue. However, I need an unsubscribe option so I am
trying to do the same using either a quick campaign or full campaign e-mail
activity. However, the system only allows me to send the email either from
myself or the owner of the contact record and not from a queue. Is this
normal or am I doin something wrong.
This is normal.
You can use a "test" user account to send out the campaign, or update your
CRM user profile's email value.
Frank Lee, Microsoft CRM MVP
Word 2003 has a very annoying default. It assumes too much! If I reformat a
few words in a document, it changes the entire document to that formatting.
Grr-rrr-r! I have to constantly press undo to get what I want. I know
there's a feature that's causing this annoyance but I can't find it to turn
it off! Can anyone help, please?
Microsoft Word MVP
"Connie Martin" <ConnieMartin@discussions.microsoft.com> wrote in message
I have a spreadsheet that utilize the stock quote add-in from MSN. On a daily basis I refresh the add-in functions for the Highs, Lows, Last, Volume, etc. On occasion the spreadsheet reverts to manual caculation settings, and I have to press the F9 even after I updated the quotes. I've always preferred the any spreadsheets I open, blank or otherwise, the automatic setting selected for calculations. I consider this an annoyance. Has anyone experienced this glitch? Is there a fix for it?
Excel takes the calculation mode from the first workbook that opens in a
Sub...auto copy self
How do I arrange for Outlook to automatically copy myself
on every new, reply or forward email?
If you mean keep a copy of all sent, see settings under Tools/Options/Email
Options and Advanced Options
"rich" <email@example.com> wrote in message
> How do I arrange for Outlook to automatically copy myself
> on every new, reply or forward email?
...Auto correct or Auto complete
We are all familiar witht he auto correct or auto complete functions found in
MS applications. Of course that means it is available in Access also. My
question is this ... can this function be replicated within the DB, so that
the set of auto correct items are part of the package rather than something
that would have to be set up on each individual desktop system?
It's use, for me, would primarily be within a memo field where medical
abreviations, used as a shortcut, would convert to the true meaning as the
user types them in. Ex: "prn" without quotes would change to. &qu...Auto Scale Chart Macro -- Any improvements please?
This is the best way I've found to correctly scale a chart -- the only way I
found to exclude a chart interpolating with #NA cells was to delete those
cells containing #NA, and run the chart. This takes a long time on my
computer. Wondering if there is a better way. This macro is directly taken
from 2 excel mvps and modified; i believe a mehta and ron bovarty, but could
be wrong. Thanks for taking a look.
Dim ValuesArray(), SeriesValues As Variant
Dim Ctr As Integer, TotCtr As Integer
Applic...Migrating E-Mails from Goldmine
I am trying to migrate e-mails from Goldmine to CRM 3.0 using the data
migration framework. In Goldmine, e-mail body is stored in a field
called RFC822 in table MAILBOX. The RFC822 field is a 'text' field. In
CRM 3.0 DMF, I need to insert the e-mail records in the cdf_EMail
table. The RFC822 Golmine field needs to go to the 'Description' field
in cdf_EMail (this is an ntext field).
I am using INSERT INTO ... SELECT FROM kind of statements to select the
necessary fields from Goldmine that need to post in cdf_EMail.
The problem is with the RFC822 field. If i run the DMF data mi...How to generate a string with values from a range?
I ahve a little macro that is passed a range. It does some work on the
individual values. I have written a subroutine that writes debug data
to a side file. I would like to dump the values in the input range to
the side file as a delimited string. If it was an array variable, I
could use the Join function. I have tried various combinations, but
Can someone show me a single line of code that will generate a single
string from a range variable?
I know I can do it with a loop, but I'd prefer a single statement
(perhaps using Join) is possible.
Single line of exis...OWA auto login
I am trying to use the credentials from the forms authentication login to
automaticaly log in to Outlook Web. I redirect to a URL with this format:
I have seen this example in other posts but this does not work for me. I
still get the Outlook Windows Login prompt.
Perecli Manole wrote:
> I am trying to use the credentials from the forms authentication
> login to automaticaly log in to Outlook Web. I redirect to a URL with
> this format: http://UserName:Password@mailserver/exchange
> I have seen this example in other posts but t...aut generate tab
I have a form called f018ContrPerf
Is it possible for a tab to be auto created for each UnitNo field I have
within a record?
The tab should contain a form called fUnit and the PK is ProjectID, and
if I display a project record with 2 unitNo's then a two tabs are created
with the fUnit form in the tab areas. The fUnit forms will display the
specific data on eahc unitNo
if I display a project with 3 unitNo's then three tabs will be created...
and so on
You can't generate more tab pages at runtime.
It would be possible...Auto look through subfolders
I can write a macro that will extract data from all excel files in a
What I need to be able to do is write a macro that will automatically
extract data from excel files within folders and sub folders and sub
sub folders etc
For example the data is all held on the following directory:
H:\development forms\2006 cost sheets\
And within that directory by customer - for example Tesco, Boots, Asda
etc. These customers are then subdivided into product ranges - eg
1,2,3,4 etc and some futher subdivided by national or exclusive. All
the excel files are in exactly th...Any way to get rid of an auto-suggestion in the login dialog box, for Exchange/OL using RPC over HTTP?
A client was using RPC over HTTP to two different Exchange servers (OL
prompting for profile on startup). Both profiles were set up to prompt for
credentials upon connection to Exchange.
There's now only one Outlook profile needed; the other is gone and OL isn't
prompting for the profile selection any longer, which is fine.
However, Outlook is remembering domain1\user and domain2\user in the login
dialog box, and I'd love to be able to get rid of the no-longer-valid
credential dropdown suggestion.
(The computer is not a member of a domain and hence always needs to be
prom...Get Appointment alert by e-mail
How can you get appointment alert by e-mail
You'll need to use a utility. See
http://www.slipstick.com/addins/calendar_reminder.asp for a list.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
How many email accounts are in your main Outlook profile?
http://forums.slipstick.com/show...An auto reply to an auto reply!
Had the funniest situation yesterday.
Somebody emailed a public folder we have set up.
On there we have a rule to send a reply saying thanks for your
email -someone will be with you shortly (we have to have this message on -
it is for some website that recently went live).
Now that auto reply went back to the guy who emailed - who must have sent it
from a public folder himself (as he forwarded the original email from a
The guy received our auto reply - and promptly his email system sent an auto
reply to us.
As is the way it is set up - our email system sent him an auto ...Auto date
I am trying to create a field in a form that if anything is changed on it, it
will automatically update the date to current date. Is this possible?
>I am trying to create a field in a form that if anything is changed on it, it
>will automatically update the date to current date. Is this possible?
Make sure the last changed date/time field is in the form's
record source table/query. Then use the form's BeforeUpdate
Me.lastchanged = Now
MVP [MS Access]
You can do this in the On Dirty event of the form, which fires as soon as you
m...External Mail Wont Send Out From New Server
We are performing a swing migration to new hardware. The original server is
win2003 with exchange 2003 sp2. The new server is win2003 with exchange 2003
sp2 as well. I also have another temp server configured as a front-end with
win2003, exchange 2003 and sp2. I installed the new replacement server into
same org and it shows in the admin console. I am able to move mailboxes from
the original server to this new server and receive incoming mail both
internal and external after homing the mailboxes on the new server but when
I try and send email to an external address from an...Auto-Alphabetize
I have a master data sheet, with columns of different information.
I'd like to pull information from 3 different columns
(Rank,LastName,Shift) into a separate column (I know how to do this).
What I would then like to have happen is, in another separate column,
have the information sorted alphabetically by last name. There are
duplicate last names, in which case I'd like them sorted in rank
order. Is this at all possible? Also, I can't use a VB Macro - it
needs to be in a formula or array format.
PO Smith B/1
...address data base in which I can choose which to use for mailing
I want to set up an address data base in Excel. They would be a combination
of personal and business addresses. I want to be able to separate them for
the purpose of printing mailing labels. I am new to Office, could someone
suggest a template or solution ? Thank you.
Open a new workbook.
In Sheet1 you will enter your titles across the row in individual cells.
LastName FirstName Address City State Zip (and whatever else you wish)
Last column title it Type
Now assuming John Doe has two addresses...one personal and one business.
Row 2 enter Doe John 123 main st. Albany NY ...E-mails clipped when printing
I've seen this a few times and there must be a simple fix but I cant
I'm using Outlook 2003 with Word as my e-mail editor.
I view an incoming e-mail on the screen and it looks fine.
I print the e-mail and the first letter on every line is not
printed.... (actually, if its a big letter, then part of it may be
This can be printer driver error, how many printer do you use - if you have
more than one - can you try to print on the other. Try to update or downgrage
If you have a laser printer - try to install an earlie...Junk E-mail Reporting Tool for Outlook
Microsoft is now offering for download a free "Junk E-Mail Reporting Tool
Version 1.0 for Microsoft Office Outlook." It is described this way ...
"Microsoft Junk E-mail Reporting Tool submits e-mail to Microsoft when you
explicitly choose to do so. If you receive a junk e-mail and want to report
it to us for analysis, first select the e-mail in Outlook and then click the
junk e-mail button on your tool bar. You will see a pop-up window asking
whether you want to report the selected e-mail to Microsoft and its
affiliates. When you click "Yes" to confirm that you&...Slow response times in IE 8
I'm running Windows Vista SP2, 64-bit, Internet Explorer 8. For the past few
days I've noticed a markedly slower response time in opening new tabs, either
by clicking on a new tab near the top of the page, or by ctrl-clicking a
hyperlink (it takes 15-20 seconds, compared to almost instantaneous before
this started). Also, when I first open the browser, it's unresponsive, i.e.,
I can't type in a url or open a new tab until my home page begins to load.
One of my first thoughts was malware, but I'm running Defender and AdAware,
in addition to my anti-virus sof...Cannot add sound or video any more to Outlook E-mail (Word Mail) message!
Using Windows XP Pro and Office 2003. Recently updated both to their newest
service packs. (including xpsp2).
Word (2003) is set as my e-mail editor for Outlook 2003.
Before I could add video, audio, or marquee text to an Outlook E-mail
message by clicking on the appropriate icon on the "Web Tools" toolbar.
Now when I click on one of those icons, I get an error message like the
The object was created in HTMLInlineVideoCtl.
This application is not available to open this object.
Make sure the application is properly installed, and that it has ...