I want to send 120 e-mail with 120 attachments [Solved/Closed]

issahamameh 22 Posts Friday October 19, 2012Registration date June 22, 2013 Last seen - Mar 15, 2013 at 03:19 PM - Latest reply: medo42002 1 Posts Sunday February 19, 2017Registration date February 19, 2017 Last seen
- Feb 19, 2017 at 07:27 AM
Hello,

I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well.
I want to sent for each one salary slip (in a table or row if information or attachment) showing his payment details.

My questions: How can I do it in a quickly way using either VBA code or merge mail or converting to word first then do something??? I think it might be there is a way to do that?

I would be very grateful if anyone can help me or guide me to do that.
Thanks in advance.
Issa
See more 

35 replies

Best answer
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 16, 2013 at 11:51 AM
5
Thank you
So you have 250 files already and you just want to send those files to 250 emails ?

Thank you, rizvisa1 5

Something to say? Add comment

CCM has helped 1818 users this month

rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 24, 2013 at 07:46 PM
You are welcome. I should add thing though. I hope you are not thinking of moving files manually :)
Rinkym 1 Posts Friday October 9, 2015Registration date October 11, 2015 Last seen > rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Oct 11, 2015 at 05:50 AM
Hi Rizvisa1... I also have same problem.. I have salary slips of diefferent employees in an excel sheet one after other populated with help of formulae linked to other sheet. We print these sheets and then give hardcopies to each employee. I want the salary sheets to be emailed to each employee seperately.. pls help.
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen > Rinkym 1 Posts Friday October 9, 2015Registration date October 11, 2015 Last seen - Oct 11, 2015 at 05:43 PM
you should post your question on a separate thread
issahamameh 22 Posts Friday October 19, 2012Registration date June 22, 2013 Last seen - Mar 25, 2013 at 10:42 AM
For sure not manually, especially after all yor efforts! You cann't imagin how much it saved me time!
Best Regards
medo42002 1 Posts Sunday February 19, 2017Registration date February 19, 2017 Last seen - Feb 19, 2017 at 07:27 AM
Dear Gents,

sorry i know it's very old subject but i have the same problem and i don't understand how to apply what you wrote above
i have 100 employees and i convert from excel to PDF in very easy way i don't have problem in this
at the end i have 100 PDF payslip and i send manually 100 e-mail for each employee separately
so there is anyway to send these 100 files with only one click ?