First off, these people want the emails, it’s not spam, I swear!
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.
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.
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?
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”]
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"