Someone else may have a cool way to do it with Calc, but I export the customer list to CSV format. Then I would use sed or awk to insert a field seperator between the first and last names, and then import the edited file back into Calc. The first and last names would then be in seperate cells.
John On 11/21/06, Mike MAXTON <[EMAIL PROTECTED]> wrote:
I am using version 2.0 of open office: my problem is: I have down loaded my customer list from simply accounting to open office calc to a csv file....now I am trying to mail merge and open office calc has my customers first name and last name in the same column and I need it seperated so that the customers first name is in one column and the last anme is in another column...I want this so that every letter I send is personalized to each customer...ie.Dear Jane.... This being said I can manually do it but it will take forever....How can I seperate the first and last name for all my customers? Mike Maxton 807-274-2229 [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
