![]() ![]() The last step in setting up the data file is to export the Excel file to a format InDesign can read. but you can just as easily write ‘images/filename.jpg’ if you want to put the images in their own folder. ![]() Your path in the spreadsheet will then need only be something like filename.jpg, without the need for slashes, folder names and volumes etc. To avoid image path issues, I recommend saving the data file, the images and the InDesign template file all in the same folder. So, we type ‘ in front of the sign and Excel will then behave. To get around it we must escape the character using an apostrophe. ![]() Excel isn’t happy about you typing those kinds of symbols into a cell however and will complain with an error. The trick is to first define which column in our spreadsheet is our image field by adding an symbol before the column name. This gives the added benefit that we can edit the image whenever we like and along as the path remains the same, the most up-to-date file will always appear in InDesign. This way InDesign will read the path and pull in the image directly. We don’t paste the actual image into our spreadsheet, merely include the path to them on our local drive. The only tricky part is including images. Then we go through and write the actual values for each employee on a new row. In the first row of your spreadsheet we use these fields as our column headers. We’ll have First Name, Last Name, Job Title, Email, Portrait. For the sake of this example we will use Microsoft Excel.ĭecide on the fields you will need on your business card. Perhaps a mugshot of each employee or a QR-code for example. That is, all the names and email addresses and job titles etc. Create a spreadsheetįirst you will need a data source. Updates to either design or content are then a breeze. By using the powerful data merge features of InDesign you can set up just one template file and have InDesign read the employee information from an external spreadsheet. You will end up with 130 files though (or 260 if you make a new one for both front and back) and a nightmare of a scenario if the boss suddenly says he wants to change the font/color/logo at the last minute…įear not. Time consuming, but it will get the job done. Your initial plan may be to create a template file and then use that as a master to create a new file for each employee. One side in Japanese and the other in English. Have you had issues with pasting information from other programs and getting unexpected results in Excel? Let me know in the Comments below.The problem: You have been asked to prepare company business cards for all 130 employees working at ACME Multicorp. ![]() Anything over that will be cut off.īe sure to check out my blog for more tips that will get your work done faster in Excel: A cell can only contain a maximum of 32,767 characters. It toggles on and off with every click.Īlert : Be careful how much text you try to paste into a single cell as Excel has a character limit for cells. If you want Excel to take care of the line breaks, use the Word Wrap command on the Ribbon in the Home tab | Alignment group. *Adjust the column width if needed before using the command.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |