• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1:I need to update the area code field on many of my contacts. I tried using the Group By method to change it and changed the entire phone number. Is there a way to change the area code for a large number of contacts without editing each contact?
A1: No, you aren't doing it wrong; Outlook doesn't support changing the area code this way. As you've discovered, it works when you need to change the entire phone number for a company, but not when only the area code changes.

There are several methods you can use to change the area code. If you only have a few phone numbers to change, use in-cell editing and change the number without opening the contact form. You can also export to Excel and use Replace to change the area codes, or write a VBA procedure to change the area code.

Q2:When I do a mail merge to email, I get a security dialog and need to allow access for up to 10 minutes, and then I wait and click Yes for each message. What can I do to get rid of the dialogs?
A2: My crystal ball tells me that you're merging to a plain text–formatted message. If you merge to HTML format, you won't get the dialogs. You can use a script called ClickYes to press the buttons for you, if you really want to use plain text. Look for a link to it at www.slipstick.com.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint