When I am in one cell highlight another
When I am in one cell highlight another. Lets say that if my cursor is in
A1 I want D1 highlighted or with another cursor on it.
Then if I move to A2, D2 should be the one with another cursor or highlighted.
Thank you for your help,
Jose Juan Diaz
hi, Jose Juan !
> When I am in one cell highlight another
> ... if my cursor is in A1... D1 highlighted or with another cursor on it.
> ... if I move to A2, D2 should be the one with another cursor or highlighted.
'put' a cursor on non-active-cell... [I don't think it's possible] :(
to highlight 'D' wh...Cells print so small I cannot read numbers. How do I fix?
I have been working with page break. Now I have the grid on 1 page..but it is
far to small to read. now when I try to spread it back to 2 pages, it just
takes the same tiny microscopic type and spreads it into 2 pages. I am stuck
printing tiny type. How can I get the grid cells back to a size that is
It sound like you have selected Fit to 1 page in File > Page setup > Page >
Scaling. Either select to fit it to 2 pages or select Adjust to 100% size
In Perth, the ancient capital of Scotland
and the crowning place of kings
Repl...Why does copy and paste between eMails not work?
Copy no longer copies to the clipboard. Is there a setting I have deleted
somewhere? Using Windows 7 and Office 2007 proffessional.
Does it work if you restart outlook?
Do you have any addins installed that could be erasing the clipboard? I've
seen this happen with addins and contacts, but not email. to test, open the
new message form before copying so you just need to copy and switch to the
other message. (http://www.slipstick.com/Contacts/clipboard.htm)
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Cent...Not able to send email from CRM client
I cannot get CRM configured to send email from the CRM
client software. See error message below.
I have tried all the solutions I can find, including:
-Confirmed mailserverurl is set correctly on the CRM
server and that the specified server is the Exchange
-Confirmed that the mailserverurl returns well formed XML.
-Gave the IUSR_ORCAS user full control of the
the "...mailroot/vsi 1" on the exchange box, which is
-Confirmed platformurl setting on Exchange server is
-Confirmed that the machines can communicate with each
What...Process all cells in a (user) selection
I am using this code to give me cell by cell access to a code defined
Dim aCell As Range
For Each aCell In Sheet4.Range("A4:A34")
' Do Stuff Here
which processes every cell in the A4:A34 Range
How do I do the same thing for a selection drawn by the user before
pressing my 'Process' button ?
On 05 May 2010 11:10:21 GMT, Isis <isissoft@NOSPAMbtinternet.com> wrote:
>I am using this code to give me cell by cell access to a code defined
>Dim aCell As Range
>For Each aCell In S...ALL of my email is gone- getting error message as well
I am getting this message:
The message store has been corrupted by an application external to Windows
Mail. Windows Mail has been able to successfully recover from this
In addition ALL of my emails are gone.
Any suggestions on how I can recover them? And what I should do about the
Try running the various repair functions in
the WMUtil program: http://www.oehelp.com/WMUtil
If still no improvement, upgrade to Windows Live Mail:
It will automatically import all your WM data.
Gary VanderMolen, Microsoft MVP (Mai...Sending email from exchange server to Win2k server on same domain
This has been bugging me, I have a win2K box with smtp installed, I want to
allow users to send messages from exchange to the win2k server where they
will be processed by some scripts.
I have never tried this before and I am not sure of:
1. what is the address of the server (email@example.com?)
2. how should the exchange account/address be configured
Any advice gratefully received
Mark Davey wrote:
> This has been bugging me, I have a win2K box with smtp installed, I want
> allow users to send messages from exchange to the win2k server where they
> will be proc...think cell program
is anyone familiar with a program called think cell? Any thoughts?
(powerpoint v 2003). Is this an add-in?
It's very good. You can "try for free" from their website:
Recent interview with one of the founders on Indezine:
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/3...Incoming Emails
We installed the CRM1.2 on the same server with
exchange. Everything is working fine except that the CRM
users can not see incoming emails inside CRM although
these emails are CRM emails.
Can anybody tell what is the reason of that?
Do you have installed the Router? The Router is a bridge=20
between the Exchange and the CRM who study the incoming=20
flow of emails and copy to the CRM everything who is of=20
I hope who that help you.=20
Vin=EDcius Pitta Lima de Ara=FAjo
> We installed the CRM1.2 o...No email stationery when through code
I am creating email via code from access using below;
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Set objOutlook = CreateObject("Outlook.Application")
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
objOutlookMsg.To = "firstname.lastname@example.org"
objOutlookMsg.Subject = "Email Subject"
objOutlookMsg.Body = "Dear abc..."
The problem is that the default signature that is set in outlook doe snot
come up in the email. How can I fix it?
Am Sun, 17 Sep 2006 21:11:45 +0100 schri...viewing LN emails (.nsf files) saved to CD in outlook?
I have lotus notes messages saved on CD, these are saved
as .nsf files. Is there any way I can view these in
have tried various LN websites - to no avail.
...no content in the email body
Haven't changed anything knowingly, but now when I receive emails all the
in a .txt attachment which I open and goes to notepad.
There is no content in the email body.
"stephen" <email@example.com> wrote in message news:<#TKSQf$oDHA.firstname.lastname@example.org>...
> Haven't changed anything knowingly, but now when I receive emails all the
> content is
> in a .txt attachment which I open and goes to notepad.
> There is no content in the email body.
I've seen this before with an Outlook 2000 client. Couldn't find a way
to fix it,...Can you delete and empty an open email
Can you delete and empty an open email? I know I can delete and empty a
closed email by holding down shift and then deleting, but have not been able
to figure out how to delete and empty from an open email.
Is this even possible?
Thanks for your help.
On Wed, 18 May 2005 20:01:03 -1000, Kylie B""
> Hi there
> Can you delete and empty an open email? I know I can delete and empty a
> closed email by holding down shift and then deleting, but have not been
> to figure out how to delet...Newbie Cell Reference Question...
I apologize if this question has been answered before, but I'm no
quite sure what to search for as I'm not very good with excel.
I'm making a spreadsheet where one sheet references another. I'll tr
to explain this as best as possible....
I'm creating a spreadsheet for a fantasy basketball league. I have
"Data" sheet that contains data for all players. I have another sheet
"Teams" that has all the players on each team. Column B contains th
players name, and column C contains a number that corresponds to th
row this player is on in the dat...Moving Email Domain off of Exchange #2
I am in the process of moving one of our clients off of our Exchange
server and on to a third party email host. I have removed there domain
from the default recepient policy, and also disabled and unattached or
deleted their mailboxes. I have repointed there MX record to point to
the new host etc.
The problem is when I try to email them from our network my exchange
server still thinks it is responsible for handling the mail for the
domain and does not try to send it out of the domain. I get a 5.1.1
e-mail account does not exist in this organization.
How do I let Exchange ...Recovery after "do not save changes" selected accidently
I mistakenly clicked on "do not save changes" for a
worksheet (file) that i'd been working on (I thought a
different file was highlighted). As it turns out I had
not saved the original file in over a day, though the
autosave is set up.
is there any way to get my file back, or at least an
intermediate version, instead of one with a day's less of
Thanks very much for your help!
Sorry to say, but your day's work is gone.
Greeting from the Gulf Coast!
"Mayukh" <email@example.com> wrote in...I m receiving my email but after received it is not in my inbox
When I open the outlook and click on send/receive, I receive all the emails,
but I could not find the downloaded email anywhere. It's not in my inbox or
any of the folders that I have created. The unread mail also does not change
to reflect that new emails have arrived. Could some one help me out here.
Thanking you in advance.
If you check your whole folder tree (composed of multiple PSTs possibly),
are any folders showing as bold?
"INAVAB" <INAVAB@discussions.microsoft.com> wrote in message
> When I open...Need Hyperlink from Menu Page to work in email
I have a workbook with several tabs. First tab is a "menu" type page
(summary of other pages). Currently I have hyperlinks to all the other pages
from the menu page. What I want to be able to do is copy the menu page into
an email and enable the users to click on the existing hyperlinks (whatever
adjustments needed) to go directly to their page of the workbook. Using
Excel 2007. Please advise how to do this and what changes may be need for
both options to work.
...Contacts vs Personal Address Book. Can't pull emails into TO fiel
I'm using Outlook 2k3 and having a slight problem. WHen I view my Contact
list in the main view, I have two sets (not sure why but I'll be combining
them). These lists have standard name, email, etc.
Problem is when I go to create a new email message and click the TO: button,
it tries to look for my Personal Address Book which I don't have. How can I
make it not use the PAB and use the Contacts list instead?
OK, I think I just stumbled on the issue. For some reason on my COntacts
Properties, the check box to tell Outlook to use that in the Address Book
...Receive triplicate emails
On earthlink webmail, I only receive one of each email.
When I "Send/Receive" from Outlook 2000, the Send/Receive
window tells me I'm receiving 10 emails, but 30 appear in
my inbox. Everything arrives in triplicate or duplicate.
Extended headers appear to be the same in all three
Things I've tried and know:
Deleted and then reconfigured my earthlink account many
times. There is only one earthlink account.
"Leave a copy of messages on server" is unchecked.
Turned Earhlink Spamblocker On then Off then On then
Off... no change.
Sent test m...Authenticating addresses for sending emails
I installed Office XP for Small Business on my laptop
recently. Now, quite often I am getting an error message
when I try to send an email to someone that says, "You
must first authenticate this email address".
Does anyone know how this is done?
I have Office 2003 and I saw this once in my copy, I found it all I had to
do was to add the person to my address book as it was part of the built in
PDA Square Content Developer
"Ken" <firstname.lastname@example.org> wrote in message
news:01fc01c3d94f$...Email retention policy relative to CRM e-mails tracked from Outloo
Toss up question for the blue team.
When one hits "Track in CRM" on an e-mail from outlook we all know that it
CREATES an e-mail in the CRM system. The date that the e-mail is created in
CRM is placed in the field CreatonDate. When we look at the related record
it shows up in order based on the Created Date.
The rub is this. What do we do when we have a user who is just coming on
board with CRM and they have e-mail history they want to link that goes back
years. There does not seem to be any linking relative to the received date.
Which is actually much more relevant ...Cell background shading in Excel
Why is it that the background shading colors available
under the Paintbucket Icon chjange from file to file?
Also, how can I add some of the colors to the paintbucket
that are availabe under the format/cells/pattern pulldown?
Colors are a Workbook-level property, so you can change the color
palette for any workbook. Choose Tools/Options/Colors... and modify the
colors to your hearts' content. You can also import another workbook's
color palette from that dialog.
Note however, that there are only 56 bins in the color palette, so you
can only use 56 colors at a time. The paint b...How do I send to myself at an alternate email address?
I have Outlook 2007 and am a new user. I have two separate email addresses -
one thru a LAN at the office and one with a different provider. Outlook will
not let me send to myself from one to the other. I seem to have no problem
sending internally thru the LAN.
Do you get any errors? If yes, please post the exact error message.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, DeeJay asked:
| I have Outlook 2007 an...Sum every other cell?
I own a used-book shop. I have an Excel SS to track how many books pe
day I sell in each of 28 categories and the $$$ I take in for eac
category. So there's two columns for each day: #books & $$$.
therefore want to add every odd-numbered cell in a row to get the tota
number of books for a category in a given period of days and ever
even-numbered cell in the same row for the the total $$$. Is there
simple formula or function for this
bookmanjb's Profile: http://www.excelforum.com/member.php?acti...