Combine or Merge Issue
First, I have machines with both Office 2000 and 2003, so I have both
available if that matters.
Now, the issue:
Our company accountant generates a sheet every two weeks with 401(k)
figures...what the employee contributed, what the employer
Each sheet is exactly the same as far as what data goes where, but the
amounts sometimes change from pay period to pay period.
So, at the end of the year, she has 26 sheets. Is there a way to
create a 27th sheet and combine all the data from the first 26?
For example, if in A3 we have a dollar amount that represents what
E...updated junk mail filters for ms outlook
Is there an improved junk mail filter and if so where can
i go to download
...I cant see pictures inserted into word/publisher
On reopening the files I can't see pictures inserted in Word or Publisher.
I'd suggest start by updating your graphics driver.
MVP Microsoft [Publisher]
"Ahsan" <Ahsan@discussions.microsoft.com> wrote in message
> On reopening the files I can't see pictures inserted in Word or Publisher.
...Publishing to the web through Publisher
i've just downloaded a trial version of publisher and love it so far except
it will not publish to my hosting provider, Godaddy.com.
I have completed all of the steps required per directions found at:
Everything is great until I get to the end when I get this message:
Publisher could not save the file to the web. Check your your url or network
connection and try again.
If there is any advice or technical support that someone can give please let
me know. I would love to purchase this product but I don't want to sp...outlook express as default mail handler
My office uses Outlook Express for email. I could switch
to Outlook. Here's the problem: I can't get Outlook
Express to become the default so my PDA will pick up the
email. Tried Tools, Options, etc. Click on default and
then click ok and then it goes right back to not being the
default. I don't understand why. I'd rather keep using
If I give up on OE and try for Outlook and try importing
the mail info/addresses from OE, I get an error message
which says it's creating an Outlook.exe error log and
drops out of the import. I can't find the log....Populating an e-mail address in a VBA Function
I have the following code in a button on a worksheet Before the lin
I wanted to put a default email address which can be hard coded and i
.to = "email@example.com"
How can I put the To Address in this statement so that when they clic
the button the address automatically appears in the To section of th
ActiveSheet.Protect DrawingObjects:=False, Contents:=False
If Sheets("Level 2 Support Team Member").Range("b34").Value
Sheets("Level 2 Suppo...File and Print Sharing on Exchange 2003
Would there be any reason why I would need File and Print Sharing
enabled on my Exchange 2003 cluster? I would like to minimize as much
network services as possible and I can not think of any applicable use
for FPS. I know mail slots use SMB but I do not believe Exchange 2003
uses mail slots??? Any advice would be helpful.
Message tracking logs use a share so if you do remote admin you would lose
this. There are two other shares in addition. I do not believe any are
critical but be aware of what you will no longer have available.
"HoosierDaddy" <bjorgenson@...publisher #74
can I repeat an image in publisher? like a line every 1/4 inch for example.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"MargaretK" <MargaretK@discussions.microsoft.com> wrote in message
> can I repeat an image in publisher? like a line every 1/4 inch for
Copy the line, place your cursor where you would like the line to paste,
right-click, paste. It could be helpful to create guides. Or select the line,
press...Installing Publisher 2003 gives an error
I am trying to install Publisher 2003. Even before it comes up with the
Product Key, it gives the message "This patch package could not be opened.
Verify the patch package exists and that you can access it."
I have Office 2003 Basic Edition installed. I uninstalled the Office and
then tried to install it but still it comes up with the same message. Did
some research and used the Windows clean up utility but to no avail.
Any help appreciated.
You receive the "This patch package could not be opened" error message in Office
2003, in Office XP, or in Office 2000
http://...Sending Publisher Files
Just got this software last week with no manual, so Im
kinda flying by the seat of my pants here.
The question is Ive put together some promotional flyers
I need to send to my customers, but I feel confident that
most would not have publisher to read them.
Can I format them another way and still keep the flyer
looking like it should?
Check out the following link on sharing Microsoft
Microsoft Publisher MVP
>Just got this software last week with no ma...Confused as to publishing a web site with Publisher
I apologize for using the "General Questions" forum, but the Web Design area
doesn't seem to get much response to questions (as I have previously posted
there), and this area does and I could really use the help.
Here are the steps I've gone through.
I created a site in Publisher.
I have acquired Yahoo as my web hosting provider.
I attempted to upload my files the way Yahoo, and many other "help" sites
say, by using Publish to Web, but kept getting firewall errors.
Therefore I installed SmartFTP and uploaded my .pub file successfully.
Then I realized I can't...generate unique random numbers
I have a list of 600 names. I would like to generate a random number
between 1 and 600 for each person but not have any repeating numbers. So
far I have used
This give me the correct number range but many of the numbers repeat.
Can I accomplish what I want to do?
One way ..
Suppose serial nos (1,2,3 ... 600)
and names are in cols A and B, from row1 to 600
Put in C1: =INDEX($A$1:$A$600,RANK(D1,$D$1:$D$600))
Put in D1: =RAND()
Select C1:D1, fill down
C1 returns the random shuffle of the serial nos that's required
Press F9 key to regenerate
http://sav...Publisher 2000 #23
After adding a new profile on a Windows 2000 box,
Publisher decides not to work (Publisher has been working
many years previously on this desktop).
I'm getting the message: "This application must be
installed to run. Please run Setup from the location
where you originally installed the application." I tried
the resolution to Article 269276 but that did not work.
If anyone has a suggestion or resolution, it would be
very much apperciated.
...how do I open up publisher 2003 files in publisher 2000
I received an e-mail with a pub2003 file and am unable to open it with
pub2000. Please help
Contact the person who created the file and ask them to save it as a Pub
2000 file. There is nothing *you* can do other than to upgrade to Pub 2003.
MVP Microsoft [Publisher]
"jeanrix" <firstname.lastname@example.org> wrote in message
>I received an e-mail with a pub2003 file and am unable to open it with
> pub2000. Please help
Outgoing mail is certified Virus Free.
Checked by AVG anti-viru...Error number: 0x80090008 02-08-10
I've been working with Microsoft for over a month without resolution and it
has now come down to reinstalling my operating system which I really would
like to avoid. I noticed in December that I was not getting any update
notifications so after about 2 weeks I went to the website for updates and
when I click express I now get Error number: 0x80090008. This even comes up
when I try to update windows defender software. I can't believe that there
is no reference to what this error number refers to. Anyone have any
Windows version would be...?
I recently uninstalled norton, added macafee, did a compression and defrag
and may have deleted a file or two . . . :P Anyway, now when I try to open
Publisher or a Publisher file from explorer, I get the error 1304 message
asking if I have access to program files/microsoft
I have access to this file and can see it from explorer. How do I correct
this issue so I can run Publisher again?
Thanks in advance for helping this noob!
Operating System? Publisher Version?
By the way, left the frying pan (Nortong) and jumped into the fire (McAfee)
"...Created 3-panel brochure; how to edit back 3 pages?
I created a 3-page brochure and edited the content of the three pages.
When I printed it, I got two physical sheets: the front three pages
and the back three pages.
I need to edit the content of the back three pages. How do bring them
up for editing?
BTW, when I find a duplex printer to produce the fully edited brochure,
I'll be in Publisher Heaven :-)
Thanks in advance,
Never mind; I found it.
I opened a practice session and, happily, it started with a brochure.
That example pointed out that it started with two pages. That made me
take notice of the littl...OL2007 : Printing problem with multiple mail printing
i update my OL 2003 to 2007 and now when i try to print some (HTML)
email in one time, i've some ok, and some are illegible, font size are
decrease to maybe 3pt or 2pt.
If y try to print theses mails one by one it's ok.
Any solutions ?
Thanks in advance !
...Customize Investment Summary on 'My Money' Home Page?
Okay, so I've got a lot of stocks, mutual funds, etc., that I don't own
Can anyone shed any light on how I would clear that clutter out of the
Investment Summary on 'My Money' home page?
...How do you check your office e-mail when out of the office?
How do I check my e-mail when out of the office?
more detail on your setup would be required to answer that.
"Office e-mail question" <Office e-mail email@example.com>
wrote in message news:33B202BC-03CF-4CBF-93DC-A27639BA06A9@microsoft.com...
> How do I check my e-mail when out of the office?
If your office uses an Exchange server, then ask the mail admin if they have
enabled Outlook Web Access, which allows you to view the contents of your
Exchange mailbox via a web browser.
He or she may also be able to set you up with a VPN, if your company uses...upgrade publisher
I have a similar question to Issac. I want to upgrade my
Office 97 suite to the latest version, but Office XP does
not seem to contain Publisher (?), how can I get my
Publisher version, off of my Office 97 Pro Ed up to date?
I am getting Publisher files from newer eds that I cannot
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from dfran <firstname.lastname@example.org>...
> I have a similar question to Issac. I want to upgrade my
> Office 97 suite to the latest version, but Office XP does
> not seem to contain Publisher (?), how can I get my
...Endlessly sending mail
Hi! I have outlook 2003 set up to use an exchange server and an SMTP
account. I messed up the setup and put a bad address in the SMTP
account setup, and the SMTP server is rejecting my message. However,
Outlook KEEPS sending the message OVER and OVER. The thing is, the
message isn't in the Outbox! I looked for it there, thinking that I
could delete it and make Outlook stop attempting to send it. But it's
How can I get rid of this message that will never send through the
SMTP server? Any help is greatly appreciated!
...Counting the number of entries in a column
I have area numbers in column A and the number of produkts ordered in column B
I want to count the number of entries in a particular area bearing in mind I
just want to see the number of entries rather than sum them up like SUMIF. Is
there a convenient formula which would allow me to do this?
Thanks for any help
I assume your product is in column B and the product name is XX
Change range and product name to fit your needs
you can have as well the product you want to count entered in a cell let's
say C1 in that case you can...concatenate a large number of cells
instead of listing all the cells in a column that i want to concatenat
into one cell.
(A1&A2&A3&A4&A5&A6 ETC. I HAVE TO LIST MAYBE A HUNDRED CELLS in a
column. how can i list A1 to A100???
maybe this isn't clear but--thank
ROLG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1606
View this thread: http://www.excelforum.com/showthread.php?threadid=27541
Rolg, here is a function by JE McGimpsey that should do it, if you need any
more help on how to use it ju...Trouble formatting Mail merge Number field for european format
I have to mail merge a letter using XLS as datasource that has some currency
fields and the output of the currency fields should be formatted to european
format (eg: 1.234.567,99) Please note that decimal separator is comma and
group seperator a dot.
If could not find a suitable switch. Can someone please point me to right
O/S: Windows XP
MS Office 2003
The European format would be;
and not the decimal seperator being a comma
"SRV" <SRV@discussions.microsoft.com> wrote in message