Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Linking Word Mailing with Excel

Feb 20, 2008 2:57AM PST

Description: i have a word file with a mailing list and fields inserted into the document. I can move up and down the mailing, what causes the fields to change accordingly.

I also have a excel file with a value in each line that corresponds to each person in the mailing.

What i want is to while in word and cycling the mailing, for each name that show?s up, the value from the corresponding excel line is showed.

I have used linked fields to show the contents of one cell in the word document, but it?s always the same.

Maybe it?s possible by placing a field in the mailing with the corresponding excel line number, so that it updates the cell from wich it is getting the values.

Any Ideas?

Discussion is locked

- Collapse -
May I suggest ...
Feb 20, 2008 4:34AM PST

you merge the data in your (untold) data source and the spreadsheet BEFORE you do a mailmerge with Word, and NOT afterwards.

Kees

- Collapse -
to: May I suggest ...
Feb 20, 2008 4:44AM PST

do you mean i can use the mailing in the excel file?

i didn?t think that was even possible...

can you give me some more pointers? tks

- Collapse -
You can use ...
Feb 20, 2008 5:57AM PST