<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: iLogic/VBA to drive the email subject with excel in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-vba-to-drive-the-email-subject-with-excel/m-p/5663987#M56429</link>
    <description>&lt;P&gt;han you for the reply&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;is there a way then to make a single rule for email and with "goExcel rule"?&lt;/P&gt;
&lt;P&gt;Wheni run the rule in iLogic (and also in VBA) i bekomme a error with the Sub&lt;/P&gt;
&lt;P&gt;The sub ist then yellow and i dont know what it meians&lt;/P&gt;</description>
    <pubDate>Thu, 04 Jun 2015 08:59:16 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2015-06-04T08:59:16Z</dc:date>
    <item>
      <title>iLogic/VBA to drive the email subject with excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-vba-to-drive-the-email-subject-with-excel/m-p/5663927#M56421</link>
      <description>&lt;P&gt;Hello there!&lt;/P&gt;
&lt;P&gt;I have this rule to make a attach on a email and and the subject to: "Glas position X"&lt;/P&gt;
&lt;P&gt;X = parameter from excel (You have te excel attached on my posrt)&lt;/P&gt;
&lt;P&gt;Can you tell me whats wrong with zhe gode it doesen work&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Sub Mailversand()&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Dim Nachricht As Object, OutlookApplication As Object&lt;BR /&gt;Set OutlookApplication = CreateObject("Outlook.Application")&lt;BR /&gt;Set Nachricht = OutlookApplication.CreateItem(0)&lt;BR /&gt;With Nachricht&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Dim oPos As String&lt;BR /&gt;Set oPos = GoExcel.CellValue("C:\Users\user\Desktop\Book 1.xlsx", "Sheet1", "B1")&lt;BR /&gt;With oOMail&lt;BR /&gt;.Subject = "Glas position" &amp;amp; oPos&lt;/P&gt;
&lt;P&gt;.&lt;/P&gt;
&lt;P&gt;To = "test@test.de"&lt;BR /&gt;.Body = "Sehr geehrte Damen und Herren"&lt;BR /&gt;.Attachments.Add "C:\Users\user\Desktop\Neuer Ordner\Ablehnung der ZAV an Fieger am 29.01.2015.pdf"&lt;/P&gt;
&lt;P&gt;'.Body = "Mailtext"&lt;BR /&gt;.Display&lt;BR /&gt;'.Mail.Send&lt;BR /&gt;End With&lt;BR /&gt;Set OutlookApplication = Nothing&lt;BR /&gt;Set Nachricht = Nothing&lt;/P&gt;
&lt;P&gt;End Sub&lt;/P&gt;</description>
      <pubDate>Thu, 04 Jun 2015 07:47:18 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-vba-to-drive-the-email-subject-with-excel/m-p/5663927#M56421</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2015-06-04T07:47:18Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic/VBA to drive the email subject with excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-vba-to-drive-the-email-subject-with-excel/m-p/5663971#M56427</link>
      <description>&lt;P&gt;You have to use an Ilogic rule in order to use this Ilogic function "GoExcel.CellValue...".&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Last week, I've sent you a private msg with code and explainations on how to do it.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;This is your original VBA subroutine converted in Ilogic code, change it as you need...&lt;/P&gt;
&lt;PRE&gt;Private Sub Mailversand()
Dim OlApp As Object = CreateObject("Outlook.Application")
Dim Nachricht As Object = OlApp.CreateItem(0)
	With Nachricht
		'.To = "test@test.de"
		'.Subject = "Betreff "
		.attachments.Add(sFile)
		'.attachments.Add(pFile)
'		.attachments.Add("C:\Users\Aleksandar.Jovicic\Desktop\FGL\Steps\Glashalter oben.stp")
'		.attachments.Add("C:\Users\Aleksandar.Jovicic\Desktop\FGL\Steps\Glashalter unten.stp")
'		.attachments.Add("C:\Users\Aleksandar.Jovicic\Desktop\FGL\Zeichnungen\Glashalter oben.pdf")
'		.attachments.Add("C:\Users\Aleksandar.Jovicic\Desktop\FGL\Zeichnungen\Glashalter unten.pdf")
'		.attachments.Add("C:\Users\Aleksandar.Jovicic\Desktop\FGL\Zeichnungen\Glashalter mitte.pdf")
		'.Body = "Mailtext"
		.Display
		'.Mail.Send
	End With
OlApp = Nothing
Nachricht = Nothing
End Sub&lt;/PRE&gt;
&lt;P&gt;Please, stop spamming the forum with the same questions.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Bregs&lt;/P&gt;
&lt;P&gt;Rossano Praderi&lt;/P&gt;</description>
      <pubDate>Thu, 04 Jun 2015 08:50:28 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-vba-to-drive-the-email-subject-with-excel/m-p/5663971#M56427</guid>
      <dc:creator>rossano_praderi</dc:creator>
      <dc:date>2015-06-04T08:50:28Z</dc:date>
    </item>
    <item>
      <title>Re: iLogic/VBA to drive the email subject with excel</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-vba-to-drive-the-email-subject-with-excel/m-p/5663987#M56429</link>
      <description>&lt;P&gt;han you for the reply&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;is there a way then to make a single rule for email and with "goExcel rule"?&lt;/P&gt;
&lt;P&gt;Wheni run the rule in iLogic (and also in VBA) i bekomme a error with the Sub&lt;/P&gt;
&lt;P&gt;The sub ist then yellow and i dont know what it meians&lt;/P&gt;</description>
      <pubDate>Thu, 04 Jun 2015 08:59:16 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/ilogic-vba-to-drive-the-email-subject-with-excel/m-p/5663987#M56429</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2015-06-04T08:59:16Z</dc:date>
    </item>
  </channel>
</rss>

