Send emails from a sheet attaching diferent .pdf files

[Darker0ne]

Hello everyone,

I've been searching all around for a way to do the following:

Send emails from a Excel sheet, where i have the following fields, "Name", name of the client(to enter on a specific place on the email body), "Email" of the client(where i want the email to be sent to), " Observations " ( some text ), and "Subject" ( email itself subject ).
So four fields to place on the same standard letter, for example:


Send to: "Email_field"

Subject: "Subject_field"


Dear "Name_field",


Blablabla, " Observations_field " blablabla.


Best regards.


Now the tricky part, i need for each email, a unique .PDF file. So i could add a field who ID both emails and .pdf's.
For example, five fields:
In Excell i would have this.

ID Email Subject Name Obrservations
1 [email protected] Need Help Mr.Need Help I really need help


And, with that ID = 1, it would go to specific Paste, and attach a file called 1.pdf.
After that, just place the send emails on another specific Paste.

Is this even possible, if so ? how ? i can't find any solution even close to this, being a program or a macro...
My apologizes for my English, it ain't good...
If someone needs clarification in order to be able to help me, please ask...

[Darker0ne]

No one able to help me out?
Just a guideline would be great :|

[Darker0ne]

Someone ?
Please ? :|

[john55]

Hi,
not sure if it's what you are after but try this code (I am surprised that you did not find it here!)

Please Login or Register  to view this content.

and your Sheet needs to have:
col A-Name
col B-Email address
col C-path/file name such as C:\users\Sam\desktop\Sample.xls
col D-path/file name
col E-subject
col F-Remarks
col G-status such as "Sent"

[john55]

ref yr question,
possible

Please Login or Register  to view this content.

[john55]

see the test file, change the path/file name, the email address...

[john55]

i think you got me wrong...

man, is possible to get you wrong, I provided a piece of code, then a test file....you say just "doesn't work" but you do not say what error occurs.
if the file attached has different columns position you can rearrange them and regarding the .display method you can use .Sen

[Darker0ne]

Hello,

I'm sorry but that ain't true, i sended you a detailed information of what i wanted, i didn't said only " it doesn't work ".
Im thankfull for your help, but it just isn't what i wanted... I don't even know if what i wanna do is even possible...

[john55]

I am sorry too, please provide more details here of what you are looking for and I am sure someone else can help you!

[Chandrahaas]

Hi Could anyone hlp me in correcting the code for attached Excel 2010.
I am nota be to correct it. Basicaly the code is for to send the emails with PDF attachemnts against the list of email addresses mentioned in the excel

[arlu1201]

Chandrahaas,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.