Replies

Thanks very much Geek! The data does not contain a now() entry, but with a wee bit of work, it can. You are an absolute STAR!!

Alba

I’m not able to post an example just now, but what I mean is the removal of the ‘end date’ column. So the end date for a rate would become the cell immediately underneath. I’ll pop an example up in a couple of hours..Thanks!!

Hi,

I’m just working through how to modify this to suit my data – is there a way that I can do the date range lookup based upon the date in the Start column only – ie perform the comparison between the cells vertically with the assumption that the last date for each person has the end date of present day?

??

Alba

Very neat indeed! I should be able to scale this up nicely to work with the data I have – thanks very much for your help with this, I would never have got there without your help!

Alba

Is there no way that the location of the comments boxes can be ‘locked’ – or would I be better to use text boxes that should stay where they have been placed?

Thanks

Excellent Jon – it seemed so strange that the data would not appear, as it still existed in the cells the graph referred to.

Thanks for your help!

Alba

Wow – excellent replies. Thanks to each of you for your input. I have taken a little of each and managed to get a robust solution that will stop people from being numpties and filling things in incorrectly!

Now all I have to manage is the explanation of how to open the file, pick their choices and email back!!

Thanks once more, all the help has been invaluable.

Alba

Hi Steve,

Thanks again for coming back to me. I have attached a rough copy of what I am looking for – I only have 10 or so candidates to select from, that will not change – I had intended for their names to exist within the spreadsheet so that it could be used for creating the list for data validataion, but since it is a relatively small not-changing selection if it would be easier to have the names in code, then I have no objection.

All this because I know that people will be unable to follow simple instructions and will forget that they cannot choose the same person twice..

Thanks again!

Alba

Steve,

Thanks for your reply – this goes part way to solve my issue. However I want to limit the available selection to a list of names as well as only allow the selection of each once. The only way that I know to provide a list of names is to use Data Validation, so is there a way that this can be combined with your solution?

Thanks
Alba

If I can just add my tuppence worth…

We have recently upgraded from IE6 to IE8 and are using Outlook 2003.

All worked fine with graphics (we have selected do not automatically download pictures or other content option in Outlook) however we were always able to right click the graphic to display.

Ever since upgrading to IE8, we have found a number of users have issue with this…if they have full opened the email into its own window and try to right click the graphic to display the graphic does not appear and another wee red cross is displayed. If you right click the graphic in Outlook’s quick view then it will display (most of the time..).

I had though to check my outlook related internet folder to see if it had grown to such as size that it needed clearing out, which as far as the registry tells me is called OLK3 and is a subfolder or temporary internet files. On checking – this no longer exists. Could this be related?

Thanks

Alba

You are a star!!
Thanks!

As an organisation we are not yet at the point of moving to Office 2010 (but have at least made the decision to bypass 2007) so this solution may be some time off – I guess that I will just have to find the most powerful machine that I can in the meantime!

Thanks for your input

Alba

I assume the logo image is hosted on an external web site. If some users automatically download images and others do not, and that second group does not bother manually downloading images for the company’s own logo — I wouldn’t — then that might explain why some have many more of the images in the cache.

Our logo is not stored on an external site, but I think embedded into the email when sent. Looking at the HTML coding that is created within an email the graphic is found with this code:

I’m not sure of how the cid:661164016@31032010-29B9 actually relates to the name and location of the graphic, but I do know that as emails are being sent/received that the OLKxx folder starts to fill up with files named logo.jpg (0), (1) … all the way to logo.jpg (99). Once it reaches logo.jpg (99) (I guess that the folder can only contain 100 instances of files with the same file name??) when you receive through an email with the logo you only see the red cross and if you compose an email – the logo is there to start off with, but as soon as it has been saved (either through autosave, or by saving to drafts) the logo disappears and is replaced by the red cross. My guess is that on saving the email moves from being held in memory to existing in the OLKxx folder…

Its just that for some people this folder builds up more quickly than with others, and ideally I would like the behaviour to stop completely as it is not the easiest thing in the world to help navigate people to their OLK folder.

Thanks for any help/ideas (short of stop using logos in our signatures..)!!

Alba

Morning,

I have now managed to test this out…

If message 1 is the email sent and message 2 is the email attached within message 1, then when I made a change to message 2 and saved it – on reopening from within message 1 the change was not saved. However after making the change on message 2, saving within message 2 and then saving the message 1 – the change made within message 2 was there.

During this testing I checked the contents of my Outlook Secure Temp folder (OLKCA) and at no time did any of the messages make it into this location. So though it is being saved, it does not seem that it is going through the temp folder. I searched thecontents of my computer immediately after for all files that were modified this morning and the only relevant thing that came up from about the time of testing was the .ost file. So is this where it saves??

I am resigned to the fact that the email that was changed yesterday will never return and that the user will have to add their changes again – and in doing so will learn a valuable lesson not to trust Outlook to save attachments within emails…but I’m curios as to how it all works now..

Alba

Thanks to you both. I’ll test the saving of both messages in the morning to see how i get on – we use outlook 2003, so may have some success.

I specifically checked the temporary Internet folders, as I am aware this is where attached files will live, however there were no .MSG files. But then again, is this the format it would take? It was an HTML email, so should it save in this format??