two attachments in one email

[Guest]

Can somebody tell me if it's possible to send two rapports from the same
database in one e-mail as attachment? I am using microsoft access 97.

Thank you in advance!!!!

 

[Rick Brandt]

Can somebody tell me if it's possible to send two rapports from the same
database in one e-mail as attachment? I am using microsoft access 97.

Not with SendObject no. You can automate MAPI, CDO, Outlook, etc., and then
have as many attachments as you want.

 

[Arvin Meyer]

Can somebody tell me if it's possible to send two rapports from the same
database in one e-mail as attachment? I am using microsoft access 97.

You can use Outlook or any client that you can talk to with automation. For
some sample code, see:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[hhp]

save both data file as 1.db & 2.db, use outlook email, click attachment
option twice for two files, and so on. Make sure receiver has enough space
to get your files.