Hi,
I am trying to generate certificates in Excel and I have like 5000 certificates to generate. I have attached the excel files which has a spreadsheet with all the data which i need to fill in for each certificate. Now i want to know how to i generate certificates one by one without doing all the work manually.
P.S. sorry if i posted it in the wrong section.
maybe it will help:
Mail merge without word
or
here
Last edited by sandy666; 12-27-2015 at 09:24 AM.
Can you please help me how I can use Mail merge with my document please. I'm a Excel noob actually.
Sample Mail merge using word.
"Motor_Certificate" is the template for your certificates: it will need editing to your requirements.
"Certificate" is the data source (Sheet "Data"): add your data here OR create an Excel file with same headings in row 1 and data from row 2 onwards. If you create a new file you will need to make this file the source in Mail Merge
"Certificates" is the output from the mail merge
You will need to read up on Mail Merge but basically go into Mailings in Word and follow the Mail Merge steps
Hope this helps to get you started.
Thanks for the help. Actually when I Insert All the merge field, its only picking the data which is numeric and showing a zero for alphabetical ones. Please help.
Last edited by msb15; 12-28-2015 at 08:41 AM.
I cannot help without any files: you will see from my "Certificates" Word document that it selected ALL fields. There is no reason why it should only select numeric fields.
Look at
http://www.gcflearnfree.org/word2013/31
https://support.office.com/en-nz/art...f-932c49474705
Last edited by JohnTopley; 12-28-2015 at 11:41 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks