• 0
RShores

Mail merge from GAL, Outlook 2007?

Question

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?

Share this post


Link to post
Share on other sites

0 answers to this question

There have been no answers to this question yet

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • By Steve
      A feature I use all the time in Microsoft Outlook 2013 (Office 2013) is the ability to open a calendar invite during a meeting and click - Meeting Notes. See screenshot from Outlook 2013.
       
      [attachment=0]outlook-2016.jpg[/attachment]
       
      After installing Office 2016, when I open up outlook I no longer have that option in the calendar. It's just missing.
       
      Is anyone else having this issue or is it just me?
       
      Hopefully this is just an issue with the Preview and it will get fixed later during full release.
    • By pts123
      I have tried other Forums and no one seems to have a fix for this, but I just keep on trying.
       
      I am having an issue with the “Junk” filter in Microsoft Office Outlook 2010. I am unable to stop some email from being filtered and moved to the “Junk” filter. My mail is filtered prior to my getting it, so I WANT IT COMPLETELY OFF! I went to the Junk drop down on the Home menu bar and selected Junk E-mail Options. I click on the lowest setting being . . . No Automatic Filtering. Mail from blocked senders is still moved to the Junk E-mail Folder. And I have no one listed in the Block Senders list, so that should mean, nothing is filtered. But, a small portion of my e-mail still ends up there. Ahhh – I and can’t stop it.
    • By johnstanly8
      I am using Outlook 2003.I have huge numbers of .pst files . I want to manage Outlook by dividing PST files by Folder. But i don't want to compact files.
       
      -Jhon
    • By Steve
      Question from Reader - Email Form
       
       
      Hi Tom,
       
      Ouch. I know how it feels losing a days worth of work. The worst part is when you have to recreate what you've already done.
       
      To answer your question, when you found the Entry "OutlookSecureTempFolder" what was the path in the DATA column? I assume you reviewed this post here to find it. It looks like you found the registry key entry so your more than 1/2 way there. Find that key again and you should have the path to your OLK folder and your Excel should be sitting there.
       
      Now the path might be a bit confusing because with Outlook 2007, there actually is "NOT" an OLK folder. For instance, on my XP/Outlook 2007 install, my OLK folder or "Temp Outlook Folder" / "OutlookSecureTempFolder" is:
       
      "c:\Documents and Settings\mrgroove\Local Settings\Temporary Internet Files\Content.Outlook\4V32TZLP"
       
      So if you look on your box you will find what your looking for in the "Content.Outlook" folder. Take a look there and your golden.
       
      Let me know how this works for you!
    • By texmex
      Hey Mr Groove! Love the site and really enjoyed your last article!
       
      I have an idea for a new article on groovypost for you! You need to write something on all the different search syntax that can be used in outlook 2007!
       
      I only use a few of the features but would love to get the inside scoop.
       

  • Who's Online   0 Members, 0 Anonymous, 22 Guests (See full list)

    There are no registered users currently online