Help from my computer nerds
 

Alright so heres what I'm trying to do. I have a spreadsheet in excel with a bunch of product information. Each row is a product. Now I need to generate Spec sheets for each one. Now I figured this is simple using good ol Mail Merge, however this did not work due to a 255 character limit. I tried suggestions on google for changing the connection type to the DDE and when I do I get an error 5535. I'm not trying to sit and create each one of these by hand because I have about 500 rows of products I need this done for. I also was using a plugin to generate each one into its own file for me and using the first field which is the sku to be its file name.

Anyone have any other ideas or solutions? Let me know.

I'd use Microsoft Access.

Import to access and make a form