AutomationHello Everyone,
Recently our IT group installed service pack 3 on our
computers. I wrote some code in word that automatically
attaches it self to an outlook email and sends it out.
I'de like to disable two windows that i didn't get before
they installed service pack 3 there are not titles so here
is a description of the boxes: 1 - A program is trying to
access email addresses you have store in outlook. do you
want to allow this? then it asks for "allow access for"
(1,5,10 minutes) 2 - then i get a similar one that just
asks you if you're sure you want to send ...
Hide Rows #2Hi,
I've been working on this for a few hours and am finding this one to b
a difficult one.
How can I write a formula or some code that will hide rows based o
values?
Example:
If in Row 1, cells F1 and J1 contained zero, then hide the whole row
(This would need to be done for multiple rows i.e all rows where F an
J columns contained zeros)
Please help.
Thank You
--
Message posted from http://www.ExcelForum.com
You can't do it with formulas, you need VBA code. This example will do it as
the worksheet changes, not a macro to run to hide all rows at once:
right-click the sheet...
FRx WebPort #2Could someone please help me!
I have set up an image with FRx and WebPort on it. I have finally gotten it
to work but when I log into WebPort there is no Repository in there!
Also I notice that the Administrator password, continues to be blank.
Any thoughts?
Thanks
Debra
...
Splits #2 Hi Everyone,
When splitting a transaction - say at walmart where you buy groceries
and household supplies (different categories) how do most of you
handle the sales tax. I don't care about tracking this for these type
of purchases. Seems I remember from years past that there was a key
combination that would distribute it among the other categories - is
this still a feature? In any case how do most you handle it?\
Thanks for you help,
Jim
I vaguely recall there being a key combination for this, but I have no idea
what it is.
If you just enter the categorized items and it doesn't ...
CRM and Fax automation questionHi,
I'm looking for a good or better fax server that can be easily and
seamlessly integrate with MS CRM 3.0 or 4.0.
I'm thinking of RightFAX or GFIFax... or even if I install these fax server
in my environment, do I still need to do programming and customizations,
such as post callout when a new Fax activity is created?
Please advise :)
You immediate response is appreciated.
"Benjamin Fallar III" <fallar@pldtdsl.net> wrote in message
news:3484C69D-B193-4B48-86A4-A4529D9DE4C6@microsoft.com...
> I'm thinking of RightFAX or GFIFax... or even if I install ...
Print area #2I have many workbooks that have from 10 to 60 worksheets. All pages have the
same set up in them. It's just that some data changes. I have a template set
up and now want to set the print area for all the pages. When i select all
sheets the print area menu greys out. How can I do this without setting it
for each worksheet idividually?
smarty, here is one way using a macro, will set the print area on all sheets
in the workbook
Sub Set_Print_Area()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.PageSetup.PrintArea = "$A$1:$C$25" '******Change to your range*...
Provisioning/Automation tools for Exchange??I have been asked to find some tools possible of automoating mailbox
moves to specific databases/storage groups based on the department of a
user for instance. Let's say User1 is part of HR and has transferred
to Marketing. All the HR mailboxes reside on SG1 DB1 and all Marketing
reside on SG1 DB2. Is there any software anyone knows of that can read
the department attribute from AD and then move the mailbox according to
defined rules you put in place.
Any and all help appreciated!
Mike
In a couple of situations, organizations I have worked in have talked about
having something li...
auto complete #2Does anyone know how to delete an email address in
outlook 2002 that "pops up" when you type the persons
last name? They are using outlook 2002 with Word as
their email editor. When they open outlook and click in
the TO: field, and start typing an internet email,
outlook prompts with the auto complete feature, with two
choices. One has the correct email and one does not.
How can I delete one?
The email address is not comming from contacts.
thanks
Ok, I figured out I can simply hit the delete key. I
guess it was just too simple!
-----Original Message-----
>Does a...
=PROPER #2Using Excel 2003. Have downloaded info and it was downloaded in all caps.
Have tried to use the =PROPER formulat but it doesn't work. If I go to a
separate cell in the spreadsheet referencing a specific cell it works. How
can I change in one worksheet all caps to PROPER ?
I don't understand why =PROPER wouldn't work!
You can copy this code to your personal.xls file and run it
Sub TextProper()
Dim ttt As String
Dim c As Object
For Each c In Selection.Cells
ttt = c.Value
c.Formula = Application.Proper(ttt)
Next
End Sub
Have a great day...
Address Lists #2I upgraded to Exchange 2003 and removed the last exchange
5.5 from the site. But I'm still seeing all the old
address book views. How do I get rid of them.
Thanks for your help!
...
Word crashes or hangs constantly #2Version: v.X
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Hello,
Just today, I started having severe problems with my Word program. It is constantly either crashing or hanging (not responding and I must kill it with Force Quit). I did not do any software upgrades or other changes that may have caused this problem.
I read up a bit and realized I was way down in terms of recent upgrades, so I installed the latest and am running now at 10.1.9.
This behavior has repeated on various (large) fies I have opened, so it isn't confined to just one doc file. I do not seem to be havi...
WinMail Could not be started 0x800C0155,2 errorerror message is:
Win Mail could not be started 0x800C0155,2
MSOE.DLL could not be initiated
I am unable to open an email from websites (contact us or email link). I get
the error msg above.
It seems this started when updates to Vista were downloaded. Don't know
which ones.
It may also be related to Adobe Reader updates, since I seem to be having
problems with opening a
pdf files from websites. I get an error msg that relates to Adobe Reader
(no problems opening pdf files I have saved in my computer).
I cannot seem to find a fix anywhere for this. Some posts suggest ...
2 "Is it possible to do this in Excel97" questions?Can you change the value of a cell from another cell?
i.e.
IF A1=3
then B2=4
else C2=3
also
can you set up a temporary "variable" in a cell to make functions more
streamlined. For example, I have the following function in my worksheet:
=IF(AND(ISTEXT(A4),ISTEXT(D4),ISTEXT($E$1)),IF(VLOOKUP($E$1,CHOOSE($B$2,rn1mw,rn2mw,rn3mw,rn4mw,rn5mw,rn6mw,rn7mw,rn8mw,rn9mw,rn10mw,rn11mw,rn12mw),
MATCH("Typ",rounds_heading,0),0)="W",1,IF(OR(VLOOKUP($E$1,CHOOSE(B2,rn1mw,rn2mw,rn3mw,rn4mw,rn5mw,rn6mw,rn7mw,rn8mw,rn9mw,rn10mw,rn11mw,rn12mw),
MATCH("Typ",rounds_he...
Exchange Errors #2Event ID 8331 MSExchangeAL Address List Sychronization The service threw an
unexpected exception which was caught at
f:\titanium\dsa\src\lra\abv_dg\lservagent.cpp(4511)
My Application log is full of these errors 700 plus a day. Microsoft Web
info says install SP1 for Exchange 2003 to fix. Been there done that--no
bueno. Still have full event logs. Any suggestions--- help Please.
That issue is supposed to be resolved by the SP1 update.
I did find another case here where the problem was related to a failed
registration of an object during install. A re-install of exchange resolved...
Is it Possible to Automate a Graph?I have a sheet that has data in weekly fashion in the first and second rows.
(Row 1, week: Row 2, data.)
Is it possible to have a graph populate off of the information in rows 1 and
2 that automatically includes data for new weeks as they are entered in to
the sheet?
For example, I want to create a graph for weeks 1 through 3 now, and want
the chart to automatically update if I add data for week 4.
Row 1 Week 1 2 3
Data 12.5 17 18
Thanks for the assist!
-Adam
Use a defined name using the offset function for your series
--...
DNS Reverse lookup #2Hi,
One help, please:
- I have a domain test.local (W2k3) and in it a Exchange 2003 Std (machine
mail.test.local);
- I configured the users send email as @test.com;
- My MX is pointed to Exchange Server;
- I have a public IP from DSL service;
- when I send an email the recipient use Reverse DNS lookup and the result
is mail.test.local and not test.com
How can I solve that problem?
Thanks.
Luiz
Luiz wrote:
> Hi,
>
> One help, please:
>
> - I have a domain test.local (W2k3) and in it a Exchange 2003 Std (machine
> mail.test.local);
> - I configured the users send e...
Way to automate adding pictures in a series in Excel?I'm putting a column of pictures of people next to a column with their
names. If I have the pictures together in a folder, with the photo file
names numbered with the corresponding row numbers that the pictures go in,
is there a way to record a macro so that (for instance) 28.jpg will go into
the picture column in row #28, then 29.jpg will go into the picture column
in row #29, etc. In other words, insert a whole series of pictures
(filenames the same as their appropriate row numbers) in their correct
places, by initiating one macro?
If anyone has any idea of how that could be done, I wou...
Column Reference #2Hi,
On Row 3 - I have text from columns "B3:J3".
I am constanly adding and clrearing the rightmost cell, so that the last
column is J, P, K, ...etc.
Is there any way to create a function in Cell A1 so that it will give me the
letter of the rightmost column with text (whichever is nonempty). - (I am
using this with the indirect function to do a vlookup)
So if the text spans from column B to column AJ - then Cell A1 = AJ
If text spans to column K, Cell A1= K
Any help would be greatly appreciated.
One way:
=LEFT(ADDRESS(1,COUNTA(B3:IV3)+1,4,TRUE), 1+(COUNTA(B3:IV3)>25)...
Outlook 2002 error? #2When I try to run outlook 2002 it will not start. I tried the "repair and
detect" with out any luck. It wants to start in the safe mode but it will
not start.
I reinstalled Office Xp over the existing install.and still no luck. This
only happens in one Windows XP user, with the other two users Outlook works
OK.
The error message I get is bellow if from the error report Windows wants to
sent to Microsoft.
AppName: outlook.exe AppVer: 10.0.4024.0 ModName: mso.dll
ModVer: 10.0.2625.0 Offset: 006d3fe5
Any Help?
Thanks
"SlipKid" <*the_ox@bigfoot.com*> wro...
Problem in adding new menu item to existing menu in GP #2I want to add new form in Tools->Setup->Sales->new form.
I had created procedure in which i am using AddCommandToMenu
function to add menu.
Status = AddCommandToMenu(DYNAMICS,
resourceid(form Command_Sales),
resourceid(command CL_Sales_Setup of form Command_Sales),
Seq,
CMD_BUILTINCMD_DICTID,
resourceid(form Command_IOP),
resourceid(command Cmd_IOP of form Command_IOP),
true,
MENULOAD_TOTABLE);
I create new cnk file for this.
I open GP it include my code and when i open Tools->Setup->Sales-> then
it will show me a separator only.
Is it right way to add new menu item under...
RMS 2 demoDoes anyone have a RMS 2 demo,
I have ordered it few weeks ago but still have not received it.
If you have it can you upload it to my ftp or somewhere on web ?
Thanks
...
Automating transfers, is this possible?Hi All.
I am using MM 2007 Premium and I'm using Advanced Bills. In "Help" it says
....
"Make electronic transfers. Set up automated transfers between any accounts
you track in Money"
I have a set up an "xfer" from my checking to my savings (same bank) to
occur once a month but Money doesn't actually do anything unless I manually
go to "Bills Summary", check it and and click "Pay Online". This isn't
what I would call an automated transfer.
Is there any way to actually make this happen?
Thanks,
Richard
----== Posted via ...
VBA automating Word from PowerPoint 11-22-09I have an add-in macro that exports PPT content to a new Word document for
each PPT file in the same folder as the currently open PPT file. I've noticed
that when the macro is finished, and I go to Word, Word seems "paralyzed" (I
can't use any menu commands or close the doc). If I Alt+Tab back to
PowerPoint, and then Alt+Tab back to Word, all is well. Is there something
about automating Word from PowerPoint that needs to be "cleared" when the
PowerPoint macro ends - some way to release PowerPoint's control over Word?
I found http://www.pptfaq.com...
Uninstalling MSCRM 1.2 and Re-installingHi,
I installed MSCRM 1.2 with the wrong Organization Name.
So I need to uninstall and re-install. Does anybody have additional
documentation for this?
I plan to backup all databases, and export an xml configuration file. Is
this all I need to backup
before I do the uninstall?
Thanks,
Do
Hello Do,
here is the briefly description "How to uninstall MS CRM". But make sure
that you have a complete Backup from all systems available.
----------
How can I uninstall the Microsoft CRM Server while leaving the data intact?
Resolution
The following procedure will retain your Mic...
Transfer inventory out #2I Want to have the Retail Price printed on the transfer inventory out report.
How can I do this?
thanks
This is a multi-part message in MIME format.
------=_NextPart_000_014F_01C924B1.31DC9200
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0150_01C924B1.31DC9200"
------=_NextPart_001_0150_01C924B1.31DC9200
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
faiz,
Find one attached
--=20
Jeff=20
Check Point Software
Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
=3D=3D=3D=3D=3D=3D=3D=3D=3D...