copying data horizontally
 

I have a large source of data which is laid out vertically, and I wish to put
it into a format which allows Outlook to import and use in a mail merge;

Supplier Supplier 117 - SWEDISH MT
Contact 1 Nat. Account Controller
Contact 2 Managing Director
Contact 3 Sales Controller
Contact 4 Distributive Sector Controller Mr Gavin
Contact 5
Contact 6
Contact 7
Contact 8
Position Nat. Account Controller
Name Mr Terry
Address 1 Sword House
Address 2 Totteridge Road
Town High Wycombe
County Bucks
Phone#1 01494 (Work)
Phone#2 01494 (Fax)
Phone#3 01494 (Direct Line)
Phone#4
Phone#5
Phone#6
Email#1
Email#2

I tried to change the format of the cells, so that they appear across the
page horizontally, but this was very time consuming.

I have made each group contain the same number of verticla cells, but when
trying to Import inot Outlook, I receive a fatal error.

Can anyone help?
This seems strange as when I export data, the format is the same.?!?!

Have you tried the 'Transpose' option of the 'Paste Special' selection?
HTH,
Gary Brown


"Alex" wrote:

I have a large source of data which is laid out vertically, and I wish to put
it into a format which allows Outlook to import and use in a mail merge;

Supplier Supplier 117 - SWEDISH MT
Contact 1 Nat. Account Controller
Contact 2 Managing Director
Contact 3 Sales Controller
Contact 4 Distributive Sector Controller Mr Gavin
Contact 5
Contact 6
Contact 7
Contact 8
Position Nat. Account Controller
Name Mr Terry
Address 1 Sword House
Address 2 Totteridge Road
Town High Wycombe
County Bucks
Phone#1 01494 (Work)
Phone#2 01494 (Fax)
Phone#3 01494 (Direct Line)
Phone#4
Phone#5
Phone#6
Email#1
Email#2

I tried to change the format of the cells, so that they appear across the
page horizontally, but this was very time consuming.

I have made each group contain the same number of verticla cells, but when
trying to Import inot Outlook, I receive a fatal error.

Can anyone help?
This seems strange as when I export data, the format is the same.?!?!