Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-19-2018, 12:27 PM
lulu55 lulu55 is offline Windows 10 Office 2013
Novice
 
Join Date: Mar 2018
Posts: 1
lulu55 is on a distinguished road
Default Mail Merging Unique QR URLS from Excel to Word

Hello- We are looking to merge QR URLS from Excel to Word on name badges for a large conference. Each QR URL is unique to the person and they use them to scan in to each session at the conference. In the past we used Avery Design and Print software which converted the URL from a weblink to an image when placed into the Avery Design and Print Software. We have designed and changed the size of our badges to a now non-Avery compliant size and we need to figure out a way to just do this directly from Excel to Word.



I have tried

{MERGEBARCODE «URL» QR \h 1 \q L}
{MERGEBARCODE «URL» QR \q 3}

and

{INSERT PICTURE} formulas.

no luck.
Reply With Quote
  #2  
Old 03-29-2018, 03:00 PM
macropod's Avatar
macropod macropod is online now 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

You should be able to use the MERGEBARCODE field with the name of the data field in place of «URL». See:
https://msdn.microsoft.com/en-us/lib...ice.12%29.aspx
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merging Excel information into Powerpoint Tami PowerPoint 1 06-11-2015 09:58 PM
Mail Merging Word by excel sheet Marcovalkenburg Mail Merge 3 06-05-2015 05:40 PM
Excel list to Word with Page Break on new unique data jeverett1 Mail Merge 3 07-30-2014 11:59 AM
Loss of formulae values when mail merging excel to word MellowMel Mail Merge 6 05-09-2014 09:08 AM
Mail merging and pulling varying data from Excel shannag1881 Mail Merge 0 10-05-2009 08:51 AM


All times are GMT -7. The time now is 07:49 PM.


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