Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-24-2017, 10:42 AM
ayupchap ayupchap is offline Mac OS X Office 2013
Novice
 
Join Date: Oct 2016
Posts: 6
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 04-25-2017, 10:06 AM
ayupchap ayupchap is offline Mac OS X Office 2013
Novice
 
Join Date: Oct 2016
Posts: 6
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 Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,705
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
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)
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
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 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


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft