Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2017, 10:42 AM
ayupchap ayupchap is offline Creating and merging QR codes with Word 2013? Mac OS X Creating and merging QR codes with Word 2013? Office 2013
Novice
Creating and merging QR codes with Word 2013?
 
Join Date: Oct 2016
Posts: 8
ayupchap is on a distinguished road
Default Creating and merging QR codes with Word 2013?

Hi all

Hope someone can help me. I have a list of 30 URLS which I want to create Qr codes for and then mail-merge them. I have other fields, standard mail-merge type fields such as name etc but really want to have a qr code come out with them. How is this possible or is it even?



I currently have the list of urls in excel and then want to create a mail-merge from the excel list but I am at a loss on how to get the QR code for the url, embed into the excel sheet and then mail-merge. There has to be a way right?
Reply With Quote
  #2  
Old 04-24-2017, 05:36 PM
macropod's Avatar
macropod macropod is offline Creating and merging QR codes with Word 2013? Windows 7 64bit Creating and merging QR codes with Word 2013? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

To generate a QR barcode, you need to insert the MERGEFIELD into a DISPLAYBARCODE field, coded along the lines of:
{DISPLAYBARCODE «URL» QR \q 3}
or:
{DISPLAYBARCODE {MERGEFIELD URL} QR \q 3}
where 'URL' is your field name. See: https://msdn.microsoft.com/en-us/lib...ce.12%29.aspx?

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-25-2017, 10:06 AM
ayupchap ayupchap is offline Creating and merging QR codes with Word 2013? Mac OS X Creating and merging QR codes with Word 2013? Office 2013
Novice
Creating and merging QR codes with Word 2013?
 
Join Date: Oct 2016
Posts: 8
ayupchap is on a distinguished road
Smile

Oh this is amazing thank so much!
Reply With Quote
  #4  
Old 04-25-2017, 08:12 PM
gmayor's Avatar
gmayor gmayor is offline Creating and merging QR codes with Word 2013? Windows 10 Creating and merging QR codes with Word 2013? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Give that this is mailmerge, there is also
{MERGEBARCODE field_name QR \h 1 \q L}


https://msdn.microsoft.com/en-us/lib...ffice.12).aspx
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating and merging QR codes with Word 2013? Word 2016 cannot hide field codes in document created by work 2013 twinclouds Word 2 03-10-2017 03:15 PM
Creating Barcode Badges using Microsoft Word Mail Merge 2013 Sarah15 Mail Merge 4 04-16-2015 06:03 AM
Office 2013 Error Codes 30175-13 and 30027-4 JohnStanza Office 0 03-24-2015 12:19 PM
Creating and merging QR codes with Word 2013? Creating an index for a book in Word 2013 nrsmd Word 1 01-15-2015 08:50 PM
merging data sets in excel 2013 nwiabrad Excel 9 07-24-2014 12:07 AM

Other Forums: Access Forums

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


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