By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 3,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

Sending Email thru Access

P: 77
Dear All,

WE are an NGO working in the areas of Energy, Environment and Climate Change.We look for bussiness opportunities on the internet. If we find some opportunities which suits are requirement, the forward that particular information to the area concerned.We maintain a record for these calls in an Excel file.

No what I want to do is that, the call information is entered in an application made in access, the application should be able to attach an attachment related to the call and there would be an option to enter an email address. when the send button is pressed, the information entered in the form is sent to that email address and the information is also saved in the table.

My Table (TblCallInfo) has the following fields:

CallType (Concept Note, EoI, Proposal) - Text
Call Name - Text
Funding agency - Text
Last Date of submission - Date
Amount of Call- Numeric
Sent to (Will contain the email address) - text
Sent on (Will contain the date when the information was sent) - Date
Remarks:

I would be grateful if anyone could help me on this. I have experience in working with Access, but has never tried working at such advance level.

Looking forward to hear from you.

Thanks
Sajit
Apr 28 '08 #1
Share this Question
Share on Google+
2 Replies


rsmccli
P: 52
Are you looking to send the email through Outlook or by some other means?
Apr 28 '08 #2

100+
P: 553
Dear All,

WE are an NGO working in the areas of Energy, Environment and Climate Change.We look for bussiness opportunities on the internet. If we find some opportunities which suits are requirement, the forward that particular information to the area concerned.We maintain a record for these calls in an Excel file.

No what I want to do is that, the call information is entered in an application made in access, the application should be able to attach an attachment related to the call and there would be an option to enter an email address. when the send button is pressed, the information entered in the form is sent to that email address and the information is also saved in the table.

My Table (TblCallInfo) has the following fields:

CallType (Concept Note, EoI, Proposal) - Text
Call Name - Text
Funding agency - Text
Last Date of submission - Date
Amount of Call- Numeric
Sent to (Will contain the email address) - text
Sent on (Will contain the date when the information was sent) - Date
Remarks:

I would be grateful if anyone could help me on this. I have experience in working with Access, but has never tried working at such advance level.

Looking forward to hear from you.

Thanks
Sajit
Hi

If it is Outlook you want to use to send data, you can use Outlook.Application library to perform this task.

Regards
Qi
Apr 28 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.