Search found 9 matches
- 27 Feb 2022, 16:07
- Forum: Ask for Help (v1)
- Topic: PDFCreator 3.2 + COM Interface Topic is solved
- Replies: 3
- Views: 600
Re: PDFCreator 3.2 + COM Interface Topic is solved
flyingDman , my bad, didn't explain what I intend to do. I need to create a formatted table document. Excel isn't an option, because on the target PC there's no Office. Figured that I would create a formatted HTML document and then convert it into PDF. I was also thinking about making a RTF documen...
- 27 Feb 2022, 13:10
- Forum: Ask for Help (v1)
- Topic: PDFCreator 3.2 + COM Interface Topic is solved
- Replies: 3
- Views: 600
PDFCreator 3.2 + COM Interface Topic is solved
Hi everyone, I'm trying to convert an example code of the VBA Word file to AHK script, unfortunately cannot find nothing on the web, just this topic which seems to show scripts that are working with some older versions of PDFCreator: https://www.autohotkey.com/board/topic/63736-createconvert-to-pdf-...
- 03 Feb 2020, 15:30
- Forum: Ask for Help (v1)
- Topic: CDO COM - slow script execution when sending email to multiple recipients
- Replies: 4
- Views: 846
Re: CDO COM - slow script execution when sending email to multiple recipients
How long does it take? Also you are presumably using (i.e. in quotes) ListOfUsers := "abc@abc.com; def@def.com; qwe@qwe.com; tyu@tyu.com; iop@iop.com" It takes about 3-4 minutes for ca. 30 recipients. If i set it between quotes I'll become an error message: 0x8004020C - At least one recipient is re...
- 03 Feb 2020, 13:17
- Forum: Ask for Help (v1)
- Topic: CDO COM - slow script execution when sending email to multiple recipients
- Replies: 4
- Views: 846
CDO COM - slow script execution when sending email to multiple recipients
Hi all, I'm using the CDO Com scripting for sending emails using a corresponding SMTP server. Bunch of recipients (ca. 30) are stored in a variable: ListOfUsers := abc@abc.com; def@def.com; qwe@qwe.com; tyu@tyu.com; iop@iop.com; etc. and then triggered by a standard command: pmsg.To := ListOfUsers U...
- 28 Jan 2020, 02:13
- Forum: Ask for Help (v1)
- Topic: Publishing Excel sheet to .html using VBA/COM Topic is solved
- Replies: 3
- Views: 1043
Re: Publishing Excel sheet to .html using VBA/COM Topic is solved
Thank you both @teadrinker and @FanaticGuru, I figured it out with the values for Excel constants. @FanaticGuru , your code does exactly what I need!
- 27 Jan 2020, 08:15
- Forum: Ask for Help (v1)
- Topic: Publishing Excel sheet to .html using VBA/COM Topic is solved
- Replies: 3
- Views: 1043
Publishing Excel sheet to .html using VBA/COM Topic is solved
Hi everyone, could anyone help me with translating a VBA code to AHK? I want to publish an Excel sheet to a formatted .html file, this is how it in Excel VBA looks like: With ActiveWorkbook.PublishObjects.Add(xlSourceAutoFilter, _ "D:\mailsend-go-dir\123.htm", "Sheet1", "", xlHtmlStatic, "123_4257",...
- 26 Feb 2019, 02:10
- Forum: Ask for Help (v1)
- Topic: Paste range of cells from Excel to Outlook using COM Topic is solved
- Replies: 3
- Views: 1129
Re: Paste range of cells from Excel to Outlook using COM Topic is solved
ComObjActive("Excel.Application").Worksheets(1).Range("A4:C5").Copy Outlook := ComObjCreate("Outlook.Application") email := Outlook.Application.CreateItem(0) email.Display Outlook.ActiveInspector.WordEditor.Application.Selection.Paste Outlook := email := "" Thank you, it works perfectly! Is it poss...
- 25 Feb 2019, 10:11
- Forum: Ask for Help (v1)
- Topic: Paste range of cells from Excel to Outlook using COM Topic is solved
- Replies: 3
- Views: 1129
Paste range of cells from Excel to Outlook using COM Topic is solved
Hi all, I'm struggling with the following problem - I want to copy some range of cells in Excel and paste it as a table (with formatting) to a new e-mail in Outlook. The problem is I don't know how can I paste it in the email body. Any ideas? Or is there any possibility to do this with email.htmlbod...
- 06 Dec 2018, 02:32
- Forum: Scripts and Functions (v1)
- Topic: BARCODER - Create 1D and 2D Barcodes (QRCode , C39,etc)
- Replies: 106
- Views: 74698
Re: BARCODER - Create 1D and 2D Barcodes (QRCode , C39,etc)
First of all, I would like to thank you @Gio for this awesome script you made - brilliant job! I am using this part of your code that generates a 128 barcode. It works very good for my purpose but I need to make it bigger somehow. I'm printing this barcode on a Zebra printer and the quality is not g...