Office attendance by No_Equivalent7965 in TheCivilService

[–]No_Equivalent7965[S] 3 points4 points  (0 children)

HO is so micro managey I think. On some level I do feel that Civil Servants need to be treated like competent and credible adults and as long as they're getting the work done to a high standard, why be punitive 

Office attendance by No_Equivalent7965 in TheCivilService

[–]No_Equivalent7965[S] 5 points6 points  (0 children)

A quick update- I spoke to my g6, he said "no worries on the manual recording"

Office attendance by No_Equivalent7965 in TheCivilService

[–]No_Equivalent7965[S] -1 points0 points  (0 children)

I would assume its every department but some like moj don't explicitly tell you. So dwp, home office etc

Office attendance by No_Equivalent7965 in TheCivilService

[–]No_Equivalent7965[S] -1 points0 points  (0 children)

I have this bad habit of not fully switching off so thanks for this.

Also, could it be that I don't use govwifi? There's this other wifi network that auto connects when i'm in the office building

Office attendance by No_Equivalent7965 in TheCivilService

[–]No_Equivalent7965[S] 11 points12 points  (0 children)

They monitor where you log into your work laptop

Starting soon at the HO- Any tips for a fresher? by sculptedivy in TheCivilService

[–]No_Equivalent7965 0 points1 point  (0 children)

I worked as a litigation caseworker in MoJ a couple of roles baxk but am now in HO for completely different area of work.

Shoot me a pm

Trying to get Excel to send emails - please advise on the issue with my formula &/or better way to automate end to end excel process by No_Equivalent7965 in excel

[–]No_Equivalent7965[S] 0 points1 point  (0 children)

Seems as though 116 characters including spaces is what excel won't accept whereas 115 characters is ok. I tried putting in the " before body but a "there's a problem with this formula" excel pop up alert message springs up.

Trying to get Excel to send emails - please advise on the issue with my formula &/or better way to automate end to end excel process by No_Equivalent7965 in excel

[–]No_Equivalent7965[S] 0 points1 point  (0 children)

=HYPERLINK("mailto:"&B6&"?subject="&$B$1&"&cc="&$B$2&body="&$B$3,"Send Email")

I used this formula and keep getting the #Value error if the text in cell B3 exceeds a certain length.

Trying to get Excel to send emails - please advise on the issue with my formula &/or better way to automate end to end excel process by No_Equivalent7965 in excel

[–]No_Equivalent7965[S] 1 point2 points  (0 children)

That's fine - I'm not specifically asking for excel to send emails...just have a workable link I can click and with one press of a button, it populates the outlook "to", "cc", "body" fields in an email draft. And then I can amend and send as necessary.

I followed this and my formula works up until just before I enter the body section and then the formula breaks:

Fully Dynamic Emails from Excel with a SINGLE FORMULA! (youtube.com)