automate form, help needed

[Paulo]

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.

 

[paul.kirwan]

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.

 

[Paulo]

Could you help me out yousing this function???

No need to create a macro just use mailmerge.

 

[Llama]

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.

 

[Paulo]

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...