sending mail using an alias email address
We are using Exchange Server 2007 with Outlook 2007 clients. I have several
email addresses listed under my mail account on the Exchange Server for which
I "receive" email. However, the server will not allow me to "send" email
using any of these email addresses - as it only allows me to send using the
primary address for my email account. I get a message saying "You are not
allowed to send this message ... on behalf of another sender without
permission to do so." What settings do I need to change on the Exchange
Server so that it allows Outlook 2007 ...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
I have a form which the user selects the BlockNo.
The other information that is entered in the form is :
1) NoOfRecordedTrees - RT
2)NoOfSurroundingTrees - ST
When the BlockNo is entered, a query runs which picks up fertiliser
rates for this Block for all sectors within that block.
With RT and ST - it should do a calculation such that it uses Rate/
sector * (RT+ST) to find how much fertiliser is needed for each sector
in each block.
I would like to add a column to the existing query showing
FertiliserAmt using these parameters. How do I specify them within the
Thanks for your great...outlook 2003sp3: applying the inbuilt junkmail filter on existing messages?
would like to apply the outlook junk mail filter, with settings set to
'high', on emails already in my inbox. is there any way of doing this?
apologies if this has been posted before, I've made a couple of
searches but can't find anything...
No, there's no way to apply the spam filter to already downloaded items.
<email@example.com> wrote in message
> hi all,
> would like to apply the outlook junk mail filter, with settings set to
> 'high', on emails already in my...Autofilter Autoupdate
I have a spreadsheet that needs to gather information from one worksheet
based on certain criteria and feeds it to another. I have tried setting it
up so that if one row of data has an X in the end column then that row of
information is copied over to the new worksheet. I run into empty blocks
when I do this, however.
I next tried to have all the information duplicated by cell reference over
to the new sheet and apply a filter so that only the X rows shows. While
this works, I want to be able to hide the column that's being filtered from
the user. Also, as more rows are added t...Word 2007: word count wrong?
I have an issue with some .doc files when opening in Word 2007. In some
cases the word count in the status bar is different of the word count of the
"Word Count"- window (CTRL+SHIFT+G) or the word count in Word 2003
Example file: http://go.microsoft.com/fwlink/?LinkId=79595
Word 2007 (status bar) show 61019 words
Word 2007 (Word count window) show 61010 words
Word 2003 also show 61010 words
This issue I have not with all documents, but only with some files and it
seems that I have this problem only with .doc files but not with .docx files.
(installed ve...Finding all queries which use a table
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is
old and outdated. I want to see which of the 500 queries in my database use
this table without opeing every single one of them?
Sounds like a variation on Search/Replace. Try searching online for
"Database Documenter" as a starting point.
A couple of the commercial tools I've used include FMS, Inc.'s Total Access
Analyzer and Black Moshannon's Speed Ferret. There are a lot of fr...Re: Using alias address
Brian Tillman wrote:
> Vince <firstname.lastname@example.org> wrote:
>>We use an exchange server at work for e-mail. I have set up an alias
>>that I use for receiving mail but I wanted to use the alias for
>>sending all the mail as well. I was told that it cannot be done in
>>exchange but I can use a POP server.
> I don't believe that's always true. For example, I have several
> Outlook where I work, all within the same profile. Only one of those
> accounts, the Exchange account, uses my work address. The ot...how can i set up my pop and smtp account using proxy server in ou.
"Abhishek" <Abhishek@discussions.microsoft.com> wrote in message
You'll need instructions from your ISP.
Ben M. Schorr, OneNote-MVP
Stockholm Consulting Group/KSG
Microsoft OneNote FAQ:
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
...Intelligent Message Filter Installation Failure
I've tried installing the Intelligent Message Filter on a
Windows 2000 SP4 Exchange 2003 SP1 server. The
installation fails at around 98% with the following
error: There is a problem with this Windows Installer
package. a program run as part of the setup did not
finish as expected. contact your support personnel or
I tried downloading it again, and had the same results.
...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...Count # of cells b/w cells ...
I have the following data in a column: 7 0 0 0 7 0 0 0 0 0 7 0 0 7 0
0 0 0 0 0 7 etc.
The number of zero's between the 7's is random. I want a formula tha
would count the number of zeros between the 7's.
AriBari's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2504
View this thread: http://www.excelforum.com/showthread.php?threadid=38806
Assume A5:A20 is the data, try this:
B5 = A5+B4 (copy formula down)
Now make a table with 2 column...Excel 2003 Copy/Paste filtered column
I have a filtered column on my spreadsheet. I have copied the column,
changed the figures and then tried to paste it back on to the filtered
column. It is not copying over the original filtered column but rather over
cells that have been filtered out. The worksheet/cells are not protected.
What could the problem be?
That's the way pasting works. It'll hit the visible and hidden cells.
> I have a filtered column on my spreadsheet. I have copied the column,
> changed the figures and then tried to paste it back on to the filter...Intelligent Message Filter (IMF) SCL for Junk E-mail being ignored
I have Exchange Server 2003 Enterprise SP1, and I recently downloaded and
installed Intelligent Message Filter.
In Message Delivery Properties -> Intelligent Message Filtering, I have
- Gateway Blocking Configuration
- Store Junk E-mail Configuration
All users have Outlook 2003 Professional installed.
Although I have SCL set to 8 for "Store Junk E-mail Configuration", Messages
with SCL 6 and others with SCL as low as 3 are being sent to the Junk E-Mail
I am able to see the SCL of the emails because I installed an SCL Column via
Forms using th...Creating Contacts For Accounts Using...
Hopefully as Microsoft CRM matures, many small time saving features will be
added. One that should be a priority is the ability to add a new contact for
an existing account using the common account information, i.e. address, phone
number, web address, etc. Retyping the same company address in each time is
not very productive. Thank you, Ed Podowski
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, f...Scroll horizontaly with mouse, create same system used to scroll .
I think it would be great if mouses adopted a second scroll button, for
horizontal scrolling, just like the vertical one .... Indeed, when you work
with wide Excel spreadsheets, you can easily scroll down but to scroll from
left to right or vice-versa, you have to use the scroll bar or arrows and
So, am I a millionnaire yet???
> I think it would be great if mouses adopted a second scroll button, for
> horizontal scrolling, just like the vertical one .... Indeed, when you work
> with wide Excel spreadsheets, you can easily scroll down b...count if a match occurs
I have two rows - say Row 1 and Row 2.
In the first row I have a answer key.
In the second row I have answers from a student.
I would like to write a formula where it counts how many answers student got write.
Here is a example:
Row 0: Q1 Q2 Q3 Q4 Q5 Q6
Row 1: 1 4 2 3 4 1
Row 2: 3 4 1 3 4 1
So student marked 4 questions correctly: Q2, Q4, Q5 and Q6.
Hence, the formula should return 4.
I know one way to do it but I am sure there is more efficient way to do it.
The way I know: Use if statement to compare two corresponding entries and output 1 if...Outlook first use
Hi, when I open Outlook in a workstation for the first time, Outlook open
setup and ask user to create a new profile. I have a utility to create
profile automaticaly and this setup is deleting existing profile. Is it
possible to Outlook don�t ask to create a new profile for the first time?
...Problem with vba code to export query result in excel
I have a access report that exports to excel with click of a button after
choosing parameters. This works well. However I have to modify couple of
fields to utilize formula in the export module. I am not sure how to do this.
I am writing the above code which seems to cause problem. I appreciate any
help to resolve this issue. Thanks.
If lngColumn = 12 Then
xlc.Offset(0, lngColumn).Value = =([UnitPrice]*[OriginalShippedQty])/1000
It seems the fields UnitPrice and OrigianalShippedQty are not being
>I have a acces...Autofilter on protected work book?
Autofilter works on a protected workbook, but not when it is a line in a
Selection.AutoFilter Field:=1, Criteria1:="YES"
It cause a macro error. This is true even if I enable 'Allow all user of
the workbook to Use Autofilter'. I'm sure I've done this before and it
worked, but not now.
Does anyone know if this is a bug in 2003? Or a way around it? Or another
way of selecting a number of rows by a single criterion (in a macro)?
Good morning Muppet
Does this article help?
-- ...Count Age Grouping
I have an access 2k database in which I need to count groups of
records of individuals by that age groups such as
14- 20 no of individuals
21-30 no of individuals
31-40 no of individuals
41-50 no of individuals
51-60 no of individuals
61-70 no of individuals
71-80 no of individuals
80+ no of individuals
I have both DOB and Age fields in the table
I have tried several queries but with no luck and ideas
On 19 Mar 2007 16:51:49 -0700, "Nemesis_uk" <email@example.com> wrote:
>I have an access 2k ...Count the text in a column
I would like to count the text in a column then for it to add a figure in
another cell if it meets the text criteria
Do you mean count the characters?
as an array formula (committed with Ctrl-Shift-Enter)
(remove nothere from the email address if mailing direct)
"Peter Curtis" <PeterCurtis@discussions.microsoft.com> wrote in message
> I would like to count the text in a column then for it to add a figure in
> another cell if it meets the t...Junk E-Mail filter unavailable in online mode
We had Outlook 2003 clients on an Exch 2000 server, and, as expected, the
Junk E-Mail filter was not available when working in online mode. In cached
mode it was working fine. Now, after upgrading the organization and server
to Exch 2003, the Junk E-Mail filter is still not available in online mode.
According to all the MS documentation this should be working.
All of the documentation that I have know of says that it works on in Cache Mode. Can you give us a link to the documentation that you saw that shows it will work with online profiles?
Matth...Calculating Correlation using arrays
I have a sheet full of data for many products in chronological order.
Column A is Date of manufacture
Column B is time of manufacture
Column C is the product
Column D is a measurement from the automatic control system
Column E contains occasional manual measurements for calibratio
Up till now I have split the data out by grade and checked calibratio
using pivot tables and also checked slope and offsets. After gainin
exposure to all kinds of clever functions via this board I now wonde
whether it would not be possible to automate these checks in some way
ie on a separate sheet I list t...can I use 11 x 14 paper in office documents?
Is it possible to use a larger sheet of paper when using publisher?
Yes. First select the paper size in the Printer Setup.
"Prairie Inn" <Prairie Inn@discussions.microsoft.com> wrote in message
> Is it possible to use a larger sheet of paper when using publisher?
If your printer can handle it, yes.
MVP Microsoft [Publisher]
How to ask a question
"Prairie Inn" <Prairie Inn@discussions.microsoft.com> w...