Results 1 to 2 of 2

Thread: send to email

  1. #1
    Join Date
    Mar 2006
    Posts
    42

    Unanswered: send to email

    I have to send a query in cvs format to my logistics centre.With the help of the forum i succeeded to do it :
    DoCmd.TransferText acExportDelim, "qryDocExportSpecification", "QryDocs", "QryDocs.csv"

    My question is, can i email this directly ? The same as the sendobject command like :
    DoCmd.SendObject acSendReport, "rptSchedule", acFormatSNP, "tgkn@gmail.com ", , , "Trends", , False

    But is it possible to do it with the Transfertext command ?

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Yes I believe you can. Using the docmd.sendobject command, there is an option for supplying a file (ie. "C:\FolderName\Filename.txt") as an attachment.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •