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.
asked Jan 31 '12 at 03:48