Sending email from other account

See also questions close to this topic

• .Body & .HTMLBody Indent and Default Signature Issue

  I've set up a macro to send an e-mail through Outlook.

  .Body is read from a cell inside the file with indents. Since the value will change depending on the usage, I need to reference that cell for the body.

  However, there rises 2 issues using .HTMLbody I lose indents which are constructed with CHAR(10) but I keep the default HTML signature.

  When using just .BODY indents are displayed are correctly however the default signature is not constructed as HTML and I lose the images.

  How should I go about fixing this issue?

  My code:

  sig = .HTMLBody
  body = xlSht.Range("B4").Value
      .To = xlSht.Range("B2").Value
      .CC = ""
      .Subject = xlSht.Range("B1").Value
      .body = body & sig
      .Display
  

  I'd really appreciate your assistance.

  Thanks.
• VBA: Creating a class property that is an array of dictionaries

  In Microsoft Excel VBA I need to create a class that has two properties, "Name" and "Holdings". "Name" is just a string so the code for that is easy. But I need "Holdings" to be a variable length array containing dictionary objects. So this is what I wrote:

  Private mName As String
  Private mHoldings() As Scripting.Dictionary
  
  Public Property Let Name(vName As String)
        mName = vName
  End Property
   
  Public Property Get Name() As String
        Name = mName
  End Property
   
  Public Property Set Holdings(vHoldings() As Scripting.Dictionary)
        Set mHoldings = vHoldings
  End Property
   
  Public Property Get Holdings() As Scripting.Dictionary
        Set Holdings = mHoldings
  End Property
  

  When I try to compile it gives me this error: "Definitions of property procedures for the same property are inconsistent, or property procedure has an optional parameter, a ParamArray, or an invalide Set final parameter.

  What I doing wrong?
• Yahoo Finance no longer returns VBA cookie request for .getResponseHeader("Set-Cookie")

  The following Excel VBA code segment has worked for years, but stopped working around 28 Apr 2022. I receive the responseText, but the .getResponseHeader("Set-Cookie") returns null.

  Set httpReq = New WinHttp.WinHttpRequest
  
  DownloadURL = "https://finance.yahoo.com/lookup?s=" & stockSymbol
  With httpReq
      .Open "GET", DownloadURL, False
      .setRequestHeader "Content-Type", "application/x-www-form-urlencoded; charset=UTF-8"
      .Send
      .waitForResponse
      response = .responseText
      cookie = Split(.getResponseHeader("Set-Cookie"), ";")(0)
  End With
  
• how can anyone send email to me on my website in js

  I am creating a project as I have created a contact page. I want any user to send me a email by putting his email and message in input box of contact page. I have also tried smtpjs but with that I can send the email from my side and registered email on smtpjs but unknown user who put his email without putting his password can't send email to me

  for eg-

  my email - myemail@gmail.com

  my password - mypassword

  unknown user email - unknown@gmail.com

  how can unknown user send me email by putting only his email on my website contact page

  any js library and js code can use for this problem please tell me
• Please help to find email out of this cipher

  Please help me to extract the email from this cipher, i am not been able to identify what type of hash or cipher is this.email is encoded in this hash please help me find the email.

  1AAXs0RyFR3OM9nZA3XVkD07AVOZmYUMsRvyeq2BoY42sNbkSUySHCdFdwwQx6LWghNDqiPyBzNE7KDXkerX4vt0klZ2
  
• SMTP client send QUIT command before waitting for OKAY from server

  There's a smtp issue here and it's weired. Our business partner failed to send email to us lately. After checking, we found our partner's smtp server sent QUIT command immediately after email content, before waiting for 250 OKAY from us. It causes the connection shutdown and our smtp server thinks the transaction is incomplete and drops the email.

  It looks like against the RFC standard of SMTP protocol. Who has experienced this before? Thanks in advance!

  enter image description here
• Outlook VSTO - Get all items in a group calendar

  I am looking for a way to access a group calendar in Outlook VSTO Add-In. I am only able to search the default calendar in outlook. I have shared an image from outlook below that shows several group calendars. How can I access those group calendars from VSTO code?

  
• How to set outlook addins pinned right away?

  I set the SupportsPinning to true for outlook addins by modifying the manifest file as shown below. This allows the pin icon available. By default, the Pin is not selected. So is there a way to have the addins PINNED right away?

  <!-- Task pane button -->
  <Control xsi:type="Button" id="msgReadOpenPaneButton">
    ......
    <Action xsi:type="ShowTaskpane">
      <SourceLocation resid="readTaskPaneUrl" />
      <SupportsPinning>true</SupportsPinning>
    </Action>
  </Control>
  
• Send SVG image content to email as HTML using boto3

  I want to send SVG content (without saved file) as HTML to Outlook email address. This SVG content works fine in browser showing a circle image, however sending it via boto3.client to Outlook email results in empty mail. Why? Any suggestions appreciated.

  import io
  import json
  import boto3
  from botocore.exceptions import ClientError
  
  SENDER = "Name1 LastName1 <Name1.LastName1@mail.com>"
  RECIPIENT = "Name2 LastName2 <Name2.LastName2@mail.com>"
  AWS_REGION = "us-east-1"
  SUBJECT = "something"
  
  svg = """
  <svg width="100" height="100">
  <circle cx="50" cy="50" r="40" stroke="green" stroke-width="4" fill="yellow" />
  </svg> 
  """
  
  BODY_HTML = f"""<html>
  <body>
  {svg}
  </body>
  </html>
              """ 
  
  CHARSET = "UTF-8"
  
  client = boto3.client('ses',region_name=AWS_REGION)
  
  try:
      response = client.send_email(
          Destination={
              'ToAddresses': [
                  RECIPIENT
              ],
          },
          Message={
              'Body': {
                  'Html': {
                      'Charset': CHARSET,
                      'Data': BODY_HTML
                  }
              },
              'Subject': {
                  'Charset': CHARSET,
                  'Data': SUBJECT
              },
          },
          Source=SENDER
      )   
  except ClientError as e:
      print(e.response['Error']['Message'])
  else:
      print("Email sent! Message ID:"),
      print(response['MessageId'])