Search found 7 matches

by wodzu
03 Feb 2020, 15:30
Forum: Ask For Help
Topic: CDO COM - slow script execution when sending email to multiple recipients
Replies: 4
Views: 403

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 := "[email protected].com; [email protected].com; [email protected].com; [email protected].com; [email protected].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...
by wodzu
03 Feb 2020, 13:17
Forum: Ask For Help
Topic: CDO COM - slow script execution when sending email to multiple recipients
Replies: 4
Views: 403

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 := [email protected].com; [email protected].com; [email protected].com; [email protected].com; [email protected].com; etc. and then triggered by a standard command: pmsg.To := ListOfUsers U...
by wodzu
28 Jan 2020, 02:13
Forum: Ask For Help
Topic: Publishing Excel sheet to .html using VBA/COM Topic is solved
Replies: 3
Views: 352

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!
by wodzu
27 Jan 2020, 08:15
Forum: Ask For Help
Topic: Publishing Excel sheet to .html using VBA/COM Topic is solved
Replies: 3
Views: 352

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",...
by wodzu
26 Feb 2019, 02:10
Forum: Ask For Help
Topic: Paste range of cells from Excel to Outlook using COM Topic is solved
Replies: 3
Views: 732

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...
by wodzu
25 Feb 2019, 10:11
Forum: Ask For Help
Topic: Paste range of cells from Excel to Outlook using COM Topic is solved
Replies: 3
Views: 732

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...
by wodzu
06 Dec 2018, 02:32
Forum: Scripts and Functions
Topic: BARCODER - Create 1D and 2D Barcodes (QRCode , C39,etc)
Replies: 74
Views: 39677

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...

Go to advanced search