Populating emails with database info

[daviddixon]

I am quite new to all this and not sure whether the following can be done, but if it can I would appreciate finding out how to work it.

I want to store an access database at an online sharepoint (with web address)

I want to be able to use that database (and specific columns/fields within it) to populate the 'To' and 'Cc' fields of my outlook emails I will be sending.

So basically the databases will be serving as remotely stored distribution lists.



I'm almost sure this can be done, but technically I've no idea how. The people on this forum seem pretty smart, and so I'm hoping someone has the answer...

Any ideas?

[TheShabz]

https://www.accessforums.net/search.php?searchid=57248

Please use the search first. This has been discussed ad nauseum. =]

[daviddixon]

https://www.accessforums.net/search.php?searchid=57248

Please use the search first. This has been discussed ad nauseum. =]

Sorry, I clicked your link but it returned this message:

Sorry - no matches. Please try some different terms.

I did try searching, but nothing seemed to cover exactly what I was looking for...

[ajetrumpet]

https://www.accessforums.net/search.php?searchid=57248

Please use the search first. This has been discussed ad nauseum. =]

Shabz,

I might be mistaken, but I think there is a time delay on searches that are created in the DB whereby they are deleted out after a certain timeframe.

[RuralGuy]

I like this link for email answers: http://www.granite.ab.ca/access/email.htm

[daviddixon]

Thanks for the link but I don't think it has the answer I was looking for... Surely this is something that has been done before?

[ajetrumpet]

Thanks for the link but I don't think it has the answer I was looking for... Surely this is something that has been done before?

learn how to search google david. their indexing capabilities are the best that's out there. I have never used sharepoint so I don't know if my advice would be helpful. I know how to integrate office programs with code but sharepoint might call for other things I don't know how to do.

to get started though with integration, the best thing to do in order to learn how is to open up the program that will actually be performing the request (in this case OUTLOOK) and use the intellisense dropdown to figure out what the exact script is before creating the process from another office program.

[pkstormy]

I once created a 'Data Form' in outlook which updated nicely with the MSAccess db. I don't think a lot of developers use sharepoint. I personally use SQL Server for all my backends and just write/call vb/php scripts to update data in the tables as needed.

[daviddixon]

learn how to search google david. their indexing capabilities are the best that's out there. I have never used sharepoint so I don't know if my advice would be helpful. I know how to integrate office programs with code but sharepoint might call for other things I don't know how to do.

to get started though with integration, the best thing to do in order to learn how is to open up the program that will actually be performing the request (in this case OUTLOOK) and use the intellisense dropdown to figure out what the exact script is before creating the process from another office program.

This forum is beginning to look less impressive when the best people can do is point me in the direction of google.

Maybe I should have made it abundantly clear that I've trawled google already and found nothing that fits my requirements (as I did with this forums own search function).

I'm still keen to hear a solution...

[pkstormy]

Daviddixon,

As I mentioned, I don't think there's a lot of developers using sharepoint yet.