| Thread | Last Author | Messages read/total | Date |
|---|
| Yes |
Rich Fiekowsky |
0 / 3 |
01:58 pm |
| I do it, but each machine has to install your certificate as a trusted certificate. In some companies that might be considered a security hole. IMO, if they trust your code, they may as well trust your certificate.
Also, each new release of Excel twists this process a new way. And of course it may vary on different releases of Windows - I do not know. Details are all over the web.... |
| Insert First Name in Reply |
Ken Slovak |
0 / 4 |
09:17 am |
| Would you want it to be more automatic or do you want the code only to run
from a button?
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"Brian B." <brianblanchett@gmail.com> wrote in message... |
| Automating Paste In Outlook 2007 |
Ken Slovak |
0 / 10 |
09:16 am |
| I would set up a a more global Outlook.Application object and check it and
only instantiate it if it's nothing. In the initial code when Access is
started I'd put Set objOutlook = Nothing. Then I'd set it and check it
whenever I needed to use it.
If I started Outlook if GetObject() failed I'd use CreateObject() and set a
Boolean to indicate that. If I started Outlook when my code was... |
| macro to reply sometimes fails - why? |
Mark |
0 / 9 |
28 Jul |
| ... |
| Mail merge from Word saving emails to Drafts |
Ken Slovak |
0 / 2 |
27 Jul |
| Anything other than that behavior would require you to code the merge
yourself using Outlook and Word automation code. You couldn't use the
built-in merge.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"TWrench" <thomas.... |
| How to set the Email address in the To field with MailOpen Event |
Mark |
0 / 4 |
22 Jul |
| ... |
| How to capture contacts 10 times faster from Outlook? |
Dhan |
0 / 1 |
22 Jul |
| Generally small business owners and sales & marketing professionals
receive leads from various sources like emails, web pages, online
directories, and customer and sales enquiries. They spend a majority
of their time in manually copying and pasting each and every contact
detail into the respective fields of the contact
database.AddressGrabber uses its patented contact capture technology... |
| Insert File As Text Using Automation |
Ken Slovak |
0 / 2 |
21 Jul |
| You would need to read the file as a text string and insert it into the
item's Body or HMTLBody. That's what that command does for you.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"Neil" <neil.ginsberg+newsgroup@gmail.com>... |
| Saving attachments from encrypted email |
Ken Slovak |
0 / 2 |
15 Jul |
| There's nothing that you can do with Outlook code with encrypted messages.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"PDAlma" <juvey@icpnet.pl> wrote in message
news:i1mpnu$4g9$1@opal.icpnet.pl...
> Hello!
> (Outlook... |
| Make use of Events in Outlook |
Ken Slovak |
0 / 10 |
09 Jul |
| Ah, spelling and typo errors. That makes sense now.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"Jan T." <noreply> wrote in message
news:aqqdnYv0m_D-a6vRnZ2dnUVZ_g6dnZ2d@posted.comnet...
>I found out what was wrong I think.... |
| Send All emails in Outbox and Quit using VBA |
Jan T. |
0 / 4 |
07 Jul |
| What error do you get? If you use Create object, using late binding, you
must
make objOutlook an object. Same for objCB. Comment out your error trap
so you can watch eventual error code or description to see what is going
wrong.
You probably still have to check you buttonID because i don't know what is
the
right code her.
Try someting like this:
Public Sub SendReceiveNowDev()... |
| Outlook saves sent messages when it is not supposed to |
Frank |
0 / 4 |
01 Jul |
| I have tried changing the .oft file with the subject line being
vuvuzela but it does not work either.... |
| Outlook 2000 programically Permanently Delete mail, how to? |
steve |
0 / 1 |
29 Jun |
| I want to create a menu item to permanently delete mail.
I'm not a vba person per-say although am familiar with how to create a menu
item once a macro is create, and how to enter data into a macro. Often I
just use the MS word record macro and then make a few changes to it to do
what I want.
Having said that can someone give me the code to delete a selected mail
message.
eg I... |
| Outlook 2007 'section1' style |
chappers77 |
0 / 1 |
25 Jun |
| Hi
One of our users is having an issue when replying to external emails.
The email comes in and the formatting is fine, the user then replies
and all seems to be OK until she looks at the sent email and all text
has been changed to Times New Roman instead of Calibri.
I have checked the users font settings and all are corrently set to
use Calibri (no +Body etc).
After a net search I... |
| Insert NAme and jod title in Body of the mail |
wolfman.mahesh |
0 / 1 |
24 Jun |
| Hi !!!
i am a total amateur where coding is concerned here is what i need
i need a macro that will run automatically when a mail is sent wherein
the recipient name
job title
company name
is inserted in multiple places in the body of the mail...
the name, job title and department should be retrieved from the
contacts
the subject and the rest of the body of the mail remain the... |
| Outlook macro - new email - how to set font |
Ken Slovak |
0 / 4 |
17 Jun |
| The best way to see what to do is to view the existing HTMLBody property in
an email formatted the way you want. Select an email like that in the folder
view and then open the Outlook VBA project (Alt+F11). Show the Immediate
window if it's not open and enter the following there:
? Application.ActiveExplorer.Selection(1).HTMLBody
Place your cursor in that line and press Enter to... |
| Outlook add-in that captures contacts from email, web page and documents and ... |
Dhan |
0 / 1 |
11 Jun |
| Are you are looking for an effective way to automate capturing contact
information from e-mail signatures, web pages, online directories or
documents, we have a Software for you.AddressGrabber uses its patented
contact capture technology to identify contact details such as First
Name, Last Name, Company, Address, City , State, Zip, Phone, Fax, e-
mail address, web site and transfers them... |
| Why Does GetObject Create New Instances of Outlook 2007+ |
rob |
0 / 2 |
08 Jun |
| rob wrote on 06/07/2010 11:39 ET :
> I'm using GetObject to automate an existing instance of Outlook using VBA
from
> Excel to open the address book and allow the user to select a group of
> recipients.
>
> When I do this with Outlook 2007 or 2010 an new Outlook window is opened each
> time the code is run. If I quit the instance of Outlook I'm holding then
> Outlook is shut down... |
| Simple hack to get $500 to your home. |
SUHASINI |
0 / 1 |
06 Jun |
| Simple hack to get $500 to your home at http://mastidunia.tk
Due to high security risks,i have hidden the cheque link in an
image. in that website on left side below search box, click on image
and enter your name and address where you want to receive your
cheque.please dont tell to anyone.... |
| Outlook 2003: Newly added UserProperties are not beeing remembered |
Stefan Becker |
0 / 1 |
06 Jun |
| Hi I have tried to add an userproperty to specific messages using vba.
My code works from time to time. However it does not work all the
time. So far I have not figured out on what that depends.
Is there any specific thing I have to do after having added the
userproperty? Do I have to save the mailitem (I have tried that, but
could not find any difference in behaviour) ?
My... |
| Outlook 2003: convert all RTF emails to HTML |
Amedee Van Gasse |
0 / 3 |
04 Jun |
| On 11 mei, 10:58, "Michael Bauer [MVP - Outlook]" <m...@mvps.org>
wrote:
> Not sure if it retains all the formattings, but in principle just loop
> through the Items collection and set each item's BodyFormat=2, then call
> Save.
Michael,
This is my code, still needs some cleanup:
Sub RTF2HTML()
On Error Resume Next
Dim ns As NameSpace
Dim Inbox As MAPIFolder
Dim Item As... |
| Changing the 'Mark item as read when selection changes' at runtime |
Ken Slovak - [MVP - O... |
0 / 2 |
03 Jun |
| There's no way to do what you want. Outlook will read those settings only at
startup and from then on will use cached settings in memory. Even if the
settings are changed it will write them out but use the cached settings, so
you're stuck.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders,... |
| Save Current email in Directory. |
Michael Bauer [MVP - ... |
0 / 2 |
03 Jun |
| So far it's hard to say what you're missing.
--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Easily share your categories:
SAM - Automatically choose sending account, signature, and sent message
folder:
<http://www.vboffice.net/product.html?lang=en>
Am Wed, 2 Jun 2010 11:46:34 +0100 schrieb DomV:
> Hi all,
>
> Brand brand new to VBA coding. Fully... |
| How to deploy Outlook Shared add-in |
Ken Slovak - [MVP - O... |
0 / 8 |
02 Jun |
| That sounds like the Office and possibly the Outlook PIA's aren't installed
in the GAC. Do you set a project prerequisite for that?
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"Gokul" <Gokul@discussions.microsoft.com> wrote... |
| macro to include email signature |
steve sharpe |
0 / 5 |
02 Jun |
| Thanks Ken. That worked Your'e a star!
Regards
Steve
'Ken Slovak - [MVP - Outlook Wrote:
> ;349299']I'm not sure. Let's see what happens first if you comment out
> the line
> myItem.Body = "body text" & myItem.Body. Do you get the signature then?
> If
> so and the body format is HTML, then see if it helps to use this line
> instead:
>
> myItem.HTMLBody = "body text" & myItem.... |
| Opening a web URL that points to PDF file... |
Ken Slovak - [MVP - O... |
0 / 8 |
01 Jun |
| I have no idea about automating Adobe Acrobat so I can't answer that. I
still don't know exactly what you're doing but there isn't a lot of time to
find out as this newsgroup is being closed by MS today probably.
If you already have an email object you can get the HTMLBody property, which
provides you a string value. You can then use string processing functions to
find an url in the... |
| you can delete the email message just sent? |
Drago |
0 / 3 |
01 Jun |
| can you do to me example ?
thanks and excuseme for my english
"Sue Mosher [MVP]" <suemvp@gmail.com> ha scritto nel messaggio
news:3C0C75B4-A515-47FF-8292-E65E5C864756@microsoft.com...
> Before you send the message, set the value of its DeleteAfterSubmit
> property
> to True.
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power... |
| Email parser & extractor for Outlook |
Dhan |
0 / 1 |
31 May |
| eMail-Lead Grabber Business is an email extractor that enables you to
extract web forms from Microsoft Outlook, Outlook Express and
automatically transfers the form details to your database.
eMail-Lead Grabber Business enables you to quickly convert emails to
ACT! Database. It also supports other databases such as Excel
spreadsheet ,Text file, GoldMine,Outlook, Access and more.
http://www.... |
| Final Reminder - Microsoft Responds to the Evolution of Community |
Sue Mosher [MVP] |
0 / 2 |
28 May |
| You can use these Microsoft forums for Outlook development questions:
End-user Outlook macros and other VBA coding
http://social.answers.microsoft.com/Forums/en-US/officeprog/threads
VSTO add-ins
http://social.msdn.microsoft.com/Forums/en-US/vsto/threads
Developer questions about Outlook coding, forms, and other types of add-ins
http://social.msdn.microsoft.... |
| Move Sent Email to archival pst folder and mark as read - HOW |
BlueWolverine |
0 / 3 |
28 May |
| Sorry. I think that was a bad day and I was in a rush. Looking back at all
the posts I got pretty good help.
I really appreciate all the hard work and help I've gotten from this forum.
I can't even begin to explain how much the Access and Excel sections bailed
me out, especially when I was learning Access.
Part of my irritation is that it felt like such a simple thing and I... |
| UserForm and ordering variables |
Chris |
0 / 5 |
28 May |
| Sue,
I figured it out. I set a flag to the variable FileNameFormat on the
userform and then use Select Case FileNameFormat back in the module to set
the filename.
Chris
"Sue Mosher [MVP]" wrote:
> Sorry, but I really can't see the problem here, because I don't know what the
> user interaction might be in your scenario. Maybe you should step away from
> the keyboard and... |
| outlook ComAddin deactivated |
Ken Slovak - [MVP - O... |
0 / 2 |
28 May |
| If your addins crashes Outlook, or gets blamed for crashing Outlook there's
nothing you can do to prevent it from being disabled.
There are cases where some other addin or automation code might crash
Outlook or crash the VB runtime, and just because your addin is VB6 it will
be blamed, and there's nothing you can do.
One such case was (possibly still is) Apple's ITunes synching... |
| Start my Outlook from a server |
Ken Slovak - [MVP - O... |
0 / 2 |
28 May |
| Not only can Outlook only be run locally on that machine, but Outlook is not
suitable for running unattended or for unattended automation. Outlook shows
modal warnings and errors that require UI intervention.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.... |
| can you do this with Outlook? |
Michael Bauer [MVP - ... |
0 / 2 |
28 May |
| For instance, you could add all the addresses to a contacts folder, and in
the ItemSend event check whether or not the recipient of the email is stored
in that folder.
--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Easily share your categories:
SAM - Automatically choose sending account, signature, and sent message
folder:
<http://www.vboffice.net/product.... |
| how to save incoming mail in TRUE csv format |
Sue Mosher [MVP] |
0 / 2 |
27 May |
| Outlook has no native ability to turn text into a csv file. If you want to do
more than save the message as a .txt file, you'll have to add your own code
to parse the message content or parse the .txt file. Either way, only you
know what you have in mind. It's not clear at all from your description what
"values" you want saved in .csv format.
--
Sue Mosher, Outlook MVP
Author of... |
| How to change status of a mail marked as a task (VBA) |
kradam |
0 / 3 |
27 May |
| Thank you Ken, it was very helpful... |
| Save incoming Email as .html file with name of subject line |
Matt |
0 / 4 |
27 May |
| Hey Chris,
Good Idea!
Thanks
Matt
"Chris" wrote:
> Matt:
>
> You might want to add either ReceivedTime(Emails) or CreationTime(Reports)
>
> Yoru code would look like:
> myItem.SaveAs "c:\mail\" & myItem.Subject & "_" & myItem.ReceivedTime &
> ".xml", olXML
>
> As I have discovered, you may need to scrub the subject and time of any
> illegal characters such as "/",... |
| add a date without holidays |
Christian W |
0 / 3 |
27 May |
| Michael,
yes, this function add dates, but i need to add 7 working days, but this
function add working days and non working days.
How i can only add working days without saturday and sunday ?
For example :
26/5/2010 + 7days = 4/6/2010 (not contain saturday and sundays)
Sorry my english.. Thanks in advance.
Christian
"Michael Bauer [MVP - Outlook]" wrote:
>... |
| Saving Emails as Messages Problems with Access Data Collection et |
Chris |
0 / 2 |
27 May |
| OK, I discovered the problem with the access data collections. The files
name ends up being too large so I put a check in to check the length of the
file name and if it is too long, ask the user to rename it with the original
filename being the default.
The Code is:
If Len(NewFileName) > 145 Then
TooLong:
NewFileName = InputBox("Please Enter a New File Name that is... |
| Scanning E-mail for Certain words & changing the background |
Rhutch |
0 / 4 |
27 May |
| I was able to get some code that scans a Word document highlights a word the
user enters but it won't work on Outlook.
Sub FindRepetitiveWords()
'
' Find Repetitive Words Macro
' Macro recorded 11/6/2003 by Monica Burns
'//Get Info from User
'//Place information in variable sUserString and Insert into document
Dim sUserString As String
sUserString = InputBox("Please... |
| VBA window keeps opening |
Amy |
0 / 1 |
27 May |
| Outlook 2007
I created quite a few macros that will open some e-mail templates. They are
in a menu on the Menu bar. The problem is when I leave my computer and come
back, the VBA window is open. It is simple enough to close it, but why does
it keep popping open? Any suggestions to stop it from opening would be
appreciated.
Thanks,
--
Amy... |
| item_send event |
Ken Slovak - [MVP - O... |
0 / 5 |
27 May |
| You can create wrapper classes in VBA just as you can in VB or C#. You can
add instances of the classes to a collection in VBA to keep them alive. Just
create a new class and add your WithEvents declarations to the class so it
can handle events for the Inspector and item.
The main problem is using timers in VBA code. You'd need to use VB-type code
to create and handle a Win32 system... |
| Populate an Outlook 2007 template with spreadsheet data. |
Michael Bauer [MVP - ... |
0 / 1 |
27 May |
| It's possible.
I'd use a class module as a collection for what the people have ot say:
<workgroup.cls>
Public Name$
Private m_Text$
Public Sub AddText(Text$)
m_Text = m_Text & Text & vbcrlf
End Sub
Public Function GetText() as String
GetText=m_Text
End Sub
</workgroup.cls>
In another module hold the collection of workgroup objects etc.:
Private m_Workgroups as New... |
| MailItem.SaveAs not working |
Chris |
0 / 10 |
25 May |
| Ken:
Declaring it as an object worked. I am including the code below which also
includes a browser supported function in case anyone has the same problem
they can find it. Thank you for your help.
Chris
'-----CODE START-----
Public Sub ExportSAR()
Dim TheEmail As Object
Dim ReportEmail As ReportItem
Dim eItem As Outlook.Items
Dim EmailNS As NameSpace... |
| Virheilmoitus Outlookia avatessa, kieli SF |
Jaaris |
0 / 1 |
25 May |
| Kun yritän avata Office Oulookin niin tulee virheilmoitus: " Microsoft office
outlookia ei voi käynnistää. Outlook-ikkunan avaaminen ei onnistu. Kyseessä
on Win7 Home Premium. Tuotteen nro: 81608-957-8450981-65315. Olen
epätoivoisesti etsinyt apua... mistä saan sitä... |
| userform combobox |
Jonathan |
0 / 2 |
24 May |
| I found it... it was my on change event that was causing issues...
thanks,
Jonathan
"Jonathan" wrote:
> Hi, using Outlook 2007. I have a simple userform that only has a combobox.
> The problem is that I cannot enter a value and cannot select an item from the
> list.
>
> Enable=true
> Locked=false
>
> I don't know if this is a red herring... the multi-column combobox is... |
| create new mail item from current item |
lindstrom |
0 / 5 |
24 May |
| Sue,
I'll try those suggestions and see what happens.
Your assistance is greatly appreciated.
DL
---
frmsrcurl: http://msgroups.net/microsoft.public.outlook.program_vba/create-new-mail-item-from-current-item... |
| Exchange Client Extensions in Outlook 2010? |
Ken Slovak - [MVP - O... |
0 / 2 |
24 May |
| Gone. The deprecation has been announced repeatedly since before the release
of Outlook 2007.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"CharlieD" <CharlieD@discussions.microsoft.com> wrote in message... |
| Contact Email address format |
Sue Mosher [MVP] |
0 / 4 |
24 May |
| For Outlook 2007 or later, once you get the address from the contact in X.400
(Exchange) format, use it as the argument for the Namespace.CreateRecipient
method to return a Recipient object. Then use the
Recipient.AddressEntry.GetExchangeUser method to return an ExchangeUser
object and get its PrimarySmtpAddress address:
Set recip = mapiNamespace.CreateRecipient(contactemail)... |
| combobox list in userform |
Sue Mosher [MVP] |
0 / 2 |
24 May |
| You put it in code. When the form initializes, use either the AddItem method
or the List property to set the rows.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"robzrob" wrote:
> Hi
>
> How do I compile the list for a combobox? Where do I put... |