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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.