gloring
04-02-2008, 05:26 AM
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.....
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.....