Can I fade the edges of photos that I use?
I am trying to use photos in a publisher document that I want to fade the
edges of, is this possible to do with publisher?
> I am trying to use photos in a publisher document that I want to fade the
> edges of, is this possible to do with publisher?
Not really. You should use dedicated image manipulation software for
this, such as Photoshop Elements, Paint Shop Pro, or Microsoft Digital
Ed Bennett - MVP Microsoft Publisher
Are any of these programs typically come loaded on a computer?? I have
another question - ca...numbering
Is there a way to format a cell so that you can put in a 1
and then the next time you print it out that number will
change to 2 and so on?
...Can I delete my switchboard and make a new one?
I do not like my switchboard and would like to delete this one and start all over. But when I did delete it I couldn't make another one, because I couldn't delete the default. What should I do?Thanks,Dustin Just delete the form and the table that were created by the wizard, then start over.-- Rick B"Dustin" <Dustin@discussions.microsoft.com> wrote in message news:42F94A44-9352-4D02-9104-65593869B271@microsoft.com...>I do not like my switchboard and would like to delete this one and start >all> over. But when I did delete it I couldn't make another one, beca...Wrapping text in a cell
In a single cell, suppose I want text to appear on two lines. Viz:
How do I do that so that I specify the wrap point?
If you are typing the data into the cell use Alt-Enter between each
string to indicate where you want a line break to occur.
Case One<Alt-Enter>Case Two
Alt + Enter
Lilliabeth's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27741
View this thread: http://www.excelforum.com/showthread.php?threadid=476428
If you...adding a leading 0 to only the numbers with 4 digits
I'm converting a bunch of data and during the import Excel dropped the
leading zero from all the lip codes. Since this is about 15,000
records, I'd like a way to add a leading zero to only the zip codes
with 4 characters. Any ideas?
"SwampYankee" <email@example.com> wrote in message
> I'm converting a bunch of data and during the import Excel dropped the
> leading zero from all the lip codes. Since this is about 15,000
> records, I&...Locking Formulas to Cells
I don't know if I am using the correct terminology but this is what
want to do: I have placed formulas in multiple columns that calculat
my sales numbers for a bid. The problem I am running into is that
change the bids for every person and when I clear a cell is clears th
formula from it as well. Is there a way for me to clear cells withou
deleting the formula I have placed inside it? I know that I can jus
grab the first cell in the column and drag it down to re-load th
formula in that column but I don't want to have to do that. I want th
formulas permenant and the data I enter...How do I add a hyperlink to an individual word in an Excel cell?
I am using Excel 2000 (not by choice) and I need to add a hyperlink to an
individual word within the cell, not the whole cell itself. For example in
the sentence "Click here or here to go to the appropriate web page." I want
the words "here" to each have a separate hyperlink.
Any ideas? I can manage some VBA too if necessary.
You can't do that in Excel.
You would have to use HTML or Word or some other means.
You could fake it, the entire cell would be a link, but you could
after assigning the hyperlink select another...how can I drag formulas with other cell references
cell A1 contains formula "=stdev(a2:a7)
cell a2 contains formula "=stdev(a8:a13)
Is it possible to drag the formula down so that cell a3 contains
"=stdev(a14:19) and cell a4 contains "=stdev(a20:a25) and so on for cells a5,
a6, a7 etc. etc.
It was easier to test and verify using SUM instead of stdev, but the formula is same
NOTE the formulas are in a different colu...Cell Selection?
I have a colum of numbers
What I need, is to be able to select 3. the 198's are not going to be used
in the next part of my equation. That seems simple enough, however all the
numbers could be usable (not 198) and I need to use just the first three. Any
One interp / way, using non-array formulas
Assuming source numbers in A1 down
In B1: =IF(COUNT($C$1:C1)>3,"",C1)
In D1: =IF(A1="","",IF(A1=198,"",ROW()))
Select B1:D...can i have more sender in outlook setting ?
i using win server 2003 , exchange 2003 , i using exchange client in outlook
to send & receive , but my boss have more than one mail address , can i use
another AD mail address for send out mail , i have try to add a pop3 , the
sender also is computer user
...Formulas don't work in certain cells #2
nope, the cells are formatted as numbers. I simply cannot figure thi
kalik247's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1594
View this thread: http://www.excelforum.com/showthread.php?threadid=27423
Being formatted as numbers doesn't automatically mean they are numbers.
Copy an empty cell formatted to General.
Select your range of numbers and Paste Special>Add>OK>Esc
Gord Dibben Excel MVP
On Mon, 1 Nov 2004 11:59:46 -0600, kalik247
<kalik2...Adding attachments to email merges
I am trying to create an email merge in Outlook, with a PDF attachment.
It all works ok, and the message sends but the attaachment is always
stripped off the message - I have tried different files and the attachement
never comes through, or even gets mentioned in the received message.
What am I doing wrong?
Any suggestions gratefully received.
Not supported. You'd need to use third party software for that.
"m.nutt1" <firstname.lastname@example.org> wrote in message
news:%23qnq...Page Number in Repeat Rows area
Is there a way that I can put a Page Number in the Repeat Rows area of a
sheet - and get it to update when I print?
I have found one piece of VBA that puts a page number within a cell but it
is only updated if the cell is outside the Repeat Row area. When it is
within the Repeat Rows area I just get a page number of 1 corresponding to
the original row location..
I do some VBA programming but am not an expert.
Nothing comes to mind that doesn't require VBA code.
You can paste the following in the sheet header (File | Page Setup) and page x of y will print on ea...IE8 can't access Microsoft Office site when all other browsers can
When trying to access the Microsoft Office page using IE8 I keep getting the
"Internet Explorer cannot display the webpage" message. If I use any other
browser (Firefox, Opera, Safari, Chrome) I have no problem accessing the
page. This happens whether running in normal or No Add-on's mode. Despite how
many people keep complaining about all the problems with IE8, neither the
MVP's or Microsoft acknowledge that they exist.
Intel E8400 Core2Duo 3.0GHz
4 GB PC2-6400 DDR2
Windows 7 Ultimate (with all the latest updates installed)
NIS 2010 (all up to date)...I can't get rid of 1 "Payment to Send' Reminder-M07
On my Home Page in the Reminder section, I have a "1 Payment to Send"
listed there. But there is NO payment to send. I"ve opened up back-up
copies as far back as May and the reminder is there, but there is no
payment that needs sending. Does anybody have an idea how I can get rid
of this Reminder?
Just removing the Reminder from Home Page doesn't do it. When you put
the Reminder back on the Home Page, the "Payment to Send" is still
there. Clicking on the link just takes me to Bill Summary page.
...is there any way I can trap for the use of navigation buttons?
Is there any way I can trap for the use of navigation buttons, such as
Next, Previous and New record?
Probably. Trap what and when?
"Stapes" <email@example.com> wrote in message
> Is there any way I can trap for the use of navigation buttons, such as
> Next, Previous and New record?
On Wed, 16 Jan 2008 05:14:20 -0800 (PST), Stapes
No. And there shouldn't be a reason for that. There are plenty of
events in...Advanced mail merge/distribution/attachment ?s
Hey - questions.
1 - I already know how to do mail merges and email
distribution lists in Office, but if we don't want each
client on our distribution list to see the names/addys of
all everyone else on the list (we usually mail to blind
cc for this) is there STILL a way to have each client's
name show up in the email (preferably in the address or
subject header lines, if not in the message?
2 - Does anyone know how to take an attachment and add it
in to an email message/embed it for viewing a la HTML,
rather than just attaching it?
Any help would be appreciated,
1) ...how can I look into store.exe
I have an email sobig that i cant even download it on my
outlook express 6.0....
The adviced for is to locate it on the Queues in Outbound
or inbound messages on IMC, but if it is not in there the
message may be stuck up in Store.
How can I locate it and delete the massega in store.exe
they say I can use the MFCmapi but i'm a newbie how can
do this. Do I have to download the MFCMapi? what is it?
...can't change/delete bills and deposits
suddenly one day i realized that when i tried to change a
bill, i could click "ok" but nothing would happen. I
thought it was because i upgraded to 2004, so i deleted
the bills and rescheduled. about 5 of the bills will not
delete either. the error message is: "Money could not
write to your Money file. The operation could not be
performed or another application finished this task before
you. Please try again."
Now some of the newly scheduled bills will not allow me to
change the properties, i click ok but nothing happens when
i edit the series.
I have repaired ...Can't Install IBF for CRM on CRM Server
first i'm install IBF On my CRM v1.2 (it's name testcrm)
after that i'm try to install IBF for CRM on my CRM Server
but in Step "Publish Metadata" i'm type "http://testcrm:8082" and click
but it's show message box "The Information Bridge metadata service
location is not avaliable" and can't install it.
-_-' . but i can access "http://testcrm:8082/IBFWriteService.asmx" and
"http://testcrm:8081/IBFReadService.asmx". so how can i install it ?
I had the same problem - try using http://localhost:8082 for...Insert Page Numbers on Worksheet in Excel 2007
In Excel 2003, if you wanted to put page numbers on multiple worksheets in a
workbook, you grouped the worksheets and then added a header or footer, using
the page number function. All of your grouped worksheets would shows its own
But in Excel 2007, only my first worksheet is numbered when I do this (as
Page 1). What's the problem? Do I actually have to put a page number, one
by one, on each worksheet?
I cannot replicate your problem with 2007.
Grouped sheets behave exactly as 2003 did.
After grouping and adding a header of Page 1 did you do a print p...Can Work thread get a windows class and manipulate it?
Suppose that I create a work thread when my dialog box started, then in the
thread I get the pointer to the dialog mfc class and call updateData method.
Does that work? I tried, but failed.
Is there any other way to do? thanks!!
No, it won't work, don't even waste time trying. It is almost guaranteed to fail. You do
not manipulate the windows owned by one thread from a different thread. What you do is
PostMessage requests from the worker thread to the main UI thread, usually to the window
that contains the controls.
The fact that you are using UpdateData already says you are in t...if cell in other worksheet meets criteria, then leave blank.
I have data in worksheet A for each month, for each entity. Then I have a
summary page which shows just the averages for each entity for each month.
Then I need to create a master summary page which shows just the annual
average for each entity, just one line per entity.
My Summary page shows Jan-Dec in column A. I have a formula averaging the
numbers from worksheet A. Jan-Mar is done. But the rest of the year hasn't
happened yet, so April's formula results "#DIV/0!". I have already put in
all the formulas for the year to be done with it. But I don'...Why can't I send email messages with Trial Outlook 2007?
I have a new HP laptop that came with the 60 day trial of Office'07. I
receive email but the send/reply/compose functions are grayed out. I am
certain my settings are correct. Why can't I send email?
What happens when you use the Test Account Settings? What is the exact
error message you get?
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, KK asked:
| I have a new HP laptop that came with the 60 day...One Exchange server wont send mail to certain domains
Just wondering if I can pick someones brains.
We have 2 Exchange servers, 1 2000 (Ex2000 Sp3, Win2k SP4, Global Catalogue,
member), and 1 2003 server (Ex2003 Sp2, Win2k3 SP2, master).
Since putting in the 2003 server, users on the 2000 server get some "mail
server rejected connection" failures when sending to 1 or 2 domains, most
other domains accept mail ok. Users on the 2003 box can send fine. We've
checked our MX records which are in place on the firewall, and we can also
telnet to these domains and complete the telnet test.
2003 > outside world (u...