Default mail account in Outlook

I did a mail merge to e-mail in Outlook 2016 on Windows 10. Before i did this i ensured the default account was set correctly, but instead the e-mail went from the club’s gmail account and not our own domain.

Turns out that the default account in Outlook is frequently ignored and uses the address for the message store that currently has focus. Now annoyingly i use this every day at work, and i’m aware of the behaviour and actually like it. However, this is not so great for sending of mail merged e-mail.

On having a google around I came across this post http://www.slipstick.com/outlook/outlook-2010/multiple-accounts-and-the-default-account/ which details how to get this fixed. I’ve included the registry links after the break should this site go down. Continue reading “Default mail account in Outlook”

Advertisements

Calculating fiscal month number in Excel

This has come via this post at Mr Excel. and a response provided by Ron Coderre.

Assuming the fiscal year starts in April, the formula below will give you the fiscal month.

=MONTH(EDATE(A1,9))

The value of ‘9’ is derived by the months remaining in the year that are the new financial year. In this case there are 9 months left in the year that are the new financial year (April, May, June, July, August, September, October, November, December)

Inbox wrangling

A few months ago I started using a tickler file like system in outlook. My inbox got removed from sight and I moved e-mails from there to a ‘working folder’ a couple of times a day. 

This worked well, but there was a lot of moving e-mails about. This was annoying as there is enough metadata in outlook to enable this automatically, so after working with the system I spent some time and implemented using Outlook’s powerful (but under documented) search folders. 

  
My e-mail folders now look like that, with my work flow bring as follows. 

E-mail gets moved into the ‘unprocessed e-mail’ folder a couple of times each day. From there the e-mails are processed (GTD based – email actioned if it will take 2 minutes or less). If the e-mail will take longer a due date is set which will then have it appearing in specific folders. 

Each morning e-mail due  from yesterday gets a quick review and either marked as completed or has the due date altered, which may not necessarily be today.

So far this system is working well – it keeps my inbox clear and means I know exactly what is outstanding. 

Surface Curious

A brush with a Lumia, a less than stunning version of office for the mac, a need to do some stuff with Access for the rugby club I’m secretary for, and the intrigue of pen input has lead me to wanting to try a Microsoft Surface. I’ve ordered a Surface 3, 4gig ram and 128 gig hard drive. It is waiting for me when I get home, so thoughts on it will follow.

Reporting on activity by week

This is a rewrite of this post as i completely failed to understand what i’d written. The original text is left after the break for completeness.

A week is a unit of time that has to be derived, and therefore has multiple meanings. Some business will run Monday to Friday, others will run Sunday to Saturday. To calculate the week, you need to know what date the first day of that week occurred on. This is actually quite easy to derive as you will know what day of the week the current day is. If you are running a Monday – Sunday week then if today is Tuesday, it is day 2 of the week, therefore the date the week starts will be 1 day ago. If the day is Thursday, this will be day 4 of the week, therefore the date teh week starts will be 3 days ago.

To achieve this is Cognos Report Studio we will use two funcitons.

The first function is

_day_of_week ( date_expression, integer )

The first parameter is the date you want to know the day of week of. The second paramater is the day that starts the week. 1 = Monday, 2 = Tuesday, etc. So in this case we will use the value 1. This will return the day of the week.

The second function is

_add_days ( date_expression, integer_expression )
This take the first parameter, and adds to it the number of days sepcified in the second. If you prefix the second paramater with a minus (-) then it will remove that number of days.

So to work out the week number, we need to take the

Day of the week, and remove that many days from the current date. However  as the first day of the week is day 1, and not day 0. So to compensate for this we need to add another day on.

The final formula would be
_add_days(cast([Transaction Date],date),-_day_of_week([Transaction Date],1)+1)

Continue reading “Reporting on activity by week”