Mail merge where person and file name are the same.

[gloring]

Hi,

I have a excel sheet with the following data..

Name email
neil neil@abc.com
sam sam@abc.com
tom tom@abc.com
peter peter@abc.com

i need to send each person a mail with mail merge.

but the problem is i have a file in c:temp\"file".xls

the file name and the person name is same.( so seperate file for each person)

example: c:temp\sam
c:temp\tom .....etc

i need to send the mail for each person with attaching each person file.

please tell me a way to do this.

any way of doing this is ok for me

thanks in advance.....

[mdmackillop]

Hi Gloring
Welcome to VBAX.
Can you explain further what you mean by "with mail merge"?
BTW, please use meaningful titles for your questions
Regards
MD

[gloring]

Hi Gloring
Welcome to VBAX.
Can you explain further what you mean by "with mail merge"?
BTW, please use meaningful titles for your questions
Regards
MD

i mean when we use mail merge in word.
I need to attach a seperate file for each person.
File that person should get.

All the files are located in c:temp/"file name.xls"

the file name is always the full name in the list that we give to the main document.

Can you create a macro where we can actually run it just before we send it and attach all the files seperately for each person.

http: // word.mvps.org/FAQs/MailMerge/MergeWithAttachments. htm

please take a look the this site and you can understand what i am actually lookin for

Sorry for the wrong title........