Results 1 to 4 of 4

Thread: Sending Email from MSWord (RESOLVED)

  1. #1

    Thread Starter
    Frenzied Member trisuglow's Avatar
    Join Date
    Jan 2002
    Location
    Horsham, Sussex, UK
    Posts
    1,536

    Resolved Sending Email from MSWord (RESOLVED)

    I have an application that automates MSWord (creates a table, fills in some values).

    I want my application to finish off by sending the word document as an Email. I don't want to send it as an attachment - I want to send it as plain text or, ideally, HTML. I know this can be done because I can do it from Word using the File\Send To Mail Recipient command. Trouble is, I can't work out how to do it from VB. Even recording a Word macro doesn't help me much.
    Last edited by trisuglow; Nov 30th, 2004 at 04:23 AM.
    This world is not my home. I'm just passing through.

  2. #2

    Thread Starter
    Frenzied Member trisuglow's Avatar
    Join Date
    Jan 2002
    Location
    Horsham, Sussex, UK
    Posts
    1,536
    I don't think I can use the RoutingSlip method for two reasons:

    1. The address I want to send to is not in the Global address list.
    2. I do not want to send the document as an attachment.
    This world is not my home. I'm just passing through.

  3. #3
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709
    This will place the document into "email mode" allowing the user
    to enter a valid email address and "Send a Copy" embedded as
    the body of an email message.

    VB Code:
    1. Application.CommandBars("Standard").Controls("M&ail Recipient").Execute
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  4. #4

    Thread Starter
    Frenzied Member trisuglow's Avatar
    Join Date
    Jan 2002
    Location
    Horsham, Sussex, UK
    Posts
    1,536
    Thanks RobDog888. I've gone with your suggestion and used SendKeys to fill in the address and then tab to the subject and fill that in as well.

    Good solution.
    This world is not my home. I'm just passing through.

Posting Permissions

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



Click Here to Expand Forum to Full Width