Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2007

Tip: Looking for answers? Try searching our database.

Mail Merge & Templates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MPotter - 02 Oct 2007 20:05 GMT
Is it possible to use a certificate template from Power Point and do a mail
merge to access all employees (and their department) who attended a seminar?  
I'd like an easy way to produce certificates of completion.  Either I can't
figure this out or it can't be done.  Thank you for any input.
Doug Robbins - Word MVP - 03 Oct 2007 04:03 GMT
Did you really mean Power Point?  Publisher would be a far more suitable
program and it does have mail merging capability.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is it possible to use a certificate template from Power Point and do a
> mail
[quoted text clipped - 3 lines]
> can't
> figure this out or it can't be done.  Thank you for any input.
Peter Jamieson - 03 Oct 2007 08:19 GMT
As Doug suggests, it is possible to Mail Merge from Publisher (in recent
versions, at any rate).

If you are starting from PowerPoint, I haven't done this for real, but let's
suppose you have PP2003 and your template consists of
a. a background image
b. some text boxes where (in PowerPoint) you would type the text

Then you can try:
a. in Word, create a new blank document and lay it out how you want
(correct paper size and orientation in File|Print Setup)
b. In PowerPoint, go to the master page of your template (View|Master|Slide
Master)
c. Edit|Select All
d. Edit|Copy
e. In Word, Edit Paste. The background picture should fill a good part of
the document starting from the top left of the page (not just the bit
between the margins), but you may need to grab the bottom right grab handle
of the graphic and drag is so the graphic fills the whole area.. Any text
boxes in the PowerPoint document (which is presumably where you would have
typed names and other info. in PowerPoint) become text boxes in Word. If you
had to stretch the graphic, you may need to adjust the size and position of
the text boxes.
f. In Word, enable the mail merge toolbar, connect to your data source, and
replace any text in the appropriate text boxes by the merge fields you need
from the data source. Format them as required.
g. Do the merge.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Is it possible to use a certificate template from Power Point and do a
> mail
[quoted text clipped - 3 lines]
> can't
> figure this out or it can't be done.  Thank you for any input.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.