Results 1 to 10 of 10

vba to send email and attachments via lotus 8.5

Threaded View

  1. #6
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: vba to send email and attachments via lotus 8.5

    To answer your questions:

    1. No change should be necessary because Session.UserName should be your user name. Verify this by stepping through the code in the debugger.

    2 and 3. In your posted code the Attachment variable is a string containing the full path and filename of an attachment, so this is the part you need to change. You'll also need to specify a unique rich text item name for each attached file. For example:
            Set AttachME = MailDoc.CREATERICHTEXTITEM("Attachment1")
            Set EmbedObj = AttachME.EMBEDOBJECT(1454, "", "C:\file.jpg", "Attachment")
    
            Set AttachME = MailDoc.CREATERICHTEXTITEM("Attachment2")
            Set EmbedObj = AttachME.EMBEDOBJECT(1454, "", "C:\file.pdf", "Attachment")
    Last edited by Chippy; 10-31-2010 at 10:54 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1