Hi, i am not sure if i am in the right place to ask this, but there it goes... I have a excel Sheet with 3 colums of data. i would like to make a word macro that creates a page for each line using the data from the 3 colums in each page from the excel sheet.
On 4 Jul, 13:44, Paulo wrote: > Hi, i am not sure if i am in the right place to ask this, but there it goes... > > I have a excel Sheet with 3 colums of data. > i would like to make a word macro that creates a page for each line using > the data from the 3 colums in each page from the excel sheet. No need to create a macro just use mailmerge.
Could you help me out yousing this function??? "paul.kirwan@rbs.co.uk" wrote: > On 4 Jul, 13:44, Paulo wrote: > > Hi, i am not sure if i am in the right place to ask this, but there it goes... > > > > I have a excel Sheet with 3 colums of data. > > i would like to make a word macro that creates a page for each line using > > the data from the 3 colums in each page from the excel sheet. > > No need to create a macro just use mailmerge. >
First make sure you have the Mail Merge Toolbar showing in word. Press the Open Data Source button and navigate to your spreadsheet, select the relevant worksheet. Press the Insert Merge Fields button and select excel column name to place data fields into the document. Press the <<ABC>> button to see the merged data. Press Merge to new document to create static copies of teh mail merge.
Hi, thanks alot for helping I still have some questions about it... i notice that i had to give a name to my data in excel am i able to do that using offset & conuta formulas? i am having trouble formating the data the way I whant. in my letter, i need to mention the city name for exemple "Springfield" i do the autimate date, and i use \S\p\r\i\n\g... the output is "some wird number"pring.... thanks alot for pointing me on the right direction... "Llama" wrote: > First make sure you have the Mail Merge Toolbar showing in word. > > Press the Open Data Source button and navigate to your spreadsheet, > select the relevant worksheet. > > Press the Insert Merge Fields button and select excel column name to > place data fields into the document. > > Press the <<ABC>> button to see the merged data. > > Press Merge to new document to create static copies of teh mail merge. >
