Hello, I'm a musician and as in the 1st picture, Excel is the platform that we use to share our playlists with other musicians. And using this data on Excel, I prepare myself cards on Word like in the 2nd picture. And I make them a pdf and view them on stage via iphone or ipad...



So my first question is; instead of me reading the data from Excel and writing all of them into Word one by one, is it possible to retrieve the data from Excel file and put them into the related places in Word automatically?

And here comes my second question; is there an easier way of preparing cards like this other than using Word? For example if there were boxes for every type of information on a single card, then I wouldn't have to worry about sizing or coloring them each time...


Thank you!
Umut

Hi Umut,

Everything except the formatting of your 'Trafik' column's data can be handled quite easily via a mailmerge. And, even with your 'Trafik' column, if you were prepared to split that into two columns (one for each line), even that data could be formatted via the mailmerge. FWIW, instead of using textboxes in Word, I'd suggest using a table, with cells sized to position the various lines where you want them.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]