multiple calendars 01-13-10
I have 2 calendars.
How do I overlay the calendars and print a composite?
How do I move all data from 1 calendar into the other so that I can delete
the 2nd calendar?
Can you tell us your version as the functionality varies between versions.
To get you started copying from one folder to another...
open the Calendar you want to empty | view in By Category view | select all
| drag to the destination Calendar and release.
Are you sick of bad email practice? Get a copy of my paper "Implemen...Problem with VBA and assignment of a value
I have a form w/subform and need to display the average of one field
(AverageAge) and the count of records in the subform on the form somewhere
else than in the subform. I calculate AverageAge as Average([Age] in the
form footer. I get the record count using the recordCount property o the
The problem is that I can't sem to get the value 'AverageAge' into an
Me.AvgAge = Me.Team_Members_subform.Form.AverageAge produces the error
Application-Defined or Object-Defined error.
Me.AvgAge = Me.Team_Members_subform.Form.Age gives me the correct age f...Table format
When I run the code below I get "External table is not in the expected
format" error at line rsData.Open sSQL, sConnect, adOpenForwardOnly,
Public Sub SelectFromAccess()
Dim rsData As ADODB.Recordset
Dim sPath As String
Dim sConnect As String
Dim sSQL As String
'Clear the destination worksheet
'Get the database path (same as this workbook)
sPath = ThisWorkbook.Path
If Right$(sPath, 1) <> "\" Then sPath = sPath & "\"
'Create the connection s...Problem with converting Quicken to Money.
I am a new user of Money, I just installed it and converted all of my Quicken
files over. When I began to enter my recipts I was warned that there was
already a weekly "recurring payment" related to that receipt. It ends up
that more then half my receipts got the same warning. When I viewed the
Bills area most days were filled with recurring payments. What is going on?
Anyone else have this problem after converting from Quicken?
...how to arrange list by first or last name
I am trying to make a list with first, middle, last name , street address,
and phone numbers. I like to know how you can review the list by any
combination of first name, last name, city, state, and or phone number?
can you give examples of how your list is layed out.
i am thinking a helper column with an extraction formula might work.
> I am trying to make a list with first, middle, last name , street address,
> and phone numbers. I like to know how you can review the list by any
> combination of first name, last name, c...Index Match Problem
I'm using the following formula, but it's returning #N/A:
=INDEX('File X'!$F$1:$F$2000,MATCH(1,($B5='File X'!$A$1:$A$2000)*(S$4='File
However, if I replace the S$4 with "7710", it returns the correct value.
The number in S4 is 7710. Why won't the formula recognize the cell
reference, but if I type the contents of the cell manually, it works? I
double-checked to make sure nothing was entered as text.
is 7710 a number typed or imported, check if you don't have blank spaces in
one of the two cells you ...POP should allow blanket PO's with multiple items from 1 vendor
Clients have requested this multiple times and it is probably time to post it
In the creation of a Blanket PO, current functionality only allows the entry
of one item. In many cases, a client needs to be able to creat a blanket
purchase order for a single vendor that has multiple items (SKU's) and the
ability to release selected items and quantities as needed.
In other situations, a client would also have a price point/contract from a
vendor that if they order x number of items at a time they can obtain a
better price. But again, current functionality does not allow this ...Last name, first name
I have a list with lastname, firstname in a cell. I would
like to change it to firsname lastname. Any clues?
Insert a column after your name column, highlight the name
column, go to Data, Text to Columns, Delimited, select
comma, finish. This will give you two columns, lastname,
firstname. Insert a column before your lastname column.
Move the firstname column to the new column. Your third
column should now be blank. Enter in the formula
=CONCATENATE(,A1," ",B1)in the third column. This will put
your firstname space lastname in the third ...problem with pivot table
I am trying to make a pivot table from my date.
My data includes Names, Dates (which I formatted to month, "m" in the
format cells option)and Amount due.
In designing the pt, I have "Name" in the row field, "Date" in the
columnn field and "Amount due" in the Data field.
I want my data to be grouped as follows:
1 2 3 4
Name $100 $20 $30 $20
Instead I am getting more than 1 month column i.e.
1 1 2 2 2 3
Name $80 $20 $30 $20
Do you know why...Problem with Pie and Doughnut Charts
I have a couple of doubts in charts:
1) I have a graph where the Column and line charts are plotted on the
same axis. I have got that correctly as well. Now, the problem is I
want to display selective "Data Labels" on the *line graph*. How do I
accomplish this task? (Actually the values for my line graph are same,
hence its just a stright line. And I donot want the same value to be
displayed again and again. I need just one data label on the beginning
of the line)
2) Problem with Doughnut Chart: I have my "Category labels" on multiple
rows (each value is typed in 3 ...Strange problem in BP Portal for GP10 with Queries
I just had a user come to me and tell me he is getting an error on the sales
page saying the query does not exist. This is the out of the box query that
has not been modified. When I go into query organizer I find the Purchase
Order Line Item folder but it now has a (1) beside it with the query inside
it. What causes the folders to be renamed. While looking at the queries I
multiple folders with the (1) out beside them. Thanks for any information
you can shed on this.
Content-Transfer-...How do I avoid this problem with rule?
I have a rule that looks for "hot" in the subject and moves that message to
a spam folder. The problem is that if photo is in the subject, the rule
sees "hot" in the word photo and moves the message. How can I tell the rule
to look for complete words?
Depending on the version of Outlook, you may be able to use the Exception
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer
Brett <firstname.lastname@example.org> asked:
| I have a rule that looks for ...Help needed with form problem
Workbook contains several forms of varying style
and function. One form shows the results of 10
recent tests in a countdown fashion, showing just
the results of one test, followed by a one-second
delay, followed by just the results of the second
test, and so on until the result of each of the
10 tests has been shown. Then the program
proceeds on to the next step by calling up a
different form. The problem . . .
Sometimes when the program starts running one or
two of the forms are blanked out ("white" with just
the top header showing). The forms continue to
function within the ...Insert Data From Multiple Worksheets Into One (With Criteria)
Ok, I have created a sales report list that tracks what customers we are
contacting, how we are contacting them, if they are a new or existing
customer and if we sent a quote, along with some other details. There is a
worksheet the salesmen fills out for each day of the month (its linked to a
calendar) and that all goes into a "dashboard" that shows the breakdown with
graphs. Now what i would like to do is have another worksheet list all the
customers that we sent quotes to so they can mark if the quote was won or
lost , state sales projections and give reasons why won ...Outlook 2002 connector: problem connecting with Domino server because of NAMELookup2 problem
I'm trying to use Outlook 2002 Connector to connect with a Domino R5
server, but I can get no connection.
From the log file I see that the connector uses a NAMELookup2 with the
correct Domino server to get the name of the mail file, but the name
its gets back is corrupted. There are spurious characters at the end
of the mail file name.
From the MSOCLog.txt file
<<67c 25 16:37>> User name : : CN=Jean-Paul Smeets/O=Someorg
<<4f8 25 16:37>> NAMELookup2 called with m_pServerName=someserver
Flags=0 pNameSpaces=0x13646F4 NumNameSpaces=1 pNames=0x12E6CC
NumNames=1 ...Invalid sender domain
Your message did not reach some or all of the intended recipients.
Subject: RE: Boat
Sent: 4/17/2006 11:19 AM
The following recipient(s) could not be reached:
'Fahlahas@Surgv.com' on 4/17/2006 11:19 AM
554 Fahlahas@Surgv.com: Recipient address rejected: invalid sender domain
Dan Klinge <Yomama@kdkdjkfjdekfjdkfj.com> wrote:
> Your message did not reach some or all of the intended recipients.
> Subject: RE: Boat
> Sent: 4/17/2006 11:19 AM
> The following recipient(s) could not be reached:
> 'Fahlahas@Surgv.com' on 4/17/2006 11:19 ...Multiple postmaster accounts
Does anyone know how to configure the NDR's to be sent from multiple
We have an exchange 2003 organization running in native mode, containing
three admin groups servicing multiple domains. Is there a way to configure
the account's that send the non-delivery reciepts per domain? Currently all
our NDR's come from the default domain set in the default reciepient policy.
How can we get the NDR's to mirror the domain they were being sent to?
ie: email@example.com or firstname.lastname@example.org
On Tue, 12 Jul 2005 09:59:12 -0700, Nikrep
<Nikrep@...Sending from multiple accounts
This has been asked before but there doesn't appear to be an answer, so
I thought I would try to keep this alive.
I have multiple accounts in Outlook. They all send through the same
SMTP server (this problem goes away when multiple SMTP servers are
involved). All my outbound e-mail is now going out under the default
account name, regardless of the account selected. There is no
authentication on my SMTP server, so that option won't work.
Has anyone found a solution for this yet?
I am an admin in windows 2008 server. However, I am not able to
c:\Users\<user name>\Local Settings\History
Anyone knows how to change the settings so I can access the folder?
"Jack Black" <email@example.com> said this in news item
> I am an admin in windows 2008 server. However, I am not able to
> access the
> c:\Users\<user name>\Local Settings\History
> Anyone knows how to change the settings so I can...Outlook 2000 Password Problem
I have Outlook 2000 on my PC. One feature that I really like is that
can type my password in once and for as long as that particular sessio
is active the program will never ask me for my password again. Once
leave the program the program will then again request the password fo
email authentication. I have just gotten a laptop and I installe
Outlook 2000 on it. The laptop makes me type in the password each time
Is there a way for Outlook 2000 to remember my password each sessio
without checking the Save Password box? Thanks, Chri
~~ Message po...Naming new server
Cana anyone tell me if there are any implication with Exchange 2003 with
having the server physically named "xyz.company.com" and having a cname in
the internal dns that point "mail.company.com" to "xyz.company.com"?
I'd sooner not have to have users needing to know the specific name of the
server they need (whether using pop3/imap/smtp/webmail) but I don't know if
using an alias is likely to cause problems?
On Fri, 27 Jan 2006 02:56:43 -0800, Paul Hutchings <firstname.lastname@example.org>
>Cana anyone tell me if there are any implicat...Problems with Using Word as Email Editor
We use Hummingbird DM 126.96.36.199 for our document and record
management. When using this program, it has a problem
with Outlook using Word as an Email Editor. When this is
turned on, it seems that Outlook opens a different
instance of Word. When you try to open or create a word
document, you lose the ability to save or print. These
features return to normal when you uncheck Word as an
Email Editor in Outlook. I have heard that Microsoft was
taking this up with Hummingbird to have them fix it. I am
just wondering if this was to be resolved, or if it is
Hummingbird's problem to ...Paper size problem
I want to print flyers using Wizard, on A5 Paper. When I use Special Size on
Page Setup to change to A5 sizes and set Printer Properties to A5 paper in
Print Setup, half the content is not printed. How can I fit the contents of
the flyer to an A5 and print.
I'm on Win. ME, Publisher 2000 and Lex.Z32 Printer.
The flyers are only setup for standard size paper like A4. They are not
able to be changed to A5 paper.
You can open two instances of Publisher so you can copy from the A4 page to
the A5 page and re-size the objects on the A5 page.
The US should free all those
illegally held...Query based on multiple parameters
I would like to create a query where the user can input 2 or more parameters
(part numbers), separated by comma and/or space and return information about
that part. I already have a query that accepts one parameter. Is there a
way to do this with more than one?
I have read some posts that say to use a table to serve up the paraments and
the user chooses one or more. However, a particular part or parts may not
yet be in the table as they are new or unknown.
Is there any way to do this without using an existing table but just accept
input from the user on the fly?
T...Multiple chart types on same chart
I have following data in columnar format
Quarter of the year (e.g. Q1, Q2, Q3, Q4)
Geographic zone of organization, e.g. (North, East, West, South)
4 Top selling products of the company (P1, P2, P3, P4)
And eventually the sales amounts for the concerned product in the concerned
zone for the concerned quarter.
I would like to have a single chart that displays on the x-axis the Quarters
of the year. For each quarter the geographic zone data is shown as clustered
bars, and the product info per zone is shown as stacked bar.
Thus visually I will have per quarter the 4 geographic zo...