splitting one column into two columns ... not what you think
i have fixed column widths that can't be changed; nor can any other columns
be added to the worksheet ...
i've got data in one column that represents "results" ... within the results
column though, i need two columns (starting directly below the "results"
cell, one that reads "in range" and that other that reads "out of range" ...
if i'm on [column a] [cell 1] i want: "results" ... in [column a] [cell 2] i
want: "in range" AND "out of range" with a line down the middle. "text to
column" is ...How can I open a file saved in Pub 2000 version 6 in Pub 2000 ver.
The file is saved in Publisher 2000 v6 and I am trying to open it with
Publisher 2000 v9. can this be done?
Hi LaTrice (LaTrice @discussions.microsoft.com),
in the newsgroups
|| The file is saved in Publisher 2000 v6 and I am trying to open it
|| with Publisher 2000 v9. can this be done?
No. There is no such thing as Publisher 2000 v9, nor is there a version 9 of
Verify the version of Publisher that you have, and also verify the version
of Publisher that you received the file from then post back.
Microsoft Publisher MVP
http://www.publi...help installing exchange 2000 in one of 3 sites
I have a domain cotoso.com installed and configured as AD for 3 companies
interlinked together. and + a total of 3 DC in 3 different sites that are
connected by VPN. i have exchange installed in each site connected on the
same domain contoso.Local(+ E-mail -->contoso.com) + hosting their own
companie domain name such as x.com or y.co or z.com for each company.
I have a routing link configured + 3 administrative groups in exchange
system manger for each company.
one DC in one site that also has exchange 2000 installed on it has to be
changed because of poor performance. now i'm ...Passing data from one form to another
Hello I have a form called frmMaindB and it has 5 text boxes on it
(txtEmployeeTime, txtDTRegular, txtDTReason1, txtDTReason2, txtDTMaintenance)
when I double click on the text box it opens up a pop up form named
frm_DecimalConversion. On this form I have two text boxes one box I enter
data into and the other calculates or converts the data to a decimal. The box
that converts the data is called txtDecimal. Then I have a close button which
I want to use to close the pop up form and insert the data into the text box
I double clicked in to get the pop up or (frm_DecimalConversion). I have r...How to forward emails (unchanged) from one account to another
Assume I manage two different profiles and eMail accounts with my Outlook.
How can I adjust in one of them that all arriving eMails should automatically be forwarded (unchanged !!)
to the other account ?
"Sven Claasen" wrote:
> Assume I manage two different profiles and eMail accounts with my Outlook.
> How can I adjust in one of them that all arriving eMails should automatically be forwarded (unchanged !!)
> to the other account ?
Automatically forward messages to another e-mail account - Outlook -
Microsoft Office Online:
http://of...Ho to make one field required based on critera of another field?
I'm creating a form and need to make the "comments" field required if the
"code" field is =>20. I appreciate suggestions! Deadline Monster is lurking!
User enters the job processing endcode value (numeric) into the "code"
field. If the endcode is =>20, comments are required.
(P.S. I don't know VB)
You would put your validation code in the Form's BeforeUpdate event.
If Me.EndCode >19 Then
If Len(Me.Comments & "") = 0 Then
MsgBox "Comments are required"
Cancel = True
...New emails with attachments not being delivered
When I send a NEW email with an attachment to my husband, it is NOT getting
delivered, however, when I FORWARD an email with an attachment, it IS being
delivered. I've tried sending different types of attachments (Word, JPG,
Acrobat) and it doesn't seem to matter. None of them (as new messages) are
delivered. I can send the same message to his home computer and it gets
delivered, it's just his work Outlook that seems to be the problem.
My email address is on his list of safe senders. He can receive emails with
attachments from others, including his home compute...Outlook attachments #9
Can you seach for any powerpoint attachments in an
Hit Ctrl+Shift+F to bring up the advanced find form.
Then search by "ppt" in "frequently-used text fields."
That will search all fields for the term "ppt" which
should find all the files that have a .ppt extention. I
just tried it, and it seemed to work on mine.
...How can I tell if an email I have sent has been opened?
As per subject.
You can try using a Read Receipt but many users block the return of them
"AT" <AT@discussions.microsoft.com> wrote in message
> As per subject.
you pay for it:
you can try it out for a short time...then you pay...but it's pretty
much guaranteed to get you the results you want...
"AT" <AT@discussions.microsoft.com> wrote in message
> As per subject.
Request a read receipt.
it...Cannot open assigned task in Outlook 2003 #2
I am using Outlook 2003 on a XP Home PC.
When a co-worker creates and assigns me a task, it comes into my Inbox
and I can see it in my preview pane, but I cannot open it when I
double-click it and I cannot accept or decline it thru the preview
My co-worker has Outlook 2003 on a XP Pro PC and has no problem opening
and accepting tasks from me.
By the way....when I attempt to open it, absolutely nothing happens
that I can see....no error, no change of screens, nothing!
I have ensured that when the co-worker sends the task, that they do NOT
have "text only" set for me.
THANKS...Assign values for one column to another.
I have in column T certain numbers and texts that that I require to assign a
value to as below, in the adjacent column. Again any pointers would be much
Well, imagine that two-column table occupies cells Y1:Z20. Put this
formula in U1:
and copy down.
Hope this helps.
On Oct 14, 4:26=A0pm, Celticshadow
>...Outlook 2002 SP3- Runtime Error when opening Outlook
I'm getting a runtime error- Microsoft Visual C++ Runtime
Library / Program C:/Program Files/ microsoftoffice/
office10 /outlook.exe. This App has requested the runtime
to terminate it in an unusal way.
This only happen the first time I open Outlook for the
day. It shuts down, then I can reopen it and all is fine.
I have try to debug it and the detect & repair option in
the help tab.
Any help is Appreciated!
...Attachment Size #2
Is it possible to block the adding of attachments in an=20
outlook client ? Or block the adding for attachments that=20
are bigger than 2 MB for example ? Can i get an error=20
Message or something ? (I think about an GPO or Registry=20
change or something else....)
I have Users around here with Pop3 Outlook 2000 and=20
Outlook 2003 Clients. The Problem is that some of them are=20
trying to send Mails with Attachments with 300 (three=20
hundred!!) MB or something else like that.... Because they=20
don=B4t look an the size of their attachments.
So the Mail is going through our WAN over ...Multiple Account Download from One Financial Instituition
I have at one brokerage mutliple accounts (individual,
joint, 401K, roll-over etc).
In Money they are all separate accounts. When I connect
with the brokerage I am only able to connect to one type
of account (in this case retirement).
How can I download multiple accounts from a brokerage
(when not all have the same URL).
Please email me your reply. Thanks
...force excel to run in only one process excel.exe
force excel to run in only one process excel.exe, excel seems to want to
make multiple excel.exe loaded into memory which causes mysheet.copy to fail
so i have to close out the xls, kill all running excel.exe, then run the xls
again and the macro works. i only have to do this when i am actively
debugging a lot. if i just run my macro w/o opening the vba debugger, i can
run it as much as i want, but if i run with break points it crashes a lot
because of multiple excel.exe loaded into memory. perhaps there is a way i
can force excel to only load one excel.exe?
Are you using Automatio...Failed to open mmf error appears
A pop up window appears with the message 'failed to oepn
mmf'. I assume it is referring to Microsoft mail format.
What could be triggering this error.
What version of Outlook, and when do you see this error?
> A pop up window appears with the message 'failed to oepn
> mmf'. I assume it is referring to Microsoft mail format.
> What could be triggering this error.
>What version of Outlook, and when do you see this error?
>> A pop up window appears with the message 'fail...outlook attachments #3
My aunt cannot get her attachments to come up. When you
click on the paper clip the file menu comes up. The
problem is that when you click on the file itself, it
will not open. What should I do.
Thanks for your time.
Does the attachment line say "OE removed access to the
folloing unsafe attachments in your mail: <filename.typ>"?
I am having a problem with receiving Excel 5.0 files from
my wife. OE 6.0 wont let me receive them :-(, I am stuck
on what to do. Does anyone know how to reduce protection
limits in OE 6.0?
>My aun...Access To Word Mailmerge
I have setup a Mailmerge that is run from Access. The process works like
this: 1) The proper record is selected in an Access form which automatically
starts the process. 2) Word is called up automatically, it shows both the
template and the doument with the proper data in it. 3) Access is closed
automatically. 4) The user then needs to close the mailmerge template. 5)
The document with the proper mailmerge information inserted from Access is up
on the screen. At this point a shortcut is triggered by the user that adds a
document of the users choice to the end of the curre...Copy Data from One Group of Cells to Another Group
I have five columns of data on two different sheets in the same workbook. One
set of columns is sorted in ascending date order the other in descending date
order. When I enter data into the last row of Sheet 1, I need the data in
that row in columns A, B, C and D to be copied into Sheet 2 columns A, C, D
and E in a newly inserted row 14. Is this possible with the use of a macro? I
can find the last cell in Sheet 1, but then need to go up one row and back to
column A. I am having difficulty with that.
Thanks is advance for any assistance offered!
/s/ Alan Auerbach
On Sat, 26 May 2007, ...Unable to connect Office 2003 to SBS Exchange 2000
I have two new XPSP2 workstations with Office 2003 but when after
configuring them for the Exchange server I get one of three errors:
a) on a profile migrated from an existing workstation (whose Office 2000
Cannot start Microsoft Office Outlook. Unable to open the Outlook
window. The set of folders could not be opened.
b) on a new profile using Cached Exchange Mode
Unable to open your default e-mail folders. You must connect to your
Microsoft Exchange Server computer with the current profile before you
can synchronize your folders with your offline folder file.
c) on a new...Email links open to My Documents
When I go to my blue hyperlinks in Outlook 2003, instead of being taken to
the website, I am taken to my own My Documents....when I right click, I
cannot copy and paste because the copy is grayed out.
I really need to repair this ASAP and would appreciate any help. I am using
Office 2003 and Windows XP Pro.
Try rebooting your system
>When I go to my blue hyperlinks in Outlook 2003,
instead of being taken to
>the website, I am taken to my own My Documents....when I
right click, I
>cannot copy and paste because the copy is grayed out.
&...Can't open html format email in outlook xp
Dear all ,
I can't open and create html format emails in outlook XP . I
think I lost some html and RTF components , I tried to reinstall the
outlook xp and selected all the related options , but still can't
work. Could anyone help me to solve the problem?
Thank in advance
Thanks Attila... I will give it a try :-)
...Combine multiple columns into one, automatically?
I'm trying to create a chart that will automatically combine into one column
what are now several columns when displayed in an ordinary column chart.
The columns I want to combine all have the same value on the Y-axis, but are
shown (in an ordinary chart) as separate columns because they have different
values along the X-axis.
Is there any way to create a chart that will automatically add together the
X-axis values and then display the results in a single column?
Or, is this not really a "charting" problem, but instead a problem that
requires me to recalculate my data bef...Unable to install 2000 Publisher upgrade on new computer
I have a new computer with office xp professional, but
the publisher application that came with xp does not have
the same functionality of the office 2000 professional
publisher that i created most of my publications with. I
can not get the "2000 upgrade" that I purchased to
install on my new computer. It says that there is not a
valid product to update. Is there some way around this?
Do you have any old Microsoft product disks that you can install? Works, Excel,
Access, PowerPoint, Lotus 1-2-3, Microsoft Project or Word.
Publisher 2002 is superior to 2000. What features ...