VBA Signature on Email with HTMLBody

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP

VBA Signature on Email with HTMLBody



So i got the following from How to add default signature in Outlook. However, i keep getting an error "Application-defined or object-defined error" where the signature variable is set. Plz HALP.


Dim OApp As Object, OMail As Object, signature As String
Set OApp = CreateObject("Outlook.Application")
Set OMail = OApp.CreateItem(0)
With OMail
.Display
End With
signature = OMail.body
With OMail
'.To = "someone@somedomain.com"
'.Subject = "Type your email subject here"
'.Attachments.Add
.body = "Add body text here" & vbNewLine & signature
'.Send
End With
Set OMail = Nothing
Set OApp = Nothing



I know i could get the signature from the C:Users...Signatures folder. However at work, we all use virtual desktops and the permissions there are a tad janky.





Are you using .Body or .HTMLBody? How complex is your signature - is there an embedded picture, for example?
– BigBen
1 hour ago


.Body


.HTMLBody





The signature is just simple text, no pictures or anything crazy. I could go with either, but i'd prefer to use .HTMLBody. But i literally copied and pasted the above code, and still get the error. Im just trying to find a starting point and cant even get there.
– TideRunner
1 hour ago


.HTMLBody





And if you step through with F8 you can see the signature once the email is displayed?
– BigBen
1 hour ago





i cant even step in it throws the error before i can even try. if i just avoid using the signature variable, it is there.
– TideRunner
1 hour ago




1 Answer
1



Your signature has to be declared as a variant.


Dim OApp As Object
Dim OMail As Object
Dim Signature As Variant

Set OApp = CreateObject("Outlook.Application")
Set OMail = OutApp.CreateItem(0)

On Error Resume Next
With OMail
'Capture signature block.
.Display
Signature = .HTMLBody
'.To = Recipients
'.CC = CarbonCopy
.Subject = "Subject"
.HTMLBody = "<p>Add Body Here.</p>" & Signature
.Display
End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing





so with this, i don't get an error, but i only get a signature. like it's overwriting the body.
– TideRunner
31 mins ago





Try adding HTML tags. The code above has been edited.
– pondersome
24 mins ago





that worked! thx
– TideRunner
16 mins ago






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Comments

Post a Comment

Popular posts from this blog

Executable numpy error

Image
Clash Royale CLAN TAG #URR8PPP Executable numpy error I'm trying to create an executable file for my code. I've already tried with cx_Freeze and with pyinstaller. Both gives me the same error, which is: "Missing required dependencies 0.format(missing_dependencies))" PS C:UsersGustavoDesktopbuildexe.win32-3.6> python AgendaOficial.py C:UsersGustavoAppDataLocalProgramsPythonPython36-32python.exe: can't open file 'AgendaOficial.py': [Errno 2] No such file or directory PS C:UsersGustavoDesktopbuildexe.win32-3.6> .AgendaOficial.exe Traceback (most recent call last): File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_Freezeinitscripts__startup__.py", line 14, in run module.run() File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_FreezeinitscriptsConsole.py", line 26, in run exec(code, m. dict ) File "AgendaOficial.py", line 8, in File "C:UsersGustavoAppDataLocal
Read more

PySpark count values by condition

Image
Clash Royale CLAN TAG #URR8PPP PySpark count values by condition I have a DataFrame, a snippet here: [['u1', 1], ['u2', 0]] basically one string ('f') and either a 1 or a 0 for second element ('is_fav'). What I need to do is grouping on the first field and counting the occurrences of 1s and 0s. I was hoping to do something like num_fav = count((col("is_fav") == 1)).alias("num_fav") num_nonfav = count((col("is_fav") == 0)).alias("num_nonfav") df.groupBy("f").agg(num_fav, num_nonfav) It does not work properly, I get in both cases the same result which amounts to the count for the items in the group, so the filter (whether it is a 1 or a 0) seems to be ignored. Does this depend on how count works? count 1 Answer 1 There is no filter here. Both col("is_fav") == 1 and col("is_fav") == 0) are just boolean expressions and count doesn't really care about their value as long a
Read more

Trying to Print Gridster Items to PDF without overlapping contents

Image
Clash Royale CLAN TAG #URR8PPP Trying to Print Gridster Items to PDF without overlapping contents I want to print gridster items to pdf using chome browser. Unfortunately the item overlaps on next page. Is there any way to make gridster item go to next page if it doesnt fit in the current page when printing to pdf? Screenshot By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Read more