E
ezeetyger
we have a wonderful programme at work that does not let us mailmerge
which is a real pain in the butt. The only way we can even remotely
have a chance is by exporting the data into Excel. However, this also
causes a proble as all the addresses go into one column. So instead
of having;
Column1 Column2 Column3 Column4 Column5 Column6
Column7
Mr Jack Jones 1 Lincoln Court Leeds Yorkshire
LS25 1WW
I get.......
Column1 Column2 Column3 Column4
Column5
Mr Jack Jones 1 Lincoln Court Leeds Yorkshire LS25
1WW
How can I get Column4 split correctly? I export as a text file (csv I
think) and then use comma as the delimiter, but it doe snot split the
data correctly. I think its because that when you input the address
in the original programme the address box relies on the ENTER key to
get the next line
Thanks
which is a real pain in the butt. The only way we can even remotely
have a chance is by exporting the data into Excel. However, this also
causes a proble as all the addresses go into one column. So instead
of having;
Column1 Column2 Column3 Column4 Column5 Column6
Column7
Mr Jack Jones 1 Lincoln Court Leeds Yorkshire
LS25 1WW
I get.......
Column1 Column2 Column3 Column4
Column5
Mr Jack Jones 1 Lincoln Court Leeds Yorkshire LS25
1WW
How can I get Column4 split correctly? I export as a text file (csv I
think) and then use comma as the delimiter, but it doe snot split the
data correctly. I think its because that when you input the address
in the original programme the address box relies on the ENTER key to
get the next line
Thanks