Skandus

 

Home
Services
Visual Basic
Office Tips
Geology
Archaeology
Contact
Downloads
Book Reviews
Publications
Outlook Performance
Outlook - Back Up

 

Recently one of our readers posed a question in the Forum about using the Mail merge to create Email mail outs from Microsoft word and Microsoft Access. If you are using Office 2000 (Outlook, Word and Access) or less then everything is as normal!

But, because of the proliferation of Virus and exploit scripts that capture details from Outlook's contact's (Or address book) and because many people on the Net are abusing the power of email for 'Spam' - mass advertising, Microsoft has made some changes to the way mail merge with email works in XP.

Microsoft knows and understands that a well laid out news letter or promotional to your existing clients or reader list is critical in business. It can communicate new product lines, changes in technology or just help in keeping your customer, your customer!

The Problem(S)

When you choose Email Merge, even if you are accessing a Microsoft Access database, when you associate an object to give you an email field you receive the new XP warning that something or some one is trying to access your Contacts address book.

Now if you go past that stage you will need to manually 'OK' every single email, a progress bar and warning makes this take about 30 seconds for each email. So you find your self tied to the computer for days, or you KILL the process and fire up your old Office 2000 machine.

The Solution

If you have migrated the news list from Office 2000 or 97 then you most likely had the mail merge work on TEXT or RTF - as you wanted the mail out to be as Mail Client friendly as possible! (But lets face it, today 95% of people use email clients that handle HTML mail.)

This is now your downfall. Microsoft has recognised that most Spammers and all Virus / exploits send out text emails, so if you select HTML for the format of the body of your Email Merge everything works 'Sweet'.

If you are setting up a new mail merge the default is to use the HTML format for the body of the email. There is very little documentation about this at Microsoft, but is worth reviewing the link they have on their site on how to set up a news letter mail merge.

 

This tip came from Scott McManus of Skandus.
It is important to keep your version of Office and Windows operating system up to date. There are several reasons for this, but the most compelling are:
  • Microsoft from time to time release a patch that upgrades the software with alterations and improvements to the software. These changes either improve the version of software, correct errors found in the software or close loop holes in the software that allow exploits.
  • Critical updates are fixes that are released immediately after a CRITICAL problem is identified. Examples are exploits and security loop holes that may allow your system to be compromised.

You can use "Windows Update", to connect to Microsoft and update either your office software or windows software. It is best to do this at least once a month. If you are connected to the internet you can choose to be Automatically updated or warned of when critical updates are available.

If you are using Office 2000 or above, you will need your original disks to verify that you have a copy of the software. If you connect to the Updater Microsoft does not take information from your machine. If you are using an older version of office you may have to try the specific Microsoft web site for that version to find the service packs. These can be found on the Office home page.

Report a bug to Microsoft.

Go to the office downloads site.

If you are using Office XP the SP(2) is here.

Go to the windows Downloads site.

This tip came from Scott McManus of Skandus.

Uncover the SendTo menu in Windows XP - then manage multiple versions of Access (and other applications)



After making the transition to Access XP on my laptop, one of the Explorer functions that I really missed was modifying the sendto command list.. ie. Being able to right click on an Access database and choose SendTo Access 97/Access 2000/Access XP.  Without that feature,  it can be quite painful opening up the correct version of Access before double clicking on the file.  Anyway, after a lot of searching in XP help, I finally found the trick to expose the SendTo commands.  Here are the steps that you need to follow.  Other send to's that I use are different versions of Word, a decent editor, a decent image editor and folders such as c:\temp. 

 
Figure 1 - SendTo is a great Explorer productivity trick
Click on image above to see full picture

To add a destination to the Send To menu

  1. Open My Computer.
  2. Double-click the disk drive where Windows is installed (usually drive C, unless you have more than one drive on your computer).

    If you can't see the items on your drive when you open it, under System Tasks, click Show the contents of this drive.

  3. Double-click the Documents and Settings folder.
  4. Double-click the folder of a specific user.  
    eg. c:\documents and settings\'user name'\sendto
  5. Double-click the SendTo folder.

    "Here is the catch"  GR

    The SendTo folder is hidden by default. If it is not visible, on the Tools menu, click Folder Options. On the View tab, click Show hidden files and folders.

     

  6. On the File menu, point to New, and then click Shortcut.
  7. Follow the instructions on your screen.

Adding Access Versions to The SendTo Menu

  1. Keep the sendto folder open in your "documents and settings" folder.
  2. Find your Access executable using Windows Explorer.  It will probably be called MSACCESS.EXE and will be in the Office sub directory.
  3. Right click on the file and choose copy.
  4. Return to the SendTo folder and right click in it.  Choose paste shortcut.  Change the shortcut name to something more meaningful such as Access 2000. 
  5. Now when you right click on a file, you will see the send to the list of Access software as in figure 1.

Now you may want to return to folders and turn off the view hidden files options.

 

This tip came from Garry Robinson from VB123.

 

books video music