Jason Congerton wrote on 30 March 2009 at 11:24am > My wife has brought home an excel spread sheet to create a mail merge, > however the person who set up the data up has put the address in one column > (albeit separated by commas i.e. 23 The Road, Somewhere, er2 3ry. I stupidly > said now worries I can right a bit code which will import them to separate > columns > for you!
I know this isn't what you asked and someone else will probably solve your problem programmatically, but here is a simple way to do what you need: http://office.microsoft.com/en-us/excel/HA011498511033.aspx Then do your mail merge as you would normally. If you are ever likely to have to do it again with the same sheet, simply write a macro, or even record one to repeat the task. Regards Mark Henderson Web Developer P: 03 203 9999 F: 03 203 9900 E: [email protected] W: http://www.cwc.co.nz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
