Monthly Archives: November 2020

Crystal Reports – number of working days from Today

A client recently asked how he could work out the number of days between a particular date field and today’s date. The answer partly depends on whether the field you are using is actually a Date field or a DateTime … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Microsoft Access – having Switchboard form open automatically

You may have created a Switchboard form to allow users to navigate an Access database more easily. To have the switchboard open on startup: From within the database, click File – Options. Click Current Database. Select Switchboard from the Display … Continue reading

Posted in Microsoft Access, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | Leave a comment

Microsoft Excel Pivot Tables – Preserving formatting when refreshing

I had a client who found that she had spent time getting column widths to her satisfaction when she had created a pivot table. However as soon as she refreshed the data the column widths changed, which she found annoying. … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , , | Leave a comment

Sending an email mailmerge to Outlook contacts

If you want to send an email mailmerge to your Outlook contact list: In Word, go to the Mailings tab. From the Start Mail Merge dropdown, select E-mail Messages. From the Select Recipients dropdown, click Select from Outlook Contacts. You may … Continue reading

Posted in Microsoft Outlook, Microsoft Outlook 2007, Microsoft Outlook 2010, Microsoft Outlook 2013, Microsoft Outlook 2016, Microsoft Word, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016, Outlook 365, Uncategorized | Tagged , , | Leave a comment

Microsoft Outlook – adding a picture or logo to a signature

To add a picture or logo to your Microsoft Outlook signature: Within Outlook, click File – Options. Click the Mail tab. Click the Signatures button. Click New. Type in a name for your signature. Click OK. Type in the required … Continue reading

Posted in Uncategorized | Tagged | Leave a comment