Sending unique emails to more than one person

[ianco]

Hi all

I have a sample file and I want to create a macro in outlook that automatically sends unique survey links to each respondent, the emails will come from a mailbox we have set up.

In the sample file we have columns pretty much as follows, there's about 400 records:

Link Name Email address Gender Salutation


I want to create a macro that sends multiple unique emails to all the different respondents. So the 'To' field will be populated with data from the email address column, the 'from' field will be populated with our mailbox name. The subject will be the same for all and so will the CC. The email will read foughly as follows:

"Dear 'SALUTATION column' 'NAME column'

Thanks for giving your time to do our survey blah blah blah. Please click on this link to access your unique survey

LINK GOES HERE.

Regards"


Does this make sense and is it possible?

Thanks
Ian

[Fettertiger]

Hi Ian,

you could do it like this. You just need to run the prepare_emails macro, which will call the send_email macro multiple times.
The current version of the macro will only display the mail, but not automatically send it. If you would like to automate this step to, then you just need to remove the leading apostrophe (=comment) from this line: 'Application.SendKeys "%s"

Please Login or Register  to view this content.

I hope this does what you expected.

Theo
___________
Don't forget to mark your thread as closed if your issue is solved. Thank those who helped you by clicking the star on the left of your helpers reply

[ianco]

Hi Fettertiger

Sorry for my late reply, only just getting round to looking at this!

It works great so thanks a lot. I've given you thumbs up but I'm really sorry I have a few more questions:

- Can I make the links turn into hyperlinks? I tried <A Href = "Linkstrg"> but it didn't work..
- I have some other hyperlinks in the body of the text, if you click them it goes: mailto: "[email protected]" Subject = "Please send email survey" (same for all respondents), is this possible?
- Can I set the emails so that they always go from a certain mailbox designated for this (already set up), rather than my personal one
- I have the body of the email and subject in 5 different languages. Is there a way to look up the language that's in another column, and show the correct language in the body of the email.

Sorry for all these... hope you or someone can help!

Thanks
Ian