Exporting from Access to Outlook

[handlebars]

Is there a way to send text from fields in Access into Outlook - so that one field goes into the header and the next four all go into the body of the e mail?

Do you need to have a special developers edition to do this?

 

[Nikita6003]

HI

I think what you're asking is "can I send an email using Outlook but but created using Access fields"
If you are, the answer is yes you can. You'd need to set a reference to Outlook in the Module pane of you Access database, and create a procedure that:
1. Opens Outlook
2. Creates a mail
3. Gets fields you need from Access
4. Fills outlook mail created in step 2 with the Access field values
5. Sends the mail
6. Closes Outlook

If this is whast you need & you'd like more info, try querying this forum for Outlook + Access + Send mail. There are loads of code examples floating about
If it isn't, could you please specify your problem?

Cheers
Nikki