Merging List w/ a Form
Can anyone assist me with merging a form created in Excel
with a database (or list) also created in Excel? I know
how to merge an Excel worksheet to be used as a database
for Word in the Mail Merge command, but my FORM, with
which I am trying to merge my database, was created in
Excel and needs to remain under its format (not be
converted to Word). I am filtering the information I need
from the database to be imported to the Excel Form.
Any help would be appreciated. Thank-you.
If you're trying to display information from one record in the database,
there are sample files here..."there has been an error reading or writing the file"
I have been having numerous problems lately with my Mny delux 2005. 1.
portfolio does not show correct "Market Value" of most securities most of the
time, 2. Lines listing securities on portfolio manager are duplicated and
change upon being floated over by the mouse curser and 3. the program blows
out after displaying the error message, "there has been an error reading or
writing the file" after folowing the intructions at:
http://help.msn.com/(ZmlsdGVyPUNEX0RMWCZwcm9qZWN0PW1vbmV5MDUmbWFya2V0PWVuLVVTJmN1PSZ0bXQ9dG1wOUYudG1wIC0gTWljcm9zb2Z0IE1vbmV5JmtjPSZmb3JtYXQ9)/help...Hiding OLD customers in list
I have a customer list (tblCustomers)
And an Orders table (tblOrders)
I want to have an admin area functionality that prunes (hides from display
in any list or report) Customers from the list that have not placed an order
in X number of days (Admin can enter the number of days in a text box)
Solution does not have to be in days or in a text box. Could be several
check boxes (30 days, 10 weeks, 2 years...).
I am just looking for the simplest solution for us to limit the Customer
list by last order date.
Any help here will be appreciated.
Thanks in advance
If it were me, I would have a ...Sharing tasks, group task list
I have a team of account people who assign tasks to a production team.
I want to create a shared task list that I (and others) can assign tasks
to my team that also updates me when progress on the tasks has been made
(ex. marked complete). I know I can do this from my personal task list,
but is there a way to have a shared task list where items can be
assigned and will also be updated through exchange? Public folders
Using Outlook 2003 on exchange server.
Set up a shared Mailbox and make Tasks there, Assign them to team members.
In that Tasks folder, show t...Outlook 2002 "The remote Procedure call Failed"
I have found many posting of the error occuring but none of them have
answered my situation.
OS: WinXP Pro SP1 (can't install SP2 until updates for CAM software
Office: Office 2002 updated (Server running Exchange 2003 Stand.)
AV: Norton Corp v8.0 updated
Open Outlook/ create new mail / click the TO: button...
system waitings and reports "The remote Procedure call Failed" and
Outlook shuts down...
I know that there is no virus on this computer many different AV
products scans confirms this.
Client currently using OWA to email...
Any th...Question about what "Home" means in the Home and Student Edition
I was wondering if someone could answer a question for me please.<br>
I am seriously considering buying the "Office 2008 for Mac - Home and Student Edition" and I want to check what is allowed by the EULA.<br>
I like the 3 licenses because both my wife and I have a Mac and would be able to use Office 2008.<br>
However, both of us receive both "work" related email as well as "personal/home" email (we each use one email address for everything). Also, occasionally we might write a �work..."Configuring Microsoft Office Basic 2007" every time I start
I added memory to my PC and Office 2003 started to misbehave (and it could
not find a CAB file that was on the CD) so I removed it and upgraded to
Office 2007. Now every time I start my PC it spends time configuring
itself. I might add iTunes is the same. It means starting the PC is an
even more laborious process than usual.
Oh, and I have some annoying update to XML something or other that does not
install either, and does not go away.
It is ironic that the extra memory was to improve perforamnce. Every step
forwards involves two steps back.
Apart from swapping to App...Can't open file: "The .VBP file for this project contains an invalid or corrupt library references ID"
I'm running Microsoft Excel v.X on a Mac with Panther (OS X). An Excel file
which I used a lot now cannot be opened - it says "The .VBP file for this
project contains an invalid or corrupt library references ID". I have no
idea what this is - it's a single file with just 2 sheets in it, and is
fairly simple - no links to outside objects, no graphics, etc. Just a single
file. What can I do to get it opened?? Microsoft Word can read it, but I'd
like to keep working on it in Excel... Thanks in advance!
...Quote Bug or property?
I would like to know why it is impossible to add new note to a Quote that
has status: ACTIVE.
I can add notes to Quote that is DRAFTt. But when I chance quotes state
Draft -> Active, in the quote there is no ‘Add Note’ –button anymore.
And why is still possible to modify existing Notes and change the attached
file, but not add a new one?
Are these Bug or Property?
Unfortunately, this is a "feature" of the product.
In general, once an object is in a read-only state, you can not add notes or
activites to the object. I am hoping that this will cahnge in CRM 2005, ...List of Differences Between Outlook 2000 and Outlook 2003
I need to spend 45 minutes introducing Outlook 2003 to my Outlook 2000
Can anyone provide a site with a succinct list (screenshots would help)
of differences between Outlook 2000 and Outlook 2003?
Are you looking for screenshots of Outlook 2003 or ones comparing OL2000 and
Wouldn't you be a more convincing teacher if used both and took the
screenshots yourself? This would help you learn and understand the products
better. (Vmware or virtual pc make this really easy and you could show them
the differences live. :))
Diane Poremsky [MVP - Outlook]
How come whne I put in a contact in Outlook 2004, and then I add a fax
#, it lists the contact twice on my main list?
It's because there is no Outlook 2004.
The standard behavior for the Outlook Address book is to display all
electronic addresses (both fax and e-mail). That behavior cannot be changed.
The only way to prevent the display of fax numbers is to store them in a
different field or to disguise them (e.g., precede them with an alpha
character) so that Outlook won't recognize them as phone numbers.
There are also a number of utilities available that can do this for you
automat...Vista "ipv4 connectivity limited"
We have two Vista PCs connected wirelessly to a BTHomeHub2. Both have been
connecting to the internet fine, until today. My partner now can't get
online. Her machine shows ipv4 connectivity limited. (Both our computers
also show ipv6 limited, but my ipv4 shows "internet" and of course is
It reports the signal strength is excellent. Another message says "the
computer is connected to the BTHomeHub2, but does not have access to the
As I've said, we've had no similar problem before, and have not changed any
se...grabbing emails and paste into dist list?
Okay, here's the scenario in Outlook 2003.
I get an email from someone who has included about 50 important people in
the cc field.
I'd like to take all those email addresses and dump them into a distribution
list in one fell swoop.
So far, I hit "reply to all" and selected all of those cc email addresses,
but I can not paste into a distribution list.
How can I do this?
..."with <string> in sender" clause works on substring (matches on too many senders)
Outlook 2002 SP-3
I don't send myself e-mails but spammers would like to pretend that I
do. They often must put something in the From header to be RFC
compliant, so they throw in the same e-mail address as they shoved in
the To header.
Say I have an account called firstname.lastname@example.org. I define the rule:
Apply after receiving a message
with email@example.com in sender
stop processing more rules
Looks good until you realize the match is on a substring rather than an
exact match on the sender's full e-mail address. The messages do get
deleted if I sen...Filters, Can't Find Exception List In Rules
I'm trying to set up my filters for junk mail. I want
junk mail with certain words in the subject sent to
deleted folder. I found the filters.txt file and some of
the words are already there. So apparently the filter
isn't working. I tried to follow the directions on how to
turn them on and they said to choose the exceptions entry
in the rules wizard but I have no such choice. I know how
to edit the filters.txt file but Outlook is not using it.
Can anyone help?
The Filters.txt file isn't actively used by Outlook -- it's really just a
"readme" type file to sh...Scrolling Tables list
When I use the scroll bar to move up and down the list of tables or queries
etc, the list continues to vacillate after I stop sliding the bar; making it
difficult to find the item I want to select. This seems to be worse with my
new computer. Are there settings I should adjust.
"Crop scout" <Crop firstname.lastname@example.org> kirjoitti
> When I use the scroll bar to move up and down the list of tables or
> etc, the list continues to vacillate after I stop sliding the bar; makin...Creating a e-mail contact list which has "undisclosed recipients"
Can anyone help me with a contact list for my e-mail which
does not disclose all recipients names.
I would like to send an e-mail regarding company
information to several people which answers questions, but
I don't want everyone to know who I am addressing it to.
You need enter the names under the Bcc option when you address the email. That way, each recipient will only see their own name, but the email will go to everyone.
Actually, the recipients won't see their own name in the To field. They
will only see what the sender puts there, if anything (some ISPs require
that you...Rule out "connection pool" trouble...
Probably my ignorance showing, but we are troubleshooting SQL Servers
running on virtualized machines. Three virtual Server 2008 running on one
piece of hardware, each running SQL Server, each with little client
applications that each communicate with all three SQL Servers.
The symptoms seem like "networking issues"; we have very long delays and
timeouts if no activity has occurred for a while, but once the three start
communicating successfully, all is well. Each little client on each server
opens a connection to each of the three servers to do some work...Control Supported Device List for Active Sync
I want to restrict what devices can connect to Active Sync - there is a
built in list of supported devices which the service packs keep updating but
is there a way to control this list yourself i.e. to only include two
devices in the list?
I want to control which devices meet the company standard and stop any which
Overview of mobile devices that are supported by Outlook Mobile Access in
Exchange Server 2003
I got an .xls from someone and had to populate some cells with data extracted
from the application database, which I did OK.
My problem is the fact that the .xls came with something like a button (not
created by me) that I want to delete, but simply can't. I can't select it,
like I can do with the forms controls I'm used to work with, although it
appears to be a normal command-button.
What could that object be? And how could I simply get rid of that?
Ok, I finally found the answer.
> I got an .xls from someone and had to populate some cells with d...Truncated "y" axis label in chart
:confused: Hi guys
I have a problem with Excel, the label on the �Y� axis appears
truncated even though I have resized the chart. Then, I looked the file
in another computer with the same version of excel than mine as well as
in another with a different version and in both look fine. Thus, I
erased and re-installed excel in my computer to no avail. I have also
re-sized the chart and used it both as object embedded and in separate
sheet, it doesn't fix the problem. Any suggestions to fix this problem?
-----------------------------------------------------------------------...Drop Down List for Chart
I have grouped my series into several groups. How do I display a drop down
list including the groups which will dynamically identify which series to
plot on the chart?
Group A = Series 1, Series 2, Series 3
Group B = Series 4, Series 5
Group C = Series 6
Drop down list includes values: "Group A", "Group B", "Group C"
When Group A is selected within the drop down, Series 1, 2 and 3 are plotted
on the chart.
Do you mean you have to plot data, and have the chart move week to week? if
so, easiest way is to use a hlookup/vlookup
"savior1&quo...hwo to recover personal folders and contact list??
I had office 2003 running on my C: drive and I had a major system
crash so I backed up the entire C: drive to D: .. then I formatted and
reinstalled windows XP pro and office 2003. can someone tell me where
on the D: drive I woudld find the contact list and all my folders from
outlook 2003 that I had running before?
please look here, which datas are important for outlook
If you search for the relevant files you could import them into your new
Gestern gings noch, ICH habe nichts gemacht! ;-)
Brave...Customize global adress list column in a new mail
(I have Outlook 2007 and Exchange 2007).
when i create a new mail message, hit the "To" button, my global adress list
window appear when column by default:
Name, Title, business Phone, Location, E-mail address, Company and Alias.
Those column from Active directory of course.
My question is: can I add/remove column in this window? For example adding
"department" from Active directory?
Since this is customized by your Exchange Admin, I would start by asking
him/her if it is possible.
This question can most likely be answered in an Exchange or W...finding common numbers in large lists
Hello, I have two large lists of numbers (on two seperate worksheets).
By large, I mean that one list is 1000+ numbers, and the second list
is 3000+ numbers (each number is in its own cell). The numbers are
of the form:
xxxx.xxx (that is, they are precise up to three places after the
1) Is there some quick way that I can find the numbers that are common
to both lists?
2) Is there a way I can find the numbers in common to both lists using
only the whole number portion (diregarding what comes after the
decimal of each number)?