Need Help setting up .oft file
I need some help setting up an .oft file to apply to a rule for an
autoresponse. I use a popmail server so the autoresponse function in Outlook
does not apply to my application. Can anyone offer some advice?
Thanking you in advance.
If we knew your version of Outlook and if you used word as your editor we
could help... where you run into problems doing it would help us target the
response as well.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/ou...How to apply a formula accross all the rows when the total rows are too much in no. ?
guyz i know you can drag the formula accross the rows in that column t
have that formula in effect in every cell. but i have some data lik
5000 rows then how to get that formula accross each cell, its painfu
holding the mouse and dragging the formula accross the rows.
thanks in advance
Message posted from http://www.ExcelForum.com
after inserting this formula in the first row double click on the lower
right corner of your cell selection
> guyz i know you can drag the formula accross the rows in that col...Need to re-add "Tools" button to Menu Bar
I have inadvertantly removed the "Tools" button from my Menu Bar an
need to re-add it. Does anyone know how to do that?
Message posted from http://www.ExcelForum.com
goto 'Tools - customize', select your menubar in this list and click
> I have inadvertantly removed the "Tools" button from my Menu Bar and
> need to re-add it. Does anyone know how to do that?
> Message posted from http://www.ExcelForum.com/
A) The OP lost his Tools menu, so he can...join columns, keep both values
I have a multicolumn database with text entries. I want to join the
cells in Col. B with the cells in Col.C and keep all the text. For
instance, B3 may be "1N", C3 may be "4W". I want the combined column
to read "1N 4W". How do I do this?!? TNX.
FourPenny's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23864
View this thread: http://www.excelforum.com/showthread.php?threadid=375062
=B3&" "&C3 -->"1N 4W&q...Pass value to combo box
I have an unbound text box (txtSaveVal), an unbound combo box
(cboName), and a string variable strSaveVal.
me.txtSaveVal=strSaveVal .............. Works fine
me.cboName=strSaveVal ............... Does Not Work
I simply want to put the value of strSaveVal into the combo box, as
though I had typed it in, BEFORE pressing the enter key.
Why isn't this working?
Why are you doing this?
A combo box is not intended to accept a value from another control,
but provide a means to select a value from a list of values either from a
a query, or a manually ...Need help with SetCapture & Release Capture API
I have a user control to display a thumbnail. When the mouse moves over the
thumbnail a blue square highlights the control and when it moves out of the
control it goes back to default.
All this works well except for one thing.
I create an array of 50 usercontrols and use a Picture Control and Scoll
bars to sroll the pics up and down. ie a Viewport.
I have 2 buttons at the bottom. Back & Forward
Now if I scoll down and hover over a usercontrol that is half displayed at
the bottom and then move downwards to click the forward button the
ReleaseCapture event is not bein...I need to add tool bar in my application
I am working on a dialog base application
i need to add a tool bar in my dialog based application
i followed the steps given by the below link
but it didnt work for me
i found that my application didnt even shows its dialog box
can any one help me
That link also has a downloadable project with it. If thats working and
given you have provided absolutely no code or whats not working, I
would suggest go back to the sample and compare it with your code.
MSDN also has an article about how to do ...need help with Index, Match and Countif in the same complicated formula
I have a spreadsheet Expense Journal designed for entering expenses in two
currencies, one for Dollar and one for a local currency. It has two sections
of rows, the top is for Dollar Expenses and uses no exchange figures
because the spreadsheet converts everything to Dollars. This Dollar section
has five columns:
Date Project # Account # Description Dollar
In the blank spreadsheet that they start anew each quarter, there are only
two rows setup for Dollar expenses because most of their expenses will be in
Below the Dollar secti...Need help - Save as
In new Outlook 2003, when I highlight several e-mail in my
Inbox & select File, Save As, it only saves the Headers of
the e-mails & not the headers & the body - in my old
Outlook 2000 it saved both - can any one tell me how to
I have a program that read the Saved As file & processes
the data in the e-mails & I can't find where to change any
option to fix this... though I have read & read & read...
thxs much !!!
What format are the messages and are you using the old Ol97/2002 pst format
or the new Unicode format? We're seeing issues ...Value list
i need help with making value lists in excel so that i can make my data base
consistant with the data i am entering
That's not much to go on. What is a value list? And what constitutes
making your database consistent with the data you are entering? Post back
and explain in detail what you have, what you want to do, and what you want
to happen. Some examples are always good. HTH Otto
"Maint Girl" <Maint Girl@discussions.microsoft.com> wrote in message
> i need help with making value lists in ...Need Parser that can read attributes of XML document...
I am looking for a parser in PHP that can return all the attributes of
XML entities. I know how to read the XML Entities, but I have got a
problem with reading attributes. So I will appreciate if you could give
a parser that can return all the Entities and Attributes of respective
entities as an array.
<?xml version="1.0" ?>
<EntranceDelay on="5" off="5" />
<Limits minLength=&...need help printing on a form
How do i print a list addresses that i have saved in excel on a form
from like an address book. i dont know how to arrange the address name
etc... manually before printing.
Message posted from http://www.ExcelForum.com/
It may be easiest to print the list by using Microsoft Word's Mail Merge
feature to pull the data from Excel.
There's information on the Word MVPs' web site:
> How do i print a list addresses that i have saved in excel on a form
> from like an address book. i dont know how to arrange t...Will Money suit my needs?
I have been a long time user of Quicken but am now looking for an
alternative. While Q is a very good program for looking back - what I need
now is a program that is able to also give me an accurate picture of future
events/cash flow/balances down to the daily level. I would particularly
like the ability to put in a number of senarios to give me the net result of
different financial decisions and to be able to compare the results--
preferably on screen and then be able to adjust the what ifs and save the
results for ongoing planning.
I don't need automatic downloads or some other featur...Need Help with Coding a ComboBox in Excel/VBa......
Perhaps someone can help me..........
I have the following code written in VBA.
Private Sub SupervisorComboBox_Change()
Sheets("Sheet2").Range("C1") = SupervisorComboBox.Value
I have a ComboBox that lists ten supervisors.
When the user chooses a supervisor from the ComboBox drop down list
the name gets stored on the second Sheet, in cell, "C1".
Now then.......there is a second ComboBox underneath this first one
This ComboBox lists each employee that works under the chose
supervisor. The employee's name gets stored in cell, "D1"
My que...Excel macro to insert rows if a cell does not equal the value above that cell
I have a spreadsheet listing columns of information for many different
people. If more than one row exists for the same person, I'd like to
insert 2 rows after the row so that the group is separated from the
next group. For example, here's how the data appears now:
LastName Account# Balance
Martin 1 500.00
Martin 2 750.00
Smith 5 100.00
Thomas 9 900.00
Here's what I'd like it to look like after running the macro:
LastName Account# Balance
Martin 1 500.00
Martin 2 75...Adding comma seperated values within a single cell
I need to come up with a custom function that will add up comma seperated
numerals contained within a single cell.
For example if the the cell A1 contains:
I want the result of the fuction (say in a2) to display the result of 12
Any help greatly appreciated.
On Tue, 07 Oct 2008 20:39:01 +1100, Michael Toal <M.Toal@bom.gov.au> wrote:
>I need to come up with a custom function that will add up comma seperated
>numerals contained within a single cell.
>For example if the the cell A1 contains:
>I want the result of the fuction (sa...i need monthly ledger that is catagorized by payment due dates
"j.marie" <email@example.com> wrote in message
PLEASE write your question in the body of the post, not in the subject line.
This is not a chatroom. Thankyou.
In answer to your question, you would be better advised to buy an
inexpensive dedicated accounting package. That will do what you want "out of
I'm pretty new to extracting info from IE into excel so I need some
major help here. I need to fill certain input values on a webpage,
"click" the submit button, and from there I should be able to extract
the info I need. Its the navigating the selection screen I'm having a
problem with. The HTML values I need, I believe are contained in this
section of the source code. So how do I change these input values in
the html code to what I need and submit?
<FORM name = F001 method=post>
<input name="screen_id" type="hidden&qu...need a bit of help programming
hi i am trying to build a program for basic accounting based on an ol
dos program which i used to own 12 years ago!
i cant find it anymore so im trying to build this program in excel an
i have most of the work done but i need help sorting the basic data
all the framework is there for inputing the data around a cashboo
principle using item codes as keys for manipulating the data later on
trouble is i dont know how to do the manipulating to get the seperat
data out and sorted
the file will be available for download if anyone would like to take
look at it:
email me at firstname.lastname@example.org a...Using a value from a previous Record to Perform a Calculation?
I have a Append query that looks up a particular date range I specify and
gives me a count, for received and loaded dates that meet that range. From
those 2 numbers the query also subtracts Received - Loaded=Backlog. See below
ID Received Loaded Backlog New
1 0 0 0
2 5 3 2
What I need is for the query to lookup the New Backlog value from the
previous record an...Design Input Needed
I have a flexgrid where I show Form2 when a combobox is clicked.
(BTW, I use a keypress instead of subclassing for the mouse since this is an
issue with the combobox.)
Receives the combo.text in a lookup textbox on Form2 that
finds the text in Form2's listbox (using the combobox.text) and loads the
required controls with the correct information.
All works well.
If I have multiple vendors with the same name -- because of different
locations (e.g. GE which has multiple offices) they appear multiple times
within Form2's listbox. It is up to the user ...Business Portal unit of measure needs lookup
For inventory items, when on the RequisitionLine dialog, it would be nice to
be able to choose the unit of measure instead of accepting the default
purchase unit of measure for the item.
In a1 I have alink to a cell on another page in the workbook.
In b1 the formula a1/100.
When I edit the cell ref in a1, b1 returns #value!
I don't understand why, and I can't seem to do anything about it.
Exactly what is the linking formula in A1?
When you say "edit the cell reference" in A1, what (how) exactly are you
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------...I need to change the owner of a task from "unknown" to my name
I want to change the "owner" of a task from "unknown" to my name.
I am the only user on this PC.
"Manuel Roman" wrote:
> I want to change the "owner" of a task from "unknown" to my name.
> I am the only user on this PC.
sorry, new to this...
I don't have an answer, but am thrilled to find your question. have spent
hours trying to figure this out & no luck so far. please respond if you have
"Manuel Roman" wrote:
> I want to change the "owner" of a task from "unknown" to my ...How do I obtain a value from an external form?
I'm on Access via XP Office Pro.
How do I obtain values from an form that I run using the DoCmd.OpenForm.
Currently, I have the form opened by OpenForm setting values in global
variables. I have a standard set of global variables that are set by the
called form and retreived in the calling form (the one that ran the DoCmd).
I've read where I should not be using global variables.
For example, on my customer call log form, we record all of our incoming
calls as they happen. If one of those calls results in the creation of a
work order, I want to click on th...