Data Merge for Envelope Labels in Adobe InDesign
Вставка
- Опубліковано 22 січ 2020
- Although it can be a little glitchy, the Data Merge function in InDesign can save you tons of time when making address labels!
Here's the template used in this video: www.avery.com/templates/8160
Join our FREE Illustrator Facebook Group: / adobeillustratorusershelp
Get your first month of Skillshare FREE: bit.ly/3LSFlvz
Get a great deal on Adobe Creative Cloud: • Free/Cheap Illustrator...
Learn to make your own fonts with Fontself: • Create Your Own Font I...
Help support the channel, buy me a coffee! :D www.buymeacoffee.com/fuyikixosa
My recording setup (btw some of these are Amazon affiliate links):
Lighting: Woods Clamp lighting (I use 2 of these) amzn.to/2UZ4wRb
Camera: iPhone 11
Blue Snowball mic (on screen capture videos) - amzn.to/2rZycQZ
Recording software: Quicktime
Editing software: Adobe Premiere Pro and Adobe After Effects
If you're interested in other graphic design video topics, check out some of these:
➝ PASSIVE INCOME
Five things I wish I knew starting out as a passive income graphic designer - • Five things I wish I k...
What it's like to be a Freelance and Passive Income Graphic Designer - • What it's like to be a...
10 Ways make passive income as a graphic designer in 2018 - Graphic Design How to - • 10 Ways make passive i...
➝ ILLUSTRATOR
Pen Tool Tips and Tricks in Adobe Illustrator - • Pen Tool Tips and Tric...
How to make a shiny gold text effect in Adobe Illustrator - • How to make a shiny go...
How to Reverse Path Direction in Illustrator for After Effects - • How to Reverse Path Di...
➝ INDESIGN
How to Align Text under Bullets in Adobe Indesign - • How to Align Text unde...
How to Place a Multiple Page PDF in Adobe Indesign - • How to Place a Multipl...
How to Create a Clickable Hyperlink in Adobe InDesign CC - • How to Create a Clicka...
➝ PHOTOSHOP
How to Replace a Font in a Photoshop File - • How to Replace a Font ...
How to use the Object Selection Tool in Photoshop CC 2020 - • How to use the Object ...
How to cut out hair with the Select and Mask tool in Photoshop - • How to cut out hair wi...
My video descriptions may contain affiliate links. If you buy something through one of these links, you don’t pay any extra money, but I get a small commission, which helps keep the lights on. Thank you!
Learn how to ETHICALLY get Adobe CC free (or cheap) here: ua-cam.com/video/9b2rlS3dSjQ/v-deo.html
You are a ROCK STAR in my book! I've done a lot of data merge in my long career, but never before with InDesign, and finding the right process for 3-up labels was a headache until I found your video. Clear, concise, perfect! Thanks!
Thank you so much!! I really appreciate it!
Was having a hell of a time figuring this out and Adobe's help was awful. This got me up to speed quickly. Thanks!
You're welcome - and thank you so much!!
Thank you so much! You do an excellent job of explaining a left-brained process to this right-brained thinker - much appreciated!
You're welcome 😊 And thank you so much!!
That was amazing!! Been doing merges for years in a Printshop and never knew about the multiple screen!!! Thank you soooo much!!!
You're welcome!! :D
Graphic Design How To When I output to PDF ....
all the pages are blank.
The preview shows a perfect population
Of fields.
But pdf nothing.
Thoughts?
Thank you for posting this!
You're welcome!!
Great video! It was so easy to understand, and your skills and sequence make it a no-brainer. I was able to learn Data merge in the few minutes your video took to watch. Thank you!
Thank you so much!!
This was so helpful! I was able to use this info to do both nametags and name placards. Thank you!
Yes - if you have more than 30, it should automatically create another page!
Ugh I admire you for your patience????? I started mail merging 20 years ago with relatively hardly any glitches in Microsoft products. InDesign and Avery should have this seamlessly figured out by now. I am so tired of wasting my time trying to figure out Indesign.
Yes, I used to love the Microsoft products for mail merge, but now I'm totally an InDesign convert for that! Once you do it a few times, it gets easier. It would be nice if Avery and InDesign got together on it, though!
Thanks you! We were having the biggest problem until you said to start a new document and NOT use the Avery template. As soon as we did, BAM! Worked like a charm. Your the starr.
You're welcome! 😊 I'm so glad it helped! Yes, it's weird that the Avery template causes it not to work!
Thank you for this video! First time using InDesign to make attendee badges from an Avery template. I was so lost on how to merge multiple records on a single page. This video helped me figure it out and I just wanted to share my gratitude. THANK YOU
Awesome; I'm so glad the video helped!!
FANTASTIC tutorial! Thank you!
You're welcome!! And thank you!
Yes this video was awesome. I'm pretty sure that there aren't enough out there on data merge and it's other uses (other than mailing lists)
Thank you! I know I had a hard time researching it!
This was sooooooo helpful. Thank you so much!
You’re welcome 😊 and thank you!!
Perfect, exactly what I was looking for. I've done it in Word before, but I want to generate gallery labels with QR codes from my database, so the helped a lot - thank you.
You're welcome!! The labels with QR codes is a perfect application for this. :D
THANK YOU! This just saved me so much time.
You're welcome! I'm so happy to hear that!
nice way to teach graphics.thankx
Thank you!!
Thanks for this video, I’ve never used Data Merge, so it’s good to learn something new with a function that I’m not overly familiar with. I’ve been working on a company catalogue using an imported XML file, which is in some ways similar to this, in that it can speed up the process, but can be fiddly when setting it up.
Very interesting - I might need to learn / make a video on that! Thank you for commenting! :D
I didn’t actually do the coding for the XML file, just imported it, but using XML can import text and graphics, in this case, into a catalogue with a predefined layout. A video on this would be interesting.
@@flytetime7637 Ok! It sounds complicated but I'll see if I can figure it out! Thank you!!
Thank you! This was an amazing tutorial.
Thank you so much!!
Thank you....good solution to import images
You're welcome!
Thank you ♥️
You're welcome!!
this is very useful!
Thank you - I'm so glad it was helpful!
Thank you!
You're welcome!
Thanks so much
You're welcome!
Thank you so much for this! I'm trying to do small stickers for a venue seating. Hence I want "Row 1" on one row, and "Seat 1" on the next. And then increase from there. When I do this, after copying your example on the video, I get the result "Row 1;Seat 1" and can't formate them as separate rows on the sticker. What am I missing here? Again, thanks so much!
Hmm, I'm not sure. All I did to get to the next line was hit Return on the keyboard, then enter the record. ua-cam.com/video/sXIZroAKitE/v-deo.html
You nailed it on the head with regards to Avery templates. You have to delete the template layer that came with the templates and it works! It took me frustrating hours to figure that one out. I think this is some kind of not fully developed feature. Multiple records merge prefers to have a single layer.
That's good to know!! Thank you so much!
This just saved my morning! I was getting one per page and I was stumped. I had disabled my template layer, but deleting the layer made it work. Thanks!
Thanks
You're welcome 😊
Great video!! Very clear and concise. Have never worked with Data Merge but have a project that this would be awesome to incorporate. I did it step by step and am creating 4"x2" mailing labels by Avery (8163) and created a new document. I'm not sure what's going on because for my test set up, I have 10 names/addresses in my Excel doc but when I preview the merge, I only get one column for a total of 5 labels.
Thank you - I'm glad it was helpful! It sounds like your text box might be too wide, so Indesign can only fit 1 column. If it's even .001" too wide, it will cut it down to one column.
THANKS
You're welcome!!
Thanks Anne! I used this method for images. Do you know if there’s any way to update the document without re-merging it? It’s basically a business card directory and every year members change but I need to keep the cover and other pages the same each year. I don’t want to have to copy and paste all the unchanged pages, if that makes sense.
If there is a way, I haven't figured it out. I have to make a new re-merged document every time I want to update something. :/ So that kind of stinks!
Graphic Design How To We can only hope for an update! 😊
@@laurad.1178 yes!! :D
This worked great, thank you so much! One thing I wanted to add is that if you have a column of data that is not filled for every cell (i.e. maybe you have a second address column for Suite #s and only a few companies have this info), it gave me an error notification. So, I just added any Suite info with the other address column and it imported into InDesign fine.
You're welcome - I'm so glad it helped!! That is good info about the unfilled data - thank you!
Very helpful! Do you know if there is a way to do a multi record mail merge with other data on the document? I'm trying to do a postcard style mail merge, but the same address is showing up.
Yes - you'll need to add columns for the other info, then call each column in the document. This other video might help: ua-cam.com/video/sX1JQ39c3DI/v-deo.html
@@GDHT Thank you so much!! This is VERY helpful!!
Hello, Thank you so much for your video! I am creating stickers for wedding invitations and i was wondering how can you save each sticker individually on a PDF to be best for printing, and not all together? Thank you
I have another video that shows how to put each label on an individual page: ua-cam.com/video/sX1JQ39c3DI/v-deo.html
@@GDHT thank youu very much!!! ❤️🙏🏼
You're welcome 😊
Thank you for your tutorial. I have one mishap needing your clarity... When the Create Merged Document portion, my computer doesn't allow me to select multiple records.... how do I change that? From only allowing a single....
I'm thinking you might have things set up where only one record fits on each page. InDesign can automatically try to put more on each page, but only if they fit.
for some reason its only creating a document with the first address. how do I get it so the whole page has all the addresses on it?
Can you let me know at what minute and second you start having trouble (in the video)?
Hmmm... I've saved my excel files as a CSV 3 different ways & cannot get IND to recognize. I'm on a PC though. I did a save as from excel. I did an export. I copied and pasted the data from a downloaded doc to a new one. Nothing works.
I ended up having to upload the excel to google sheets and then downloaded it & THAT worked. To get all my labels to merge & NOT be on separate sheets tho, selecting "multiple records wasn't enough. I got one on each page. I had to change the settings in options to "use existing", I think it was. I wish I jotted notes as I went along!
I was going to suggest switching to Google sheets (I don't actually have Excel so I can't test it there). And that is so weird that 'multiple records' didn't work for you - maybe it's a different version of InDesign or something.
@@GDHT Yep that's what did it. It's been tough learning how to design on a PC. Hadn't touched one since 2003, and even then it was just for email, lol. Anyway - I've figured out I should've done more text formatting first, but at least I got the first lesson done. TY for the vid!
@@lindamaddocks8040 Ok great! Glad it's (sort of) working for you!! :)
I would love for you to make them with Apple Pages as well .. 🙏🏼
I usually stick to the graphic design programs for my channel - I really have no idea how it would work in Apple Pages! Sorry about that.
@@GDHT oopps my error.. I meant to say Apple Numbers (instead of Googlesheets) haha sorry about that .. I don’t use pages for designing either.
Oh that makes more sense!! I would think it would be a very similar process, but I haven't looked into it.