Search results for query: *

I have a dataset whose structure is similar to: person obs colour Dave 1 red Dave 1 green Dave 1 blue Mary 1 blue Mary 1 red Mary 2 green There could be anywhere between 1 and 13 colours for each person-obs combination i would like to transpose this to...

Tony, That is fantastic - it works! Thank you so much. My only problem now is that when i run the macro, outlook throws me a warning dialogue stating that: "A program is trying to access addresses you have stored in outlook. Do you want to allow this? If unexpected, it could be a virus and...

Tony, Here is the code i am running: ----------------------- Sub test() Dim objOutlook As Outlook.Application Dim myMail As Outlook.MailItem Set objOutlook = CreateObject("Outlook.Application") Set myMail = objOutlook.ActiveInspector.CurrentItem...

Thanks for the replies guys, Unfortunately i think security is the issue. I have indeed been trying to write the macro by accessing the macro facility from a new mail item itself. The fact that the standard objects above are not recognised by the editor is, i am led to believe, to do with...

Hi Tony, Thanks for the response. I have tried various code examples but i cannot get any to work correctly and i am concerned that the editor doesn't 'recognise' standard objects such as the ActiveInspector and MailItem. Could it be because i have Word set as the default editor? In any case...

Outlook 2003 Dear all, I cannot find code that will work with outlook 2003 objects to allow me to write a macro to change the "have replies sent to" option (or the 'from' field). I want to assign the macro to a button to allow me to change the 'reply to' field at my discretion (but with a set...

Outlook 2002 10.4219.4219 - SP2 Windows 2000 professional Version 5.0.2195 Service Pack 4 Build 2195 Hi all, Feature in question: Mail > Options > Have replies sent to Does anyone know where the registry setting that sets the default for the "have replies sent to" function in outlook - quite...

As stated in the original post, i want to insert the string into the subject line of the mail. And yes, i appreciate a macro would do, but again as stated in the mail, i was looking for help in writing it. Cheers

Outlook 2002 Hi all, I am looking for a quick and easy way of either: a - auto inserting a short string into the subject line of all new mails and replies and/or b - having a button that would perform the task (ie i need help writing a macro that would insert a short fixed string into the...

Sorry people, But this seems to have sorted itself out without me intervening. I have had lots of advice about how to configure a wireless profile, all of which i had already conformed to ... but the pc now seems fine regardless of whether i power it or the router down. Thanks for the help anyway.

'Automatically provided' was not in fact ticked. However, the problem seems to have gone away without me actually implementing any changes. I am not sure why it re-asked me for the key the first time reconnected the wireless after using an ether connection to configure the router. Thanks for...

Sorry, WZC = Windows Zero Configuration. Hmmm, the plot thickens, i just powered down my pc and returned to it a while later and sure enough it connects automatically to my preferred network. This is making me wonder if it is powering down the router that requires the client to have to...

Win XP SP2 Using WZC to administer connections I have set up WPA-PSK security on my wireless network and can connect without issue using the key. However, having done this once, i was hoping i could have windows save this information in the network profile such that i didn't have to reenter the...

Hi, In reference to WPA-PSK security you mention the following: "The passphrase may be stored on the user's computer at their discretion under most operating systems to avoid re-entry" I have set up WPA-PSK on my wireless network and it works fine, but i cannot get windows XP to store my...

Cheers all, Yes, i had already been to the corega site to update the drivers as i do not have the install cd for the card. After some intial issues i did manage to get windows to install the correct driver. However, after contacting the previous owner of the pc in question it turns out that...

Windows ME 128Mb RAM Corega EtherII PCC-T ethernet card I am trying to establish an adsl connection on a relatively old laptop running ME, and one that i cannot upgrade the OS unfortunately. The Corega ethernet card reports no errors, and Windows appears to be satisfied that it has the correct...

Ken, The COUNTIF function is clearly the simplest and most succinct solution to my particular problem. Thanks again

Indeed, all good ideas, thank to everyone who replied. I had some success with the IF MATCH combination before i read these replies, but as you point out, it does leave you with the problem of having to clear up the #N/A ... i shall try out this ISERR and/or the COUNTIF functions. Much appreciated

I am certain there is a simply way to do this but as yet, none of the excel functions i have looked up seem to do exactly what i am looking for: Essentially i want to create a dummy value for each string in a list according to whether it is in some subset of this list. For example ... If the...

Does anybody know if there is a version of Crystal that supports the Linux platform? Thanks in advance