Make us your home page
Instagram

Today’s top headlines delivered to you daily.

(View our Privacy Policy)

Solutions: For your mailing lists, try Microsoft Access

I started PC use with a Gateway and Word/Excel 2000. I taught myself mail merge with Excel spreadsheet mailing lists. I ran my organization's newsletter mailer for years until I upgraded to a Dell Dimension loaded with Windows XP and Word/Excel 2003. The old procedure I used blindfolded was useless, and I haven't found anyone to help redirect my approach other than "single label" or an entire sheet of the same. I follow directions reasonably well.

One thing you may want to consider is using Microsoft Access instead of Excel to print your labels. You can use Access' File, Get External Data, Import to read in your Excel data to an Access Table and then use the Label wizard as follows: In the Database window, click Reports, click New on the Database window toolbar and select the Label Wizard. Follow the directions. Ultimately, this will give you much more flexibility in maintaining your labels database.

I have replaced motherboards, RAM and hard drives before in systems, but I am stumped with my Dell Dimension 8200 with 1.5 GB of RAM. Currently I have a 40 GB Maxtor hard drive that came with the unit, and I am quickly running out of space. Usually I would just replace the drive, but I am worried about the size differential and if I will have to update the BIOS to accommodate that larger size. In addition, while I understand that the main difference in hard drive technology now revolves around the cable for SATA and EIDE drives, I am finding it hard to locate a "fast" internal drive without having to purchase a SATA card. I know you cannot suggest specific company drives, but would it be easier to replace the hard drive or purchase an external drive and use it as the start up drive?

Most modern BIOSes will automatically detect the different disc drive geometry. I'm assuming that your motherboard has connections only for the older EIDE and that you'd prefer to buy a SATA hard drive. In this case you would have to use an EIDE-to-SATA adapter card as you already mentioned. But consider this: The difference in drive access times between the two technologies is not as dramatic after you figure in things like disc caching. The good news is that the SATA adapters are relatively inexpensive and work well.

I have both Norton and Windows Defender using XP. Are both necessary or is Defender sufficient for protection?

Some versions of Symantec's Norton AntiVirus, such as the 2008 version, include an antispyware component. In this case it wouldn't hurt to also run Windows Defender, but it is probably not necessary. If your version of NAV includes antispyware, my recommendation would be to disable Windows Defender. But be sure to confirm with Symantec what your version contains.

Correction

Last week a reader wrote in to say that his version of AVG Free Anti-Virus would no longer be eligible for updates after June 25. This pertains only to version 7.5. Version 8.0 is the latest version and is free along with its auto updates; however, it will not run on Windows ME or Windows 98.

Send questions to personaltech@sptimes.com or Personal Tech, P.O. Box 1121, St. Petersburg, FL 33731. Questions are answered only in this column.

Solutions: For your mailing lists, try Microsoft Access 07/20/08 [Last modified: Monday, July 21, 2008 9:41am]
Photo reprints | Article reprints

© 2017 Tampa Bay Times

    

Join the discussion: Click to view comments, add yours

Loading...
  1. What you need to know for Wednesday, July 26

    News

    Catching you up on overnight happenings, and what you need to know today.

    A heart-shaped box containing Katie Golden's ashes sits next to her picture at her family's South Tampa home. Katie died from a drug overdose in April 2017. She was only 17-years-old. Read about her parents' journey at tampabay.com. [ALESSANDRA DA PRA | Times]
  2. Cuban diplomat reflects on U.S. relationship: 'Cuba was treated horribly'

    Perspective

    Few topics are more controversial in Florida than Cuba, a nation that has held fast to Communism despite lying 90 miles from the shores of a capitalist superpower. It's a place where startling poverty results from either a longtime U.S. trade embargo or a half-century of Communism, depending on one's point of view. …

    Carlos Alzugaray spent a half century as a scholar and diplomat for the Cuban government, including a stint as ambassador to the European Union.
  3. Clearwater residents avoid tax rate increase for ninth year in row

    Local Government

    CLEARWATER — Residents will avoid a rate hike on their property taxes for the ninth year in a row as taxable values continue to recover from recession levels, padding city coffers.

    Clearwater Mayor George Cretekos said the city must be prepared for unexpected expenses. JIM DAMASKE   |   Times
  4. Rays beat Orioles, but tough stretch looms that could change their plans (w/video)

    The Heater

    ST. PETERSBURG — Tuesday was a step back in the right direction for the Rays, who halted a season-high five-game losing streak by hanging on — and we mean that pretty much literally — for a 5-4 win over the Orioles.

    The Rays’ Tim Beckham celebrates with Mallex Smith after hitting a three-run homer in the second inning for a 5-0 lead.
  5. Diaz, Taddeo win easily in special Miami Senate primaries

    Blogs

    Two Miami state Senate candidates who raised and spent the most in their respective primaries — Republican Rep. Jose Felix Diaz and Democratic businesswoman Annette Taddeo — notched easy victories in a special election Tuesday night.

    Republican candidate Jose Felix Diaz is surrounded by supporters after he won the primary for Florida’s Senate District 40 race. Democrat Annette Taddeo, right, celebrates her victory with supporter Venus Lovely at BJ’s Restaurant in The Falls.