Results 1 to 10 of 10

vba to send email and attachments via lotus 8.5

Threaded View

dan2010 vba to send email and... 10-29-2010, 03:04 AM
dan2010 Re: vba to send email and... 10-29-2010, 10:42 AM
Domski Re: vba to send email and... 10-29-2010, 11:01 AM
dan2010 Re: vba to send email and... 10-30-2010, 11:02 AM
dan2010 Re: vba to send email and... 10-31-2010, 07:15 AM
Chippy Re: vba to send email and... 10-31-2010, 10:52 AM
dan2010 Re: vba to send email and... 11-01-2010, 06:46 AM
dan2010 Re: vba to send email and... 11-02-2010, 03:31 AM
Danzil Re: vba to send email and... 02-20-2014, 06:27 AM
Twincam Re: vba to send email and... 01-19-2015, 11:36 AM
  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