Mail Merge + save as pdf + Individual attachment + send email to individual person

[rohansnaik]

Hello ,

Please anyone help me to create VBA macro !!!

I wanted to create single macro which has below facilities

-> It should use mail merge as i wanted mail to send same mail to 3000 person
-> Individual mail to individual person with individual attachment facility
-> I have 5 or 6 details for data for mail merge document of pdf
-> Attachment has should be attached as pdf (Individual attachment)
-> In Subject Body his/her name should be added
-> In Message body his/her name should be added

Please help me for this