Results 1 to 2 of 2
  1. #1
    mlozano is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2012
    Location
    Madrid, Spain
    Posts
    11

    SendObject Parameters

    Hi

    I have a quotations form with a button to preview a report showing only the actual record on the form,

    Currently I have my sales team printing the report to PDF format, saving the file then sending it manually.

    I want to use SendObject to automatically create an outgoing message ready for them to edit. However I need to know if :

    - Is it possible for the filename to be "Quotation 201202352.pdf" instead of "quotation.pdf" of course the quotation number is a field in the report

    - Is it possible for the email address to ba based in the actual email of the recipie3nt, stored in a field of the report?
    Same for the subnject, wouold need it to be "Quotation 201202352! instead of a fixed text subject.

    I suspect this should be possible but I am not sure.



    Any help would be greatly appreciated

    Many thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,963
    SendObject method does not have versatility to allow custom naming of the output. You can assign To, Subject, MessageText as you prefer.

    For alternative, review:
    https://www.accessforums.net/program...ook-21903.html
    https://www.accessforums.net/import-...ges-25042.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Quick Q about SendObject
    By Hello World in forum Forms
    Replies: 1
    Last Post: 10-03-2011, 10:01 AM
  2. sendobject acsendreport
    By mikeb in forum Programming
    Replies: 2
    Last Post: 09-17-2011, 03:02 AM
  3. SendObject
    By weshader in forum Access
    Replies: 1
    Last Post: 11-09-2009, 04:19 PM
  4. SendObject Message
    By williammarino in forum Forms
    Replies: 4
    Last Post: 10-06-2009, 01:54 AM
  5. DoCmd.SendObject Help
    By bgreer5050 in forum Programming
    Replies: 0
    Last Post: 01-12-2007, 06:27 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums