ICTICT308 ICTSAS410 IT Skills 1

 Mail Merge In today's class, we will look at how we can integrate the Office applications seamlessly (well almost), and in particular, integrating into Word. We will start with the humble Mail Merge. Access I have created this simple database using a template and have added some contact information. This is what it looks like: We will use this file to create a MS Word Email Merge. Create your email message Use the Wizard to continue to the next step and to finally create your email merge. The principle is the same whether it is an email merge or an actual mail merge with labels or envelopes. Nowadays, though, email merges are much more common than the old fashioned letter drop. Excel Mail Merge with excel is very similar. Follow the Step by Step Wizard, select your spreadsheet as the source, and select the recipients. Mail Merge Activity Follow the steps to complete an email merge with the spreadsheet and the database. Sorting in Word One might think - "why do I need to know ...

Building Blocks Quick Parts Building Blocks are part of Quick Parts, which you will find on the Insert ribbon. Quick parts can be used to store snippets of text or even text/images that are used regularly. An example could be a signature line. I actually have a signature that I did with black pen on white paper, scanned, and cleaned up. In Word, I removed the background to make it transparent. I then saved it out as a PNG file so it can be used in lots of applications, including acrobat reader. The following example was created by taking a photo of my signature on white paper and using my phone. I then emailed it to myself to get it quickly on to the computer, I had to clean it up a bit using Pixlr as my camera picked up shadows etc. I removed the background and saved it as PNG In Word, I inserted it and added my titles and other details, just as I would if I had signed it. Image inserted with appropriate text Use Select All to select the signature ...