login about faq

Is it possible to do a mail merge to selected users from the GAL in Outlook 07, from a user perspective?

I'm on an Exchange system with 100,000+ users in the GAL (including groups, etc), but only ~500 that I could conceivably need to send these merge emails to (in my physical region), and I have no admin control over the GAL.

Of those ~500 users, I need to be able to send personalized emails to ~50-100 each day to specific users. The ability to print out a log of the emails I sent would be helpful, but is outside the scope of this project (that was one of the reasons I was contemplating Access - update GAL import, re-run query of users in my physical location, enter list of users I need to send the email to, click one button that generates email to each user and creates/prints out the list of users who received the email). I've suspended my investigation of Access as a possible solution because my network administrator called me and told me my import was slowing down the network, after attempting to process the import for 20 minutes.

I don't want to copy these users into my PAB, since changes are made every day to the GAL (with or without me needing to know about it), and keeping my PAB up to date would be an administrative nightmare.

I can't use any add-ons for my Outlook, or install any additional software. I do have permissions to write macros and VBA code.

Any thoughts?

asked Jan 31 '12 at 03:48

RShores's gravatar image

RShores
241127

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:
    [text](http://url.com/ "title")
  • image:
    ![alt text](/path/img.jpg "title")
  • numbered list:
    1. Foo
    2. Bar
  • Code:
    • Within a paragraph:
      `code`
      surround code with grave accents (backticks)
    • Code snippet:
      Select the text and use the button on the icon of zeros and ones
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×49
×2
×1

Asked: Jan 31 '12 at 03:48

Seen: 1,824 times

Last updated: Jan 31 '12 at 03:48

groovyAnswers © 2007 - 2011 All Rights Reserved | Privacy | Contact