Oh No - not another Excel Question....

[Oneeyedvic]

fraid so people.

I am copying and pasting into excel. It is a list of company names and addresses. When I paste them, the name goes into cell A5 (A1-A5 are all mergered) and the address goes into cells B1-B5 - ie addess line 1 B1 - Postcode - B5 .

The next company name goes into a10 and the addresses b6-b10.

My question is, how do I use this data to mailmerge in MS Word? I usually mailmerge when they are accross the page, but I can't seem to work out how to do it.

 

Any help greatly appreciated

[PvtSniper]

it needs to all be in a line either vertically or horizontally, that way it act's as a database, as far as i know there is no other way, however don't use it much myself.