View Single Post
  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
salventuro salventuro is offline
Junior Member
 
Posts: 9
Default mail merge for each individual excel doc in a folder


Hi Doug,

Thanks for the reply.
I have not resolved the issue as of yet, I am having one heck of a
time with this one.

Any light you can shine on this for me, I would be grateful.

Have a great day! Below is my post at the other Forum, after someone
mentioned I should have mentioned this post. .

Sal.

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,eachof the spreadsheets are identical in layout, all data
is in Sheet1, ineachExcelworkbook.
What I have done is, inserted six text fields in the Word document,
that are mapped toExcel.


macropod, thank you for the information. You mentioned, "LINK field
pointing to any file in the sourcefolder"
Yes, theExcelcells always in the same location ineachof 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- Hide quoted text -


- Show quoted text -

Hi macropod,

Yes, I have posted the same question on wordbanter, Great site by the
way. Point taken, I should have mentioned that.

I had difficulties posting a follow up there, as you saw I posted once
in error and then provided more info, when Doug mentioned I should
have provided more details. (Thanks again Doug).

I tried to post to the newsgroup directly, but, got an error, "posting
not allowed or permited". I have been subscribing to newsgroups for
over five years and never got that error message.

I have been searching many sites, trying to get a solution to this. In
my searches I came accross this site, it looked very good, so I
decided to sign up and post here also.

I also noticed you are every where on the web, providing a huge amout
of assistance to others. When I read your response here, I realised I
looked like a bit of jerk for not mentioning it. When I posted here I
didn't think anyone would be interested in my other post. But now I
can see how that can be viewed as a no-no, to all the experts who
provide information and assistance, for no fee and on their time.

I have a website cbtlessons (I can't post links yet) just add www and
dot com), where I provide video instructions for newer PC users (and
math for my kids and their friends). I pay for it out of my pocket and
it's free to anyone.

Unlike these boards, where there are much more knowledge people than
me, I don't have interaction with anyone who visits my web page.

So I dropped the ball here, I should have had more netiquette, and
taken into account the community. My apology for this.

Thanks for the info on the the other fourm by the way. I am studying
up on it, but am no closer to a solution.

Anyway, I hope everyone has a great day.
Gotta go now, my kids are fighting again, where's my ref whistle!

Sal.


On May 14, 1:10*pm, "Doug Robbins - Word MVP"
wrote:
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

...