Merge fields appear with chevrons (« ») around them. For example, a single record would include a person’s first and last names, address, phone number, and date of birth.Ī merge field is where you want to insert the information from a data source into a main document. For example, the field «LastName» would only contain people’s last names.Ī record is an entire set of data fields that relate to a single thing or person. Excel spreadsheets, Access databases, or Word document tables are good examples of data sources.Ī data category that stores a specific piece of information. For example, it has records containing the names and addresses of the people a mail merge letter is sent to. The starting document contains the field names for the variable information, like the names and addresses that will be inserted.Ī file that contains the information to be inserted into the main document during a mail merge. Ideally the front and the back should have visual queues (maybe different colors) so the employee don’t punch the “company code” first.ĭesign cues : we are an industrial company, we make heavy equipment for trucks, mainly snow plowers.(Main Document) A document that contains the information that is the same for each merged document.
#Mail merge format code
The back is the same for everyone : square QR code + the sentence “Code Compagnie” (French because we are in Quebec) The front is personalized for each employee : square QR code + name + maybe a logo or something (the company code is the code “INOUT”, it’s hardcoded in our punch system, it needs it to validate a punch) In our punch system, the employee must punch with his personal card, then he must enter a “company code” wich is the same for everyone. But they will be laminated, so the plastic will need about 2 mm of clearance all around, so the paper should be around 8.3x5.2 cm The punch card should be 8.5 x 5.4 cm (standard credit card size). We will then laminate the cards, so for the back, it can be just a separate file to print and cut, we can put the 2 pieces of paper cut back to back in the laminator to get the final card.Īttached is an exemple of excel file that could be used as data sourceĢ - Make a SIMPLE design for punch cards for employees of our company We will cut the cards manually, and would appreciate to see where to cut I would like as many as possible card to print in one page
Then with some kind of mail merge, the information should feed a file ready to print (we can use for exemple publisher, or word) png format, and provide the link into the excel file.Įmployee’s code are numbers, 4 to 6 figure long. Ideally, the file should produce the QR Code (black and white, with 30% redundancy), but if it’s not possible, I can produce it myself manually in.
Ideally, the data file would be an excel file with name, employee’s code. And finally, I just need a digital version of the card, there is no requirement for a physical copy.ġ - Make a system so we can mass print the cards when feeded by a standard data file I need a placeholder in the design that is text only - no images or logos. The turnaround time for the project is 1-3 days. I have a logo I can provide for the simple design of the card. I need a mail merge to make punch cards with QR code. I am looking for someone to help me with a data processing project.
0 kommentar(er)
