Email Payslip to all employees in mail

[anhazarika]

Hi Everyone,

I am working with an organisation as an IT peron and I am trying to design a payroll system (in access) to be able to send payslips to individual employees ith their specific payslip through email in pdf format.

The employee table has an email field and would like to send the emails to the email address with their payslip (which is a report).Payslip to be sent as pdf.

I need a button to send email in bulk. Attachment is for your reference.

Your help is much need and welcome.

Thanks in advance

akash

 

[Uncle Gizmo]

See my website HERE:-

https://sites.google.com/site/msacc...iple-copies-of-report-with-different-criteria

Might be an approach to consider...

Sent from my SM-G925F using Tapatalk

 

[arnelgp]

you can use the DoCmd.SendObject method to send your mail.
first you need to modify your payslip report to accept single EmployeeID (using filter, Tempvars).
then you have to loop through each record in personal info table put to TempVars the EmployeeID, then send the report usind DoCmd.SendObject.

 

[anhazarika]

Dear arnelgp,

Thnak you for your reply. Pls check the attachment , there is a report named as 'Report1' , there if you put the employee ID , a single payslip gets generated. Can you pls help me add a button and add the function. Will be a great help.

Thanks in advance.

Regards

Akash

 

[anhazarika]

Dear All,

I have added a button in Main Menu (as Send email) and added a query to get employee id and email and also added a docmd.sendobject macro into it. But it is not working. pls help. Report has been customized as employeeid wise. Sending you a sample database.

 

[gemma-the-husky]

out of interest, which country is this for?

 

[arnelgp]

you need to add an EMail field in your Personal Information table.

 

[anhazarika]

This is for India Sir!
I am so far able to do it if I punch individual employee ID and it asks me everytime to put the employee ID. Is there any way to automate it so that I can send it in bulk. Find the revised database attached.

 

[anhazarika]

Dear arnelgp,

Email ID already has been added in the personal information table.

Help pls.

 

[arnelgp]

i'll try sir, if you can wait until tommorow.

 

[anhazarika]

Hi,


Any update on your progress ,Dear arnlgp?



Regards

Akash

 

[arnelgp]

try this one. it need reference to Ms Outlook Object Library on your vbe.

 

[anhazarika]

Thank You very much. It is working like magic.

Pls brief me... Where have you made the changes?

Do I have to change the report too.. and what else.

 

[arnelgp]

there is a new report there, i don't recall the name. added few subs and modules.
comeback if you have problem.

 

[anhazarika]

Dear Arnelgp,

Thank you once again for the nice solution you gave me a earlier. I just want an addtion to this. In email body if I want to send a html formatted text ( coloured) which will be same for all employees ?Only one field will be dyanamic that the first name of the employee in salutation ? Pls help How can I do that? Outlook default signature also come along with the mail.

Like:

Dear Mr. .....

Please find your payslip for the month of Aug'16.

Request you check and revert for issues if any.

Regards

(Signature)

It would be so helpful if you help me in this.

Regards

Akash

 

[anhazarika]

Could anyone pls help me in this?

Regards

Akash