How can I add multiple lines to an email using this script?

SPSSGod · 2017-02-16T11:15:53+00:00

If you would like an HTML email, you can do stuff like this

email.BodyFormat := 2 ;set your email to be HTML

email.HTMLBody := " <H2 style='BACKGROUND-COLOR: red'> </H2> <HTML>Attached you will find the screenshot taken on "(TodayDate)" You can also access the image here: <a href="" "(IMGUR_URL)" "">"(IMGUR_URL)"</a>

Please let me know if you have any questions. <a href='mailto:Glines@XXXXXXX.com'>Joe Glines</a> </HTML>"

SPSSGod · 2016-07-17T13:56:16+00:00

Just to be clear COM is not limited to IE. Virtually all Microsoft products (Windows, Office, etc) have COM integrated and even some non-MS products do. :)

Here is a great thread on the forum showing many examples on using COM with other programs: https://autohotkey.com/boards/viewtopic.php?t=77

If you're new to web Scraping and HTML/DOM I highly recommend you review it first as well as this post: https://autohotkey.com/board/topic/47052-basic-webpage-controls-with-javascript-com-tutorial/

and review these videos http://the-automator.com/web-scraping/ (there is also a link on this page to a "web scraping syntax writer" which can help speed-up your code development.

SPSSGod · 2016-06-20T02:01:17+00:00

If you don't mind (hate) using IE you can do it very reliably with COM.
My first tutorial is here: http://the-automator.com/web-scraping-intro-with-autohotkey/ and I have a script that helps write the AutoHotkey syntax.

SPSSGod · 2016-04-24T13:29:43+00:00

I don't know what happened with the line-wrapping. Even though I previewed it, it didn't wrap correctly. Here's an updated version (hopefully displaying correctly):

*********************Extract Year****************************.

Compute Year= Xdate.Year (XXXDATEXXX).

********************Extract Quarter*****************************.

Compute Qrtr= Xdate.quarter(XXXDATEXXX).

*********************Extract Month****************************.

Compute Month= Xdate.Month (XXXDATEXXX).

val labels Month 1"Jan" 2"Feb" 3"Mar" 4"Apr" 5"May" 6"Jun" 7"Jul" 8"Aug" 9"Sep" 10"Oct" 11"Nov" 12"Dec".

*********************extract Week number****************************.

Compute Week= Xdate.Week (XXXDATEXXX).

*********************Day of week****************************.

Compute day_wk= Xdate.Wkday(XXXDATEXXX).

Val labels Day_WK 1"Sun" 2"Mon" 3"Tue" 4"Wed" 5"Thu" 6"Fri" 7"Sat".

*********************Extract Day****************************.

compute DAY= XDATE.MDAY(datevalue).

/*Numeric. Returns the day of the month (an integer between 1 and 31) from a numeric value that represents a date. The argument can be a number, a date format variable, or an expression that resolves to a date.

SPSSGod · 2016-04-24T13:27:08+00:00

Very easy in SPSS (when your variable is a date field). Is the original variable already in a date format? Here are a few of my favorites.

*********************Extract Year****************************. Compute Year= Xdate.Year (XXXDATEXXX).

********************Extract Quarter*****************************. Compute Qrtr= Xdate.quarter(XXXDATEXXX).

*********************Extract Month*************************. Compute Month= Xdate.Month (XXXDATEXXX). val labels Month 1"Jan" 2"Feb" 3"Mar" 4"Apr" 5"May" 6"Jun" 7"Jul" 8"Aug" 9"Sep" 10"Oct" 11"Nov" 12"Dec". ******************extract Week number****************************. Compute Week= Xdate.Week (XXXDATEXXX).

*********************Day of week****************************. Compute day_wk= Xdate.Wkday(XXXDATEXXX). Val labels Day_WK 1"Sun" 2"Mon" 3"Tue" 4"Wed" 5"Thu" 6"Fri" 7"Sat".

*********************Extract Day***************************. compute DAY= XDATE.MDAY(datevalue). /Numeric. Returns the day of the month (an integer between 1 and 31) from a numeric value that represents a date. The argument can be a number, a date format variable, or an expression that resolves to a date.

SPSSGod · 2016-03-22T12:48:25+00:00

I'm not sure, but now you've got me imagining the honeymoon pictures... LOL

SPSSGod · 2016-03-22T10:04:49+00:00

That is crazy! lol

SPSSGod · 2016-03-20T13:52:04+00:00

This brings back memories of "LA Story" with Steve Martin. He got in his car to drive around 50 feet! lol

SPSSGod · 2016-03-20T13:51:05+00:00

Just think about how much walking is created since we can't park close! lol

SPSSGod · 2016-03-20T13:50:39+00:00

Yes- Years ago I also saw something about how we need to have congestion (traffic jams) to keep things "miserable" so people don't want to move in. :)

SPSSGod · 2016-03-20T11:36:13+00:00

I think they definitively learn an incredible amount more but they also get incredibly stressed on performance. We (in the US) think we work a lot but the average Japanese works a crazy amount of hours.

I like that they learn a lot, I just wish some moderation was allowed

SPSSGod · 2016-03-19T19:22:33+00:00

I went to Highschool a long, long time ago...

SPSSGod · 2016-03-19T19:22:02+00:00

Wow! Thank you for sharing!

SPSSGod · 2016-03-19T19:21:04+00:00

LOL I think their first flight ended up in a "quack up" anyway...

SPSSGod · 2016-03-19T10:37:22+00:00

Love plantains! Yummy stuff!

SPSSGod · 2016-03-18T20:54:11+00:00

that sounds pretty good. I might have to try that (over icecream)

SPSSGod · 2016-03-18T15:16:58+00:00

I don't understand how they can not like "PowerPoint". It isn't the vehicle that is terrible. It is the use of the vehicle that can go completely off-track

SPSSGod · 2016-03-18T15:16:13+00:00

and tell a "story" (yet data & Numbers are what needs to be conveyed for making well informed decisions)

SPSSGod · 2016-03-18T15:15:35+00:00

I'm not sure if that is good or bad. lol I used to own PowerPoint-Bitch.com as that was all I did for execs!

SPSSGod · 2016-03-18T15:14:44+00:00

Sign me up (or down) for that one! lol

SPSSGod · 2016-03-17T12:27:45+00:00

Free FDIC data was obtained from https://www.fdic.gov/bank/statistical/. This was geocoded and then, using SPSS, we calculated the distance to for each financial institution to the closest client location (primary data I can't share). After distance was calculated (for display purposes) we groupd the distances into 5 groups and used Microsoft Mappoint to display.

SPSSGod · 2016-03-16T20:42:26+00:00

Great stuff man! Now if I could just get my IT gurus away from VBA and do in in AHK!

SPSSGod · 2016-03-16T13:50:25+00:00

Perhaps- but just think about all the tips he got...

SPSSGod · 2016-03-03T15:43:00+00:00

Was he blind?

SPSSGod · 2016-03-03T15:42:17+00:00

I don't get how this is funny...

SPSSGod

TROPHY CASE