no date/time on individual emails in inboxHi,
Currently my inbox emails are showin up correctly in the "list" view with
recipient, title and date and time.
However when I click on each individual email they read "sent:none" instead
of the date/time.
This is just in my inbox, but is a problem when printingor fowarding a copy
as they have no date/time on.
Have tried uninstalling and re-installing outlook but with no success
Any help would be greatly appreciated.
Did outlook download the messages or did you import them?
What type of email account?
--
Diane Poremsky [MVP - Outlook]
Outlook Tips:...
How can I change the chart so date is up and down and data is acroI have a chart that has the date across the bottom (category axis) and the
data up the side (value axis). I want to change these. Is this possible?
Hi,
It depends on what chart type you are using.
Have a look at Jon Peltier's example for a line chart.
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
Cheers
Andy
speet wrote:
> I have a chart that has the date across the bottom (category axis) and the
> data up the side (value axis). I want to change these. Is this possible?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
=?Utf-8?B?c3BlZXQ=?= Wrote:
&...
Transaction DatesBill Gates just can't make it easier can he?
Ever since my bank upgraded their software I am having the worst time with
e-pay's & x-fers thru money. Can someone help me understand why? When I
submit a payment via Money the program tells me it has to change the date
because it can't be processed on that day. For example; Today I requested
that 3k be transfered from my savings to my checking. In the past the
transfer would go thru and there was no issue. Now I get a message that says
my bank doesn't have enough time to do the transfer and the date must be
modified ...
a valid exchange rate not found for the return dateAnyone ever seen this message? There is no relative help in knowledgebase
and what there is - we have covered. Not sure why GP is saying we don't have
a valid exchange rate only when doing a return. The return is within the
month and the exchange rate table is active for a period long before and long
after this date.
We've been trying to solve for days now and the error makes NO sense at all.
Please help
...
date shows none in out of boxCannot send e-mails, I can compose an e-mail and it goes into the outbox but
will not send. The date shows none in the outbox. Every e-mail I compose
goes into the outbox but the date shows none. Please advise
Michael wrote:
> Cannot send e-mails, I can compose an e-mail and it goes into the
> outbox but will not send. The date shows none in the outbox. Every
> e-mail I compose goes into the outbox but the date shows none.
> Please advise
Version of Outlook?
Type of Mail Server?
If pop/imap, does it go if you do a Send/Recieve?
Did it ever work?
Any known changes between i...
Text FieldI have created a database using linked tables. There are no notes fields in
those tables and I need one. I created a text field and entered a comment but
that comment appears against every record but I want it to stay within the
record it was recorded against. Anyone help ?
Hi KC
Where did you create the text field?
Since the table is linked, you need to create the text field in your data
source, where ever the tables actually reside.
If you created the text field (box) on a form, it will not be bound to a
particular record and thus it will show up for all of the records, similar
to ...
Add DateWe have a spreadsheet that we would like to automatically add the date in the
first cell of each row when information is entered into another cell in that
row. The date would need to remain static once added. Any suggestions?
This worksheet_Change event will update the date in column A each time there's a
change anywhere else in the row.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myCell As Range
Dim myRngToCheck As Range
Dim myIntersect As Range
With Me
Set myRngToCheck = .Range("B1", .Cells(.Cells.Count...
insert text data using functionHi Guys,
I need help on the following matter. Suppose i have two column A and B. Now
when i insert some text in the A1 cell i want the data automatically set up
in the B1 Cell. Fox example if i type Linux in the A1 cell "Open Source"
will be automatically inserted in the B1 cell but if i insert windows "close
source" will be inserted autoamtically. I tried with if function but no
success. How can i achieve that?
Mosaddeq Aziz
You need to set up all of your possible data entry values for column A on
Sheet2. Then in column B on sheet2, put the values you want aut...
CListCtrl large icons and text problemHi,
I have a simple thumbnail view control based on CListCtrl and description of
each item is a 3-line text. Unfortunately CListCtrl shows only two first
lines, and the third one is visible only for selected item. How can I show 3
lines of text for all items ?
How can I increase label width ?
Thanks in advance,
Kamil
Karmil,
Here is a control that might do what you'd like.
Tom
http://www.codeguru.com/listview/ReportCtrl.shtml
"kamil" <kamildobk@xxxpoczta.onet.pl> wrote in message
news:OndTGoS4DHA.3360@tk2msftngp13.phx.gbl...
> Hi,
>
> I have a simple thum...
Text Box in PublisherI am trying to create a text box in publisher with the measurement of 5.75
(h) x 5 (w). But publisher is making the height 5.751. How do I correct this?
Is this even possible.
Don't think it is possible... The .001 is so tiny it shouldn't make much
difference.
I can get a true 5.75 in Publisher 2000 but as soon as I copy/paste it goes back
to 5.751 in 2002, 2003 and 07. Lines do the same.
I can create a rectangle in a draw program, paste special into Publisher,
ungroup, this rectangle will maintain the correct size.
--
Mary Sauer
http://msauer.mvps.org/
"Nikki" &l...
Is there a way to automatically resize a text box to the font sizeI know how to set the font to automatically resize to the text box, but is
there a way to automatically resize the text box to the font size?
Very often I have the font size exactly how I want it and I have to adjust
the text box so it's as tight to the text as possible.
If there isn't an automatic way to do this, this feature should be included
in the next version of Publisher.
...
Parse(?) data from text fileI have a large text file that has hundresds (or thousands) of compiled
questionairres that I want to convert to a more usable format (excel?). Here
is what it looks like:
========================
Name: Joe Jones
Address: 123 main
comment: varies from blank to 20+ lines may have muliple paragraphs
others: 8 or 10 other fields
===============================
next questionnaire
======================
A couple of details: the separator line of ====s vary in length, the
individual questionnaires are not always identical. Some have a couple of
extra 'fields'.
I envision a separat...
how do I convert an imported number to textI am downloading data from a computer and wish to convert the number to text
in an excel format eg: 0 = pump #1there is a series of numbers from 0 to nine
and each one represents a different problem or failure of a piece of machinery
Have you tried Find and Replace (Ctrl+H)
--
Jacob
"Lyn" wrote:
> I am downloading data from a computer and wish to convert the number to text
> in an excel format eg: 0 = pump #1there is a series of numbers from 0 to nine
> and each one represents a different problem or failure of a piece of machinery
...
I want the day of the week when I insert a dateExcel 2003
WindowsXP
I am creating a spreadsheet and inserting many dates. I want to insert the
date and have the day of the week of that particular date appear. Otherwise
I would have to look up years worth of dates.
Is there a way to do this?
Thank you.
Right-click on the cell with the date you wish converted to "Weekday" >
Format Cells > NumberTab > Custom > and type dddd in the little window....> ok
Vaya con Dios,
Chuck, CABGx3
"HT" wrote:
> Excel 2003
> WindowsXP
>
> I am creating a spreadsheet and inserting many dates. I want to ...
Publisher Text Box #2I am looking for guidance on missing text from text boxes. I understand how
overflow works, but this is a different problem.
I am preparing a trifold pamphlet where it's important that my text fits
into each third without overlapping the folds. I have one long text box
filling each third. The only text box that displays all contents when printed
is the center third. The first few letters of each line in the left third are
curtailed at the left margin. The last few letters of each line in the right
third are curtailed at the right margin.
I have played around with the margins on bot...
IF Function with DatesHello,
I hope someone can help me. I would like to create an IF function for dates
in my worksheet. I have a Start Date column and End Date column. If the
date in the Start Date and End Date falls within the Fiscal Year(06), then I
want to display a 1, otherwise a 0(zero).
A1=7/01/06 (Start Date); B1=6/30/10 (End Date)
FY06 is from 7/1/2005 to 6/30/2006
What I have in C1 is =IF(AND(A1>=7/1/2005,B1<=6/30/2006),1,0)
My result for FY06 is 0, but that's not correct because the End Date is not
until 12/31/2010, so it falls within the FY06. I want this formula to...
How to combine text and the value in another cell?Excel 2007
Lets say in A2 I have a calculated value of 2
in A1 I want it to say The total of XX = 2
This is what I tried:
=CONCATENATE(The Total of XX =,A2)
Gave me a "value" error
what other approach should I try?
tia
dave
Try this:
="The total of xx = "&A2
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"Dave" <dave@accessdatapros> wrote in message
news:20C0AC3C-2CF3-49BC-8837-428F60A42692@microsof...
Autorun macro by dateThis is a repost as my one this morning doesn't appear to have saved,
so ap;ologies if I end up raising the same question twice.
I have a macro called 'Update_Me'which I would like to run
automatically on the first of each month (when excel is opened,
obviously). How do I go about this?
Thanks in advance
Steve
Try something like:
Sub Workbook_Open()
Dim dToday As Date
dToday = Now
If Day(dToday) = 1 Then
'rest of code here
End If
End Sub
---
Place this in ThisWorkbook module.
HTH
Jason
Atlanta, GA
"Steve" wrote:
> This is a repost as my one this morni...
How do I enter dates with one keystroke
I am new to excel. This may be the stupidest question of all time, but
I would like to know how to assign, program, or whatever you call it in
excel a date to a key so that when I am in a cell and want to enter that
date all I have to do is use one keystroke. For example, can I somehow
assign a date like 07/26/08 to the F10 key so that every time I press
F10 the date 07/26/08 is entered into the cell where the cursor is?
Thanks in advance for any help you can provide me.
--
barefoot
This may not be exactly what you're looking for, but to enter the current
date in a cell click ...
Changing Mail Format to HTML/Plain Text Doesn't "Stick"I am having trouble with about 30% of the people I send e-mail with
attachments to. If I manually force plain text (usually HTML is not an
option) by changing the Internet Format property on the e-mail address,
the attachments always come through.
However, the default property seems to always be to let Outlook decide
the best format (which must be RTF and people can't receive).
Via Options/Mail Format, I have "Compose in this message format"
defaulted to HTML. In Internet Format, I have Outlook Rich Text Options
set to "Convert to HTML format". I've tried "Co...
Why does this text automatically update?I'm editing a newsletter used by former staff members created in Publisher
2003. (I'm using the same program.) There is a text box on each page in the
same spot that says "Volume # Issue #." When I edit it on the first page it
automatically changes on all the other pages. I don't think it is an object,
embedded or linked or otherwise, because the "Edit Objects" option is greyed
out. What is it, and how can I edit/replicate it?
It's synchronized text. From Publisher's Help File:
When you create a publication from a Publisher wizard or by using Publi...
Search box for textI'm looking for a solution for an item search box for an inventory. I have a
spreadsheet that I need to find "Name of product" and scroll it up to the
bottom of my frozen pane. I've searched the discussions forum and tried
several formulas, non have worked for me.
In my frozen panes view, I'm looking to have a search box to type an item
name in and have excel scroll it up to the bottom of the frozen pane. The
item names are in column "D".
Any takers?????
Thanks, Allan Grates
You are not going to be able to do this with formulas since formulas cann...
Plain Text #3Hi,
I recently upgraded Outlook from 2000 to 2003. It now appears I have a problem with message formats in my INBOX. Messages that have been sent to me in Plain Text cannot be read, and for each message I have to manually change the format to HTML before text shows up. No problem with old messages that were sent in HTML or RTF.
I don't understand this. Who can help ?
tks
Maarten
...
Text field size not matchingThe help file says that custom fields text1-30 can have up to 255 characters
but when I go to add that field to my Task Sheet it will only allow 128
characters.
Any info would be greatly appreciated.
Hi madsmom,
I can add/view approximately 251 characters in the field when added
to the table. Did you press enter when typing? If so, it will
truncate at the first return.
I hope this helps. Let us know how you get along.
Julie
Project MVP
Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project
"madsmom" <madsmom@dis...
Count text cells if condition in row is true, over many rows.Using Excel 2003 - 84 columns, up to 250 rows. By groups of 3 adjacent
columns, I want to put (in merged cell at top of each group of 3) a formula
showing total of cells with text, IF a separate cell in column CM in each row
has a particular value.
So, there will be 28 totals (84/3) in top row. If CM2="E", CM3="S",
CM4="E", CM5="E", CM6="S", etc, and using condition "E", the formula in
merged D1 will count all text cells in columns D,E,F of rows 2,4,5,etc. The
formula in merged G1 will count all text cells in columns...