Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2014, 06:15 AM
DaZ DaZ is offline Possible Macro to read and change name whilst printing certificate Windows 7 64bit Possible Macro to read and change name whilst printing certificate Office 2013
Novice
Possible Macro to read and change name whilst printing certificate
 
Join Date: Sep 2014
Location: Staffordshire England
Posts: 5
DaZ is on a distinguished road
Default Possible Macro to read and change name whilst printing certificate

Hi All,



Hope your all well

I have been given a task of creating a certificate (which isn't the problem)

The problem I have is I need to assign a signature to it
And also I need it so that where the Name is It will read from a list of names

So when printing the certificate it will print lets say 10 certificates but the name will change on each one without me having to go through typing names it would just read from a list of names

Is this possible?

Any help would be much appreciated many thanks
Reply With Quote
  #2  
Old 09-05-2014, 06:46 AM
macropod's Avatar
macropod macropod is offline Possible Macro to read and change name whilst printing certificate Windows 7 64bit Possible Macro to read and change name whilst printing certificate Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Is there a reason for not using mailmerge for this?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-05-2014, 07:13 AM
DaZ DaZ is offline Possible Macro to read and change name whilst printing certificate Windows 7 64bit Possible Macro to read and change name whilst printing certificate Office 2013
Novice
Possible Macro to read and change name whilst printing certificate
 
Join Date: Sep 2014
Location: Staffordshire England
Posts: 5
DaZ is on a distinguished road
Default

Hi

Many thanks for the reply not sure what mailmerge is or how it works would this be what I need to look into?

Thanks again
Reply With Quote
  #4  
Old 09-05-2014, 05:31 PM
macropod's Avatar
macropod macropod is offline Possible Macro to read and change name whilst printing certificate Windows 7 64bit Possible Macro to read and change name whilst printing certificate Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See, for example:
http://office.microsoft.com/en-us/wo...101857701.aspx
http://support.microsoft.com/kb/294683
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible Macro to read and change name whilst printing certificate DaZ Excel Programming 5 09-06-2014 10:50 AM
Email macro to read range for .To field MattMurdock Excel Programming 2 08-07-2012 06:46 AM
Possible Macro to read and change name whilst printing certificate Macro to read word document harishankar.selvaraju Excel Programming 1 06-14-2012 03:48 AM
Possible Macro to read and change name whilst printing certificate Change personal folder items to 'read" J C M Outlook 1 01-09-2012 10:42 AM
Change Display Name when printing Lucky7MQ Outlook 0 12-10-2005 10:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft