• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mass email with unique attachments to every recipient

H

HanSam

Member
I am trying to make the sending of the generated files from attached file automated. I've been trying to work on it for half a day now, but I can't seem to make it work. Can anyone help? Thanks.
 

Attachments

  • Help.xlsm
    53.9 KB · Views: 18
Hah! I just had to do something very similar for a client, so the title caught my attention. I've taken a cursory look at your worksheets, and what I think I see is a list of recipient email addresses in LFO, with a country code in col A; the country code is associated in RDBLogSheet to a filename, which I take it defines the attachment you want to go on that email. Am I right so far?

But here's the thing: There's no chance (or very little, anyway) that you're going to get anyone here to look at your whole program and try to figure out what's wrong with it. You gotta give us some hints: "I run it, and in such-and-such a statement it stops and gives me an error message saying thus-and-so". Or "it seems to work, but the email has this attachment rather than that one". Some kind of detail, anyway.
 
BobBridges said:
Hah! I just had to do something very similar for a client, so the title caught my attention. I've taken a cursory look at your worksheets, and what I think I see is a list of recipient email addresses in LFO, with a country code in col A; the country code is associated in RDBLogSheet to a filename, which I take it defines the attachment you want to go on that email. Am I right so far?
Click to expand...

Yes that is exactly what it does.

BobBridges said:
But here's the thing: There's no chance (or very little, anyway) that you're going to get anyone here to look at your whole program and try to figure out what's wrong with it. You gotta give us some hints: "I run it, and in such-and-such a statement it stops and gives me an error message saying thus-and-so". Or "it seems to work, but the email has this attachment rather than that one". Some kind of detail, anyway.
Click to expand...

I actually got it to work on my own. I had to adjust some of the email part since I figure there will still be some manual work in between the file generation and the emailing of those files. But thanks for looking into my question.
 
You must log in or register to reply here.
Back
Top