View Single Post
  #9   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default mail merge for each individual excel doc in a folder

So is your problem sorted or not.

As the other forum to which you posted the question requires one to register
to view the content, I will not visit it.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"salventuro" wrote in message
...

Hi everyone,

It appears I am guilty of cross posting without notifying the Forum. My
apology for this.

I posted the same question at
"http://www.vbaexpress.com/forum/showthread.php?t=26691".

I did not mean to be rude.

salventuro;412617 Wrote:
Hi Doug, Hi macropod.

Thanks for your replies. Sorry for not being a little bit clearer.

Doug, yes, each of the spreadsheets are identical in layout, all data
is in Sheet1, in each Excel workbook.
What I have done is, inserted six text fields in the Word document,
that are mapped to Excel.


macropod, thank you for the information. You mentioned, "LINK field
pointing to any file in the source folder"
Yes, the Excel cells always in the same location in each of the
workbooks. Could you please point me in the right direction for this?

Again, my sincerest thanks for your time and assistance, it is very
much appreciated





--
salventuro