Help from my computer nerds - TriStateTuners.com :: Home of Tristate Auto Enthusiast

BlackBulletTSi · 07-27-2012, 12:59 PM

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.

jpalamar · 07-27-2012, 03:01 PM

I'd use Microsoft Access.

SoStock92 · 08-02-2012, 09:14 AM

Import to access and make a form

07-27-2012, 12:59 PM	#1
BlackBulletTSi Tri-State Post Whore Join Date: Mar 2005 Location: L~Town Member #224 My Ride: 99 Eclipse GSX iTrader: (3)	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. __________________ Check my music out at To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures. Recently joined record label Strike Division, new tracks to come soon. New DJ community being built, To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures. COMING SOON!!

08-02-2012, 09:14 AM	#3
SoStock92 Tri-State Post Whore Join Date: Apr 2006 Member #1721 My Ride: 92 BMW 525, 95 BMW 525, 87 BMW 325, 95 BMW 530 iTrader: (0)	Import to access and make a form __________________ 1986 BMW 325E -- 1992 BMW 525i -- 1995 BMW 525i -- 1995 BMW 530i

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Computer Nerds?? (Infected Computer)	DPancoast	Off-Topic	20	10-02-2011 03:51 PM
This is for all my photo/art nerds out there...	james_ls	Off-Topic	2	09-18-2010 06:18 PM
Paging all A/V nerds	Chair-Force	Off-Topic	4	07-02-2007 07:13 PM
all you computer nerds please read this - help me pick a laptop	alwaysinboost	Off-Topic	22	06-04-2007 10:22 AM
computer nerds:	92talonTSI	Off-Topic	2	02-07-2006 12:31 AM

07-27-2012, 03:01 PM	#2
jpalamar TST Ruined My Life! Join Date: May 2009 Location: Orefield, PA Member #13773 My Ride: '14 Mustang GT iTrader: (3)	I'd use Microsoft Access.