Spam email going to one user
A user has been complaining of getting junk email that are not addressed to
her but in the TO field is addressed to random addresses. For example:
firstname.lastname@example.org, email@example.com ... etc. PLease help because I'm a
novice at Exchange and don't know why she's the only one getting this. How
do I fix this? Thanks.
What product are you using for anti-spam?
On Thu, 7 Apr 2005 16:59:19 -0700, "Geeo" <firstname.lastname@example.org>
>A user has been complaining of getting junk email that are not addressed to
>her but in the TO field is addres...Pulling Specifcic info from worksheet to another
Here is my dilemma. I have two worksheets. One with records that include first name, last name & company. The second worksheet has first name, last name, company and email address. I am trying to 'fill in the blanks' on worksheet 1. What
I want to do something that says if first name & last name & company name match in both workbook 1 & workbook 2, then place the email address found in worksheet 2 to the appropriate cell in worksheet 1.
Is it possible?
...Page Numbering Within Sheet
I have a complex header that I need to be part of the sheet and cannot put in
the header section so I have put it in and used Repeat Rows at Top of Page to
ensure it is on every page.
I would like to insert the page number in Cell J5 (within the Repeat Rows
area) and would like it to change on every page.
Is there anyway this can be done?
I'm not an advanced user, can copy and paste a macro but do not know how to
write my own or use VBA.
hi, Kathryn !
> I have a complex header that I need to be part of the sheet and cannot put in the header section
> so...AND IF STATEMENT
Hi I would like to do the following but have no idea what the format
of the formula should be so any help appreciated:
So I want cell EP86426 to contain the word standard and I want the
cell AA86426 (which in itself has a formula which returns 1 or 0) to
be greater than 0. this part of the formula works but I also want to
look at cell CK86426 and if its value is greater than zero I want it
to return a 1 in cell AB86426
I hope that is clearly explained lol
Thanks in advance
"Sam Hamman" <email@example.com> wrote:
...auto numbering/sheet of cards
Have to make some cards up. I need to do several on a sheet, when I set it
up to do more than one card, how do you do it so it numbers them, say
starting aat an odd number, then in numerical order from there?
Build a database with consecutive numbers and use mail merge. Help here:
You can use Excel, Access, a Word table or Publisher to build your list. There
are other databases.
Mary Sauer MSFT MVP
"Bruce" <notreally@idontw...IF statement greater than and less than
I would like to drop values into 5 columns AC-AH depending upon the
value entered into column N.
The ranges will be
I have successfuly done the first criteria based upon one argument
(less than 4999)
However, the next band i am struggling with the greater and less than
within IF - HELP please!!!
This is what I have but not working....
thanks in advance
Test the borders just outside:
Gary'''...adding data table with different data to a graph
I have created a graph and I know how to add a data table to the bottom that
has the data in the graph. However, I wish to put different data in that
table. Is there a way to do that?
You can similate the effect. See
Custom Chart Table
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
In article <4DC8A259-AB15-4AB5-8805-03AE6D173CD1@microsoft.com>,
This formulas says if A1=0, make it 9 and subtract 1
How do I make it say if A1 equals 0, make A2= 5 and if A1=5 make A2=0
But there are 5 conditions. They mirror each other. Example: a 0 is a
5 and a 5 is a 0.
1= 6, 6=1
How do I make the cell meet all of these conditions.
Thank you for your help.
tenaj's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32691
View this thread: http://www.excelforum.com/showthr...How do I count selected data in a report footer
Am attempting to count the number of conditions in a data field with a
certain stated value; in a group summary and then a report summary (i.e.
count the Number of records where the sum of hours is between 0 and 24).
I "sum of hours" an aggregate total or a field in the report's record source?
If it is a field, you can use an expression like:
=Sum(Abs([sum of hours]<= 24))
Microsoft Access MVP
> Am attempting to count the number of conditions in a data field with a
> certain stated value; in a group summary and then a r...Statement download problems
Ever since I have ran the GDI Plus scanner tool (I had
already installed XP SP2) Money 03 will not download my
I can save them to my computer, but previously I had been
opening them when queried, and the updates were then
automatically made to my file. But now nothing happens -
including not getting the "your file has successfully
been updated" message.
Can this be fixed? Is there some new security setting?
OR, can someone give me the instructions for saving the
download, and then getting Money to update my file from
In microsoft.public...Paste link only
I have worksheet (destination) in which several cells are linked to a
worksheet (source) in another workbook. My destination worksheet has
not been updated with the latest values in the source sheet, so all
the cells are filled with 0s, etc.
Cell D2 in my destination worksheet is currently linked to V2 in the
source worksheet. I'd like to make E2 be linked to V2. When I click on
V2 (source), choose Copy, click on E2 (destination), and choose Paste
Special > Paste Links, two problems occur:
1. The link is copied but it's copied as $V$2 (whereas all of the
other links don't have...Cannot update links
I have an excel file that is on a ssl website and it has links to other excel
files on the same site.
I use Office 2003 to update the links in the file. The first problem I have
is that the update proces is very slow. The other problem I have is that for
some of the links I have to open the source file to be able to update the
How do I choose every ninth row to be my Y data on a
chart? I have 15,000 rows so picking one individually
will be time consuming.
Jon Peltier has instructions for this in his Excel Charting FAQ article:
> How do I choose every ninth row to be my Y data on a
> chart? I have 15,000 rows so picking one individually
> will be time consuming.
Excel FAQ, Tips & Book List
...Reading Newsletter with Links
I am creating an email newsletter for my school alumni. I have no problem
linking text boxes when I create the newsletter..however, when the text box
is NOT selected there is no means of toggling to the continuation. No place
to click.. I tried emailing the newsletter to myself and all I see is the
message, continued on page 2 but no means of toggling to the continuation.
You cannot create a two "page" email, try making the newsletter physically
longer with File | Page Setup - if that's what you are trying to do.
"Chris, Hudson Valley" <Chris, Hudson ...Graff data series
I have a graff for sales.
Data series 1 = Budget
Data series 2 = Actual
I want the value that is shown with data series 2 to be a % of the value of
data series 1.
...pdf links #2
how do i create a link that when you click on it, it will open the pdf
document in a new window?
I am trying to find a way to write and if/then statement. I have a
column(A) with gas stations (MoBil, Citgo, Etc) next to it I have a
column (B) of gas MPG. I want to average each type of gas. So I was
thinking of adding a column (C) for each type of gas. If A#=C(header),
THEN place B# in C#. I can then take and average the column. I just
don't know how to write it? OR is there a simplier way to write it?
bhowe's Profile: http://www.excelforum.com/member.php?action=getinfo&user...e-mailing linked files
Hi, I have an Excel spreadsheet with a hyperlinked image (.tif) on each
row, total of 85 rows. The image opens when clicked.
How can I e-mail the spreadsheet file and transport the linked files
(images) with it so that it will ope nin the same way for the
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
They will work if the receiver put them in the same named folder in the same
location. Alternatively, you will have to write some code that o...0x80191002 error synching one of hotmail accounts
I've used wlm for over a year now. For a few days now I have been getting
0x80191002 error for one of the hotmail accounts. The mail is not getting
Other hotmail accounts and pop ARE unaffected.
After research in this group I've tried 1. emptying outbox and deleted
folders and doing message store compaction 2. deleting
HKEY_CURRENT_USER\Software\Microsoft\Windows Live Mail\SearchFolderVersion to
fix possible quick view problem 3. moving message store to new location with
tools/options/advanced/maintenance\store folder 4. waiting a few days.
All to no ava...Another UI thread question
I'm wondering if I'm doing my message handling all wrong. Currently
when I send my thread a messages (using postthreadmessage from my main
app.) I handling it in the PreTranslateMessage function. While reading
the MSDN I noticed that it said that all messages come in to the run
function and are then passed on to the PreTranslateMessage function.
Is this true? What are the remifications of leaving it like it is if
> I'm wondering if I'm doing my message handling all wrong. Currently
> when I send my thread a messages ...Linking to a lead
I'm trying to link to a lead and it basically works like
But that menubar on the
left "Information" "Activities" "Notes" won't work
properly in that new window. Instead of the activities or
notes listing the links will open a "New Lead" form (with
a second top menubar...) in the frame on the right.
Can someone help me make this work?
...read struct data error!!! urgent!!!
Hi ,I have a program like the following lines, my question is when I execute
the program in VS6 environment ,it can execute successfully and correctly,
but when I recompile this program is VS2005 environment, the program can
still run, but the result is not correct! Could anybody tell me why?
//--codes starts here
typedef long PRICE;
typedef unsigned long AMOUNT;
typedef double MONEY;
AMOUNT Mone...formatting using VB If statement
I have the following code on the On Format property of one of my Headers on
Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
If ChangePri = True Then
Priority.BackColor = vbGreen
Priority.FontWeight = 800
Priority.BackColor = vbWhite
Priority.FontWeight = 400
If min = True Then
sono.BackColor = vbYellow
sono.FontWeight = 800
sono.BackColor = vbWhite
sono.FontWeight = 400
If missed = True Then
QtyShi...test for exernal links
Is it possible to test if a workbook has external links to another workbookl
what i am trying to do is display a message when a user closes a workbook
saying the workbook has external links.
How would i code this??
I believe there is a security setting that does this check when the workbook
"hervinder" <firstname.lastname@example.org> wrote in message
> Is it possible to test if a workbook has external links to another
> what i am trying to do i...Address updates
I have many contacts linked to an Account. So ... I get a new account address ... do I need to drill into each record and update each contact .... or is there a way to link them, or auto update related records