Question about the best way to mass email different stuff to different people

First off, these people want the emails, it’s not spam, I swear! :slight_smile:

Anyway, my company produces reports that we typically print and mail to customers. But we also would like to email links for them to be able to download them from our website.

We have about 30 different clients and each has a unique userid and password to access the page containing the different reports.

As far as emailing them, the only way I can think to do it is to send 30 individual emails saying “Hey Bob, here is your id and password.” “Hey Betty, here is your unique id and password.” etc.

While not too crazy for 30 people it seems there might be a better way.

And in case it matters our site is hosted by simplehost.com and we have a folder for the PDF files, and 2 folders for different excel files. We used the simplehost interface to give users permissions to different folders.

Thanks in advance!

jeff

A long time ago in a galaxy far away, I wrote an MS Access demo application to email reports to interested parties, each one customised to the recipient. If that sounds like it might be any use, here is a link to download it.

Actually, all I need is something as simple as this:


Dear valued customer,

The link for year end reports is www.greatkickassreports.com/yearend

Your userid to access the reports is <insert userid>
Your password to access the reports is <insert password>

Sincerely,

The Greatest Company Ever


And now that I type that out it seems to me that if I have a spreadsheet with users, user emails addresses and user id/passwords that outlook should be able to do that, right? I’m using outlook 2003.

If it is simply a matter of outlook and excel can anyone point me in the right direction to get it working?

Thanks!

Jeff

I would do it in FileMaker.

Loop
Send Mail, no dialog [To: Table::emailaddress; Subject: “Hello” Body: “Greetings and salutations!” & “¶” & “¶” & “You might find it useful to click the following links which lead to info specific to your account.” & “¶” & “¶” & “http://www.domain.com/serverfolder/”& Table::userspecificdocumentcode&".html"]

Go to Record [Next, Exit After Last]

End Loop

If you are only looking at 20-30 people, word (XP) can do a mail merge to outlook - this may well be fastest and easiest for you to manage.

You could also use the concatenate function in Excel. Say your column A has their names, B has user ID, and C has passwords. In column D, you can enter the following:

=“Dear “&A1&”, blah blah your user ID is: “&B1&” and your password is”&C1&" etc. Yours etc., Lily"