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

Posts
22
Registration date
Friday October 19, 2012
Status
Member
Last seen
June 22, 2013
- - Latest reply: medo42002
Posts
1
Registration date
Sunday February 19, 2017
Status
Member
Last seen
February 19, 2017
- 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 

1 reply

Best answer
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
755
6
Thank you
So you have 250 files already and you just want to send those files to 250 emails ?

Say "Thank you" 6

A few words of thanks would be greatly appreciated. Add comment

CCM 5755 users have said thank you to us this month

rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
755 -
You are welcome. I should add thing though. I hope you are not thinking of moving files manually :)
Rinkym
Posts
1
Registration date
Friday October 9, 2015
Status
Member
Last seen
October 11, 2015
> rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-
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
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
755 > Rinkym
Posts
1
Registration date
Friday October 9, 2015
Status
Member
Last seen
October 11, 2015
-
you should post your question on a separate thread
issahamameh
Posts
22
Registration date
Friday October 19, 2012
Status
Member
Last seen
June 22, 2013
-
For sure not manually, especially after all yor efforts! You cann't imagin how much it saved me time!
Best Regards
medo42002
Posts
1
Registration date
Sunday February 19, 2017
Status
Member
Last seen
February 19, 2017
-
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 ?