Hello comunity, first sorry for my english I will try to do my best.
Need help to solve this, everything is fine with Merge Print until I try to import a list of products on the same page, the Merge plugin make me severals pages instead of putting the list of products where I want, I try with ALT+ENTER on the Excel to put the data on serverals lines on the same cell but it does not work.
Template idea
The actual Excel with two page to create
What he does creating 12 sheets instead of 2
How can I do?
Maybe you could try to modify data in exce file - see attached zip file - contains
• cdr file (with print merge fields)
• excel file
• csv file
printmerge_17.12.2020.zip
Regarding to "ALT+ENTER" try to look here (two separate steps done via macros needed - one in Excel and second in CorelDraw)
you can look here
https://community.coreldraw.com/talk/coreldraw_graphics_suite_x7/f/coreldraw-x7/50441/printmerge---importing-excel-cells-with-multiple-lines-of-text/240085#240085
You are a god, that is a good way! sorry for the late answer this is a side project and lately i haven't been able to dedicate much time to it.
This would definitely do the trick, could I also ask you for help with something else?
Thanks a lot! and Happy Holidays!
You are welcome. Of course you can ask for help and if possible me or someone else will try to help (a lot of users more experienced than me are visiting this forum and share their knowledge).Thank you and Happy Holidays too, hopefully 2021 will be a better year for all of us.
Ok resuming the project, the Corel part would not be drama, the remaining part is Excel, maybe I have to look for an Excel forum and not here in Corel, anyway maybe you or someone can help us here, the idea now It would be to investigate how to make the excel automatically assemble the .csv in the correct way, in Figure 1 the excel base appears where the original form is assembled, the idea is that you can select which ones you want to transform into the ".cvs" and that the list of products remain in columns, that is, you have to transform the list of products from rows to columns. I emphasize again that you have to transform only the selected fields and not the entire worksheet.
if you are interested please send me an excel data for testing via PM