multiple emails being sent out #2
It appears that when a message is sent through a
> distribution list that sometimes the email gets hung in
> the outbox. Outlook believes that the message has
> to send but does not bring up an error message or
> anything, it will just attempt to send it again approx.
> mins later.
> The sending computer has in its sent items that the
> message was sent at 10:30 AM
> Two of the recieving computers recieved the message at
> 10:14 AM
> 10:18 AM
> 10:20 AM
> 10:22 AM
> all computers recieve the time from the domain
> so that the ti...Multiple Match and return header
I am trying to find a way to Match on multiple values and return the
header a row based on that. I have tried looking at combinations of
vlookup, match, and index and so far haven't been able to figure out
anything that can do what I need. I have a list of data with a
person's name in the first column, and then headers for an action they
took. Then data in each cell is then the date range they took the
action. here is an example:
Action 1 Action 2 Action 3 Action 4
John 2/3/2005 2/5/2006 5/7/2006 9/25/2006
Bob 1/3/2006 5/3/200...Why does a graphic or print multiple times in the same document?
When I print from publisher to my Canon color copier,graphics appear multiple
times in the same document.
This could be many things-
Temp files need cleaning
A simple restart of cpu & printer
A bad printer driver
Check those first.
> When I print from publisher to my Canon color copier,graphics appear multiple
> times in the same document.
|| When I print from publisher to my Canon color copier,graphics appear
|| multiple times in the same document.
Carla, check out the following kb article. This is actually a known bug that
affects the e...Calculated Control Refers to Multiple Reports
I have five reports, which for formatting reasons cannot be combined into
one. They all open automatically with one command and need to be paginated as
if they are one report. The number of pages for each report will differ
depending on the data entered for each record. Pagination for each report
sums the total number of pages ([Pages]) for the previous reports.
The calculated control in the reports looks like this:
report name: Report 2
control name: NewPage
control source: =[Reports]![Report1]![Pages]+1
report name: Report 3
control name: NewPage
control source: =[Reports]![Report1...Easy formula question -sum of 1 cell to end
Thanks for looking .
How do you format a formula to display the sum of, let's say A1 to "however
far down the spreadsheet goes" without having to name an ending cell?
This sheet has no end and I need to display the total in a column that keeps
I hope I phrased this correctly.
You could do it this way =SUM(A:A), that will cover the full column.
"Edward" <firstname.lastname@example.org> wrote in message
> Thanks for looking .
> How do you format a formula to display the sum of, let's say ...How do I auto sum on a form in publisher
I am trying to create a form that would auto sum columns like Excel. I can't
figure it out!
About the only way is to insert the Excel form as an Object.
Mary Sauer MSFT MVP
"Dawn" <Dawn@discussions.microsoft.com> wrote in message
>I am trying to create a form that would auto sum columns like Excel. I can't
> figure it out!
...Problems with Exchange across multiple domains in same forest
Hey all, hoping I can get some help here:
1. Unable to view GAL for separate domain in same forest. Full
GAL shows up in ESM but not in outlook. GAL that does show will update
as new users added to first domain, but not second domain obviously.
2. Unable to authenticate to exchange server from second domain
when setting up exchange connection. When setting up exchange
connection using a user from first domain exchange works fine.
Any help appreciated!
Scott C. Reynolds - Tales From the SharpSide
http://www.scottcreynolds....multiple images in list control #2
I need to insert individual images for individual columns in a list
How to go about this ?
...CRM REPORTS 01-18-07
Hi everyone. I've created reports using Reporting Services. I then imported
these reports into CRM as part of a CRM development for a client. The client
accesses our CRM website through the internet, using an ip address. They are
then prompted for their credentials, which they then enter. They can
successfully enter CRM, but cannot access our custom reports, however, they
can access the standard CRM reports.
I've successfully accessed CRM and the reports via the internet, using their
credentials. Basically, I can access everything from my side, but they can
only access CRM and ...Changing formula in multiple cells or range simultaneously
I am trying to change the value in multiple cells in a
large worksheet simultaneuously. I want to identify the
range and then adjust the formula in the entire range. Is
there a way that I can highlight the range and then change
to formula in each, simultaneously? For example, if I
wanted to double the value in the entire range, how would
I do this?
You could put 2 in an empty cell.
Edit|Paste special|click on Multiply under the operation section.
Then clear out that 2.
But it really depends on what kind of change you're making. If you wanted to
ad...Criteria to return all records if selection from form is null
I'm trying to pass multiple query criteria from form controls. I'm using
the following type of syntax for the criteria:
Like Nz([Forms]![ViewEdit Completed Procedures]![SelectOBy],"*")
And this works fine for the fields where there are no Nulls in the data, but
if there are Nulls in this field I don't get those records. Quite
understandable since Like "*" doesn't return Nulls.
What I'm trying to do is to return all records when there is nothing chosen
in the selection box on the form. I've tried a bunch of different IIfs wi...Outlook Help #11
I am running outlook express 5 for mac.
I would like to no how to put a graphic in with my signature.
What kind of file and how to import it in.
Thanks for any help!!
PrePress <email@example.com> wrote:
> I am running outlook express 5 for mac.
> I would like to no how to put a graphic in with my signature.
> What kind of file and how to import it in.
> Thanks for any help!!
Ask in an Outlook Express newsgroup.
...Excel Array Formula: Multiple Criteria Sum IF Challenge
Currently, I have the following Excel Worksheet
Invc No Code Status Charges RejCode
291 CH no pay 50
291 CH no pay 50
291 PY no pay ded
152 CH no pay 50
152 CH no pay 25
152 PY no pay dat
206 CH no pay 50
206 CH no pay 50
206 PY no pay
507 CH no pay 50
507 CH no pay 45
507 PY no pay ded
600 CH overpaid 25
600 CH overpaid 25
600 PY overpaid ded
I would like to obtain the following results, Total Charges by Rejecte
"no pay" invoices and the specific "no pay" invoices with rejections a
Total Charges by Rejected "No pay"...Fein FBK-1 Filter Bag Kit for 9-11-55 Turbo I
Best price found: http://bestdeallocator.info/index.php?id=B001342J2E
This is a complete kit for converting the Turbo I vacuum to a two-stage filtration system. Remove the cloth dust bag and mount the 1 Micron filter and the dust bag to clean up smaller particulate material with the Turbo I vacuum. This kit includes everything necessary in one package. Great for work with drywall and sheet rock dust as well as other smaller particulate materials.
Fein 913038K01 3-Pack of Vacuum Bags:htt...Count with multiple criteria
I'm trying to find a way to make a small "load" calculator which would count
the current load for each individual based on below data:
A B C D
JJ 4 21/04
JJ 2 19/04
BJ 2 18/04 DONE
BJ 5 16/04
JJ 2 20/04 DONE
BJ 3 24/04
Today : 21/04
A - Individual
B - Hour required to complete task
C - Deadline (week/year)
D - "DONE" if completed, otherwise empty
So the goal is to calculate for each indivual the total number of hours
(from column B) with following conditions:
for Individual JJ sum column B if C equal o...formating multiple worksheet via print preview
I have a multiple worksheet workbook that I need to change
several features about all the worksheets (page
orientation, fit to 1 page, etc.). How can I do this
formating and have it apply to all the worksheets selected
in the group rather than having to do it to each worksheet
separately? Thanks in advance.
Group the worksheets you want to change. Change the relevant settings on one
of them and it will be reflected in the others. Don't forget to ungroup the
"Roger" <firstname.lastname@example.org> wrote in message
news:0...Subform Filter with Multiple Criteria
I've got a subform and can filter via this code:
frmSUB.Form.Filter = strFilter
frmSUB.Form.FilterOn = True
But, it only works with a single criteria, so when strFilter =
[Application] = 'ProgramA'
If I try multiple criteria, I get error 2448. Something must be wrong
w/ my syntax, but I don't know what it could be. Anyone got any
ideas? Thanks in advance -
[Application] = 'ProgramA';[Profile] = 'AMAS'
On Aug 3, 9:35 am, Zilty <ziltm...@yahoo.com> wrote:
> Hi all,
> I've got a subform and can filter via this ...percenatge increase in values across multiple cells
I have a spreadsheet of numerical values and I simply want to increase all
values, in all cells, by 17.5%. Can anyone please tell me how to do this?
Type 1.175 in a spare cell and copy it... Highlight your numbers and then
Microsoft MVP - Excel
"David" <email@example.com> wrote in message
> I have a spreadsheet of numerical values and I simp...Multiple windows
I have opened a workbook in multiple windows (to view side by side) but
would now like to close the additional windows. How can I revert back to
just one window?
Select the window you don't want to see.
to close it.
> I have opened a workbook in multiple windows (to view side by side) but
> would now like to close the additional windows. How can I revert back to
> just one window?
I need to be able to add up all the data in two rows but only if the
follow two conditions. I have tried to use a COUNTIF but it will onl
allow one condition.
the database isnt actually a database, rather a tab that I have one m
spreadsheet. Has anyone any suggestions that could heklp me out??
need to say how many records are there with this row = BD and this ro
Thanks In advance
---------------------------------------------------------------------...SysDateTimePick32 CDateTimeCtrl DTN_FORMAT callback doesnt seem to work with multiple calls to SetFormat
It seems that the CDaqteTimeCtrl (aka SysDateTimePick32) does not work
SetFormat is called more than once
using a subclass of CDateTimeCtrl (e.g. class XDateTimeCtrl : public
with ON_NOTIFY_REFLECT(DTN_FORMAT, OnDtnFormat) and
with this sequence
OnDtnFormatQuery pszFormat="X" setting szMax=(7,14)
OnDtnFormatQuery pszFormat="X" setting szMax=(7,14) <<<<< not sure why
the control sends 2 DTN_FORMAT...multiple .rc files
Is it possible to maintain multiple .rc files in a project? If so, how do
you edit them? compile them? How do you get them attached to your code? All
this stuff was set up years ago by the wizard.
I am maintaining one set of dialogs and my buddy is maintaing some others
but they are both in the same .rc file and we have several times needed to
add or change one of our dialogs and the other person has the .rc file
You could copy the current resource file and split out the dialogs that are
maintained by the other individual. Then rename that resource file with the
...DLookup with mulitple criteria
I get a "Run-time error '2001': You canceled the previous operation" on the
second line of my code. If I remove this line of code, everything works
fine. I'm trying to locally retrieve all the ID numbers where the part
numbers are the same to be displayed in a pop up message in this afterupdate
event. Any ideas why I am getting this error message? Thanks!
Private Sub Part_No_AfterUpdate()
FirstID = DLookup("[ID]", "Part No for ID", "[Part No]= ' " & Me.[Part No] &
" ' ")
SecondID = DLookup(&...Macro button
Does anyone know how to add a macro button to the toolbar of ever
user's copy of excel automatically?
Can this be done with a registry file all users execute, then restar
carl0s66's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1662
View this thread: http://www.excelforum.com/showthread.php?threadid=31490
Create a Add-in with code that create the button and install this add-in on the users machine
How to customize menus and menu bars in Ex...Office 2003 and Windows 7 12-18-09
I've just bought a new laptop with Windows 7 64 bit and I loaded MS Office
2003 and added SP3. It seems to work OK but I have not yet explored the outer
Dell Tech support tells me that Windows 7 will not run Office 2003, so I am
on the look-out for problems but have not yet found any.
What experience does the forum have?
My first reaction is that Microsoft is not that stupid, but I am a former
employee and long time user of their products, so...
"MichaelRobert" <MichaelRobert@discussions.microsoft.com> wro...