Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MsWord Mail Merge with Exchange GAL

Posted on 2002-04-25
10
Medium Priority
?
625 Views
Last Modified: 2008-02-01
Is is possible to do a Mail Merge with Ms Word and the Exchange Global Address List? If so, how do you do it?

Is it possible to do a Mail Merge with Ms Word and a Contacts Folder within a Public Folder? If so, how do you do it?
0
Comment
Question by:sleroux
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 6970215
Hi Sleroux, are these real life questions or homework questions?

:O)Bruintje
0
 
LVL 44

Accepted Solution

by:
bruintje earned 400 total points
ID: 6970239
first Q i would say export to Access and do the merge from there > somet hints  http://www.slipstick.com/contacts/print.htm

second Q > you can find a pointer here http://support.microsoft.com/default.aspx?scid=kb;EN-US;q229851

:O)Bruintje
0
 

Author Comment

by:sleroux
ID: 6970984
What we're trying to do in our Corporate network is provide all employees with a document that will automatically get the contacts info from the Exchange server (GlocalAddressList or PublicFolder) and put it in a specific format for printing.

The formats provided by Outlook are not feasible for our needs.
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 44

Expert Comment

by:bruintje
ID: 6971006
have you looked at the first link on the slipstick site? there are some links there to ways and tools to do this

is this a recurring task? then it could be scripted once the procedure is clear

:O)Bruintje
0
 

Author Comment

by:sleroux
ID: 6971017
This will be definitely a recurring task.
And must be automated so that all employees can use it.

Can you provide me with the specific link that has the procedure on how to do this.

Thanks.
0
 
LVL 6

Expert Comment

by:bkpchs237
ID: 6971873
sleroux,

I don't know of anyway to use the GAL for a mail merge unless you copy the entire thing into your personal address book or contacts list, which is usually not feasible.

As far as the public folder, try right-clicking the folder and choosing add as an email address book.  Then add this folder as a service.

Hope this helps.
0
 

Author Comment

by:sleroux
ID: 6971885
I'd like so that we don't have to make any change on our 250 employees Machines.

There must be a way...
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6973726
My vote: I disagree. The global address list is a pain in the bupkiss. Perhaps you ought to have your Email administrator export the GAL every morning to an Excel, Access or other flat file format for your users. (That is, if they can. I've never been an email admin and don't know the capabilities of the exchange server.)

Excel or Access would be best because these are shareable. Unfortunately, PST files are not, so this is not an option for export.

~Dreamboat
www.TheWordExpert.com
0
 

Author Comment

by:sleroux
ID: 6977055
We figured that we'll use an Access database that will produce the report and the user can print that report... that seams to be the only way.

I'll award the points to bruintje because I got the answer at http://www.slipstick.com/contacts/print.htm.

0
 
LVL 44

Expert Comment

by:bruintje
ID: 6977245
thanks, glad i could help
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question