Formula to get data from files #3
Thanks for the reply.
Using your formula, I get the filename and the cell number in C, bu
how do I get the results of that cell number.
I need to type the name of the file in A and a certain cell of tha
file in B and have the formula go to that file and get the value o
greasybob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=792
View this thread: http://www.excelforum.com/showthread.php?threadid=26321
...How to create a list of data from the mail merge
I used Publisher Mail Merge to create the envelopes for a
wedding. I want a master list of all the addresses. How
can I get this?
Please help soon!!!
That is a major issue with the flawed Merge database in Publisher. It is
not at all advisable to use the database built into Publisher. You should
use an external database.
Possibly the easiest way for you will be to install the Generic Text printer
and setup a Merge to a small label size.
You can then print that to the Generic Text printer and open the file in
Notepad and get all the names.
If you want you can e-mail me the *.MDB file and...I imported messages from Outlook Express to Outlook 2002
I used the export option in Outlook Express to get my old messages/folders to
OUtlook... However, I cannot delete any of the messages. It gives me a
"Messaging Interface has returned an unknown error...if continues restart
Outlook"... I have an I still can't get rid of them.
MTB <MTB@discussions.microsoft.com> wrote:
> I used the export option in Outlook Express to get my old
> messages/folders to OUtlook... However, I cannot delete any of the
> messages. It gives me a "Messaging Interface has returned an unknown
> error...if continues restart Outloo...Get paid while you get online!!
I found a great Internet company - Cashfiesta.com - that has created a
product everyone can benefit from. They pay you while you work or play
on your computer. All you need to do is keep their software - the
FiestaBar=99 - active while you are online. They even pay you when your
friends are using their computers.
Unlike other companies, Cashfiesta gives you control over how much
money you earn. They have an individual payrate based on the number of
Special Offers you sign up for. As some of these offers are free, you
can increase your payrate up to 33 times without spending a penny.
It's...I keep getting the error message 'not responding' with Outlook?
I keep getting the error message 'not responding' with Outlook? So
ultimately it takes a long time to load then the message disappears. Does
any one know what this means? Have I got a bug somewhere that I need to get
Shazza wrote on Fri, 12 March 2010 07:33
> I keep getting the error message 'not responding' with Outlook? So
> ultimately it takes a long time to load then the message disappears. Does
> any one know what this means? Have I got a bug somewhere that I need to get
> rid of?
1- try to check your ad-dons may be one of th...Outlook 2003 Update Fails
Using automatic update I have downloaded and tried to install an update
listed as Outlook 2003 Junk Mail Filter (KB925254), but every time I get a
message that the update failed. I tried to go to the Microsoft website to
find out about this but do not know where to go or who to tell.
Apparently this was in my outbox and I did not realize it. Please disregard
to see my related message.
"flyer" <email@example.com> wrote in message
> Using automatic update I have downloaded and tried to install an update
> lis...Windows Live Mail Error ID: 0x800420CD
After using Windows Live Mail Desktop in Windows 7 Home Premium (64 bit) for
3 months, to access mail from AT&T, my wife's computer developed the
following error that results in a continous attempt to download messages,
counting up into the thousands, after receiving the messages that were
actually in her At&T Yahoo mail box (I checked via web to verify her settings
and see what was in her web mailbox). After the 15 new e-mails were received
by Windows Live Mail, it keeps on trying to receive thousands of messages,
but none actually show up in her In box and this will...How do you set up a repeating column in Outlook?
I have three sheets in one workbook, and I want to make changes to one column
in sheet one, but I want the changes to apply to the other sheets when I make
that one edit.
You can group the sheets.
Select the first sheet
ctrl-click on the subsequent tabs
Make your changes.
rightclick on one of those grouped worksheet tabs and select "Ungroup Sheets"
(Everything you do to one, you'll be doing to all in the group--so be careful!)
> I have three sheets in one workbook, and I want to make changes to one column
> in sheet one, but I want the change...Hidden ActiveX gets focus
i have a MFC CDialog that contains several controls and ActiveX'es.
Depending on the configuration of the dialog, I have to hide an ActiveX (I
tried different ways like ::ShowWindow(...) or ::SetWindowPos(...) etc. to do
that). The ActiveX gets hidden as it should.
Let's say, I have the following tab order:
Edit1 (ActiveX) - Edit2 (ActiveX, hidden) - Button - Edit3 (ActiveX, hidden)
I jump from control to control by pressing the tab-key. What I expect is
that the focus jumps from Edit1 to Button and back to Edit1 and so on. But....
What really happens is that:
- Edit1 is foc...Can't get Vista recovery CD to recognize installation
I'm trying to get a Powerspec B647 Vista64 Business PC to boot. After
booting to the Vista Recovery CD and choosing to repair, the process
can't find any installed O/S.
So I press the Load Drivers button to load the B647 RAID controller
drivers, which I downloaded from Powerspec to my flash drive. After
pointing it to the "sataraid" folder, the system installs some
controllers and drivers but still doesn't find my Vista installation
afterwards. Even worse, the C drive letter is given to one of the
removable media drives.
After pressing the Next button I'...How to get the active document
Hi. How can I get the active document object (to clarify, the document
object associated with the view that has focus) in an MDI application? I'm
using a worker thread for communication and I need to tell the active
document about communication event that occur.
You can get the active document in MDI using GetActiveFrame(), checking its
validity and then calling GetActiveDocument on it. The only catch here is
that you are doing it in a worker thread. I think it should work there as
well because you are not using the (CWnd,handle) map of MFC that is not
valid in your thre...Task in MS Outlook 2000
I want to know if there is a way that I sent send a task
in MS outlook to a "DL" or to one person and CC to more
CRM - Assistant Manager
You can send to a DL or one person but you cannot CC anyone.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Amir Fakhrawi
| I want to know if there is a way that I sent send a tas...How do I get the data/xml/export option
My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?
One way would be to do a web query, first preformat the cells as text, then
do the query (data>import external data>new web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import
(No private emails pleas...How to get font information from clipboard #2
I am writing an image process program. I want to cut or copy some text
with font information from other software, such as MS Word, Excel etc .
In my program, the text will be draw on screen with same font. So I
need to get the font information from clipboard, what should I do?
...Manage Group Calendar-Public Folder
I need to accomplish the following in a public folder,
(1) Ability to Manage a group calendar with several different types of
event/appointment types (Tour details, conferenec info, available dates for
tours, training etc.)
(2) Each event type should only have one or two owners who can modify the
appointment information for a particular event type:
( If necessary, we can have separate sub calendars for each type as
described above and maybe somehow update the master calendar automatically
if there is a change in the sub calendar folders)
Any help will be appreciated.
Th...How do I get my text wrap tools to work?
I've followed every instruction in the help files that I can find, and my
text wrapping features will not work in any format other than top and bottom.
My computer is new & has Publisher 2003. I've worked on Pub. 2000 & did not
have this problem. Is there a setting that I'm missing???
Right-click the text box, format text box, layout tab, select the text wrapping you
Did you edit the wrap points on your object?
Select your object, click the dog icon on the picture toolbar, select a wrap there.
It could be how your are arranging the objects and text box. Experime...can't get ical into entourage
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
no matter what i do i can't get my calendar into entourage. i've got sync services set to delete entourage and replace with ical/contacts on my imac. my contacts are there, but i've never been able to get my calendar over. i gave up last june but wanted to see if there was any help so i could try to use entourage and then compare to ical/contacts/mail. <br><br>help!!!
On 2/8/10 3:25 PM, in article 59bb27cf.-1@webcrossing.JaKIaxP2ac0,
"Carol_Schultz@officeform...Forcing outbound mail through Exch 2003
I'm in the final stages of my Exch5.5 -> Exch2003
migration. Right now, all mail inbound from the Internet
is flowing through Exch2003 (as it should). However, all
of the mail sent from my network to the Internet is still
flowing out through my old Exch5.5 server. How do I
configure my Exch2003 server to send its outbound email
directly to the Internet rather than sending it to the 5.5
Any help is greatly appreciated.
Basically you need to delete the IMS on the Exchange 5.5 server and ensure
that your E2k3 server is configured to send outbound SM...How to get totals
Hello all. I have a list I am working with in excel 2003. The columns I am
interested in are Employee, Overtime Code, Pay and Comp. There are
overtime codes. I need to total the pay and comp columns for each employee.
My problem is that if the OT codes are certain numbers, they will not be used
in the calcualtions. Like so:
EMPLOYEE OT CODE PAY COMP
Jones 1 4 0
Jones 6 4 0
Jones 5.02 0 4
Jones 18 2 0
Jones 9 ...2 users getting same email
Hi-I recently added another user to my outlook 2002 pro
account. The email is working for both-I tested sending &
receiving to each one-but both accounts are getting the
same emails. If I delete a message in 1 account, it is
deleted in the other account because it is the same
message. What can I do? Thanks!
ali <firstname.lastname@example.org> wrote:
> Hi-I recently added another user to my outlook 2002 pro
> account. The email is working for both-I tested sending &
> receiving to each one-but both accounts are getting the
> same emails. If I delete a...how do I get this done
If anyone can help me with this I'd greatly appreciate it
If I have some data such as
Plan A 2.00 4.00
Plan B 3.00 5.00
Plab C 4.00 6.00
and also have
cost X what formula for X will look at the data abov
and return the value 2.00
pgruening's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2601
View this thread: http://www.excelforum.com/showthread.php?threadid=39368
A1...How does Calendar Referals Route?
E2K3 SP2 on a W2K3 SP1
We have to identical Exchange servers, one on the East and one on the West.
A user at a third Central site has a mailbox on the East server and wants to
access a users Calendar on the West. This works from the East site,
however, when doing this from the Central site, we get the pop-up "The
connection to the MS Exchange Servers is unavailable. Outlook must be
online or connected to complete this action.". This error happens in both
Online mode and Cached mode. When running Outlook with the /rpcdiag switch,
I see the attempt to connect to the West server, b...How to get combo box selected index changed event in another page from the existing page in winforms
I am working on windows forms project. I have two winforms (window1 and
I have a combobox called cmbEmail in window1 and Textbox called txtName in
I want to retrieve some information into the txtName in window2 when I
selected something from cmbEmail in window1.
If I write code to retrieve something into the txtName (which is in window2)
in cmbEmail SelectedIndexchanged event in window1, I will get an error of
txtName doesn't exist in this page.
Can anybody help me to solve this problem..
Thanks and Regards
"Naresh" &...Outlook/Outlook Express Help!!!!
I have both Outlook 2002 and Outlook Express. For some
reason I am unable to receive incoming mail on Outlook
even though my default is Outlook, It only comes through
Express. What else could it be? Please help.
I would start removing outlook express all together If
you don't want to do that then atleast remove your email
account in outlook express.
>I have both Outlook 2002 and Outlook Express. For some
>reason I am unable to receive incoming mail on Outlook
>even though my default is Outlook, It only comes
>Express. W...How do I cancel the use of Microsoft Office Outlook?
I want to discontinue the use Microsoft Office Outlook. How do i do this so i
can get all my mail to go back into my old e-mail address?
Outlook can use whatever email address you have, assuming you have the info
to set it up. eg mail address, user name, password
See OL Tools/Accounts and add the 'new' address
Depending how you connect you may have to add another connection - dialup -
The mail is specific to an email address you cannot receive mail sent to one
address in another address, unless you setup mail forwarding at the ISP end
"Audrey" <Audrey @discussions.micro...