automate form, help needed

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
Fri Jul 04 06:02:21 PDT 2008

On 4 Jul, 13:44, Paulo <Pa...@discussions.microsoft.com> 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.

Paulo
Fri Jul 04 06:20:01 PDT 2008

Could you help me out yousing this function???

"paul.kirwan@rbs.co.uk" wrote:

> On 4 Jul, 13:44, Paulo <Pa...@discussions.microsoft.com> 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.
>

Llama
Fri Jul 04 06:42:57 PDT 2008

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
Fri Jul 04 07:53:02 PDT 2008

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