Can I send email from VBA to MS Access?

Answer by  gigo (1706)

The following scenario would be possible: two pcs, both with the complete Office package. Now you can use out of Access VBA the outlook object. With this object you can send access data to outlook on the other pc. On this pc2 you can use again Access VBA to read.

Answer by  Jalan (32)

VBA is a programming language, based on Visual Basic, and it can be used to send or receive emails, assuming an email server is available. To receive an email in MS Access, a VBA module would need to be invoked to connect to the email server, perhaps during the FORM_LOAD event when a form is shown.

Answer by  Aarthi (16)

Yes we can send mail from VBA to MS Access. For this we need to write a VB code, so that the mail can automatically send from VBA if it meets the requirements.

Answer by  Lakshmi65 (715)

ye by using the Febooti command we can send the email from VBA to MS access. While writing the program in modeule we have write the coding to access email.

Answer by  gigo (1706)

Generally you can use the outlook object to send a mail with any VBA Editor (for example access). The Data in this mail arrives over outlook on the second station where we want to import it. Here you can use another script that is started with an outlook rule. You can use a special subject to react on the mail.

Answer by  japratt (1687)

Yes, you should be able to send email from these to different programs. Microsoft Access will usually let you input different types of files that may not actually fit the format.