| Thread | Last Author | Messages
read/total | Date |
|---|
| Outlook Coding - Select different email adresses to send from |
bmcilroy |
0 / 1 |
09 Jan 2010 |
| One other thought - what would the code be if I upgrade to Office 2007?
---
frmsrcurl: http://msgroups.net/microsoft.public.outlook.program_vba/Outlook-Coding-Select-different-email-adresses-to-send-from... |
| Scraping outlook emails (2 questions) |
ker_01 |
0 / 2 |
08 Jan 2010 |
| Question 1 solved- Found a way to do it here
(http://www.vbforums.com/archive/index.php/t-400121.html) for the benefit of
future searchers.
I'll try to get access to a 2007 machine to test the new code, and I'll
create a new thread if I run into issues.
Thank you,
Keith
"ker_01" wrote:
>
> Full code appended below.
>
> My goal is that this code (when triggered) will... |
| Tracking meeting request responses in Outlook |
Dale Fye |
0 / 17 |
08 Jan 2010 |
| Sorry,
I got a "D" in following instructions.
That did it. Thanks a lot for your patience.
How do I go about getting a discount on the book? ;-)
----
HTH
Dale
"Sue Mosher [MVP]" wrote:
> Again, please replace the Set objApp statement so that it uses the intrinsic
> Application object instead of CreateObject().
> --
> Sue Mosher, Outlook MVP
> Author of... |
| how to add ...person wrote...email address..reply |
pete the greek |
0 / 4 |
08 Jan 2010 |
| try this
you need to add this code in the vba window(alt+f11) will get you there
once you have it there you could customise a toolbar to give you a button to
run it
Sub replytest()
Set ThisItem = Application.ActiveExplorer.Selection
Set thisreply = ThisItem.Item(1).Reply
thisreply.Body = "In a message dated" & Chr(32) & Date & Chr(32) & Time &
Chr(32) & "Eastern Daylight Time" &... |
| Heads.... Brick Walls |
Conrad Rowlands |
0 / 1 |
08 Jan 2010 |
| Hi Dmitry,
Not the first time we've conversed and I doubt the last... First Off I am using out-of-the-box VSTO, initially targetted at 2003 upwards but can draw a line at 2007 if need be....
I wondered if you had any idea on how to trap if the user changes their selection in a calendar. For instance I have a summarised view of the calendar showing the last month's events in a month view... |
| Heads.... Brick Walls |
Conrad Rowlands |
0 / 1 |
08 Jan 2010 |
| Hi Dmitry,
Not the first time we've conversed and I doubt the last... First Off I am using out-of-the-box VSTO, initially targetted at 2003 upwards but can draw a line at 2007 if need be....
I wondered if you had any idea on how to trap if the user changes their selection in a calendar. For instance I have a summarised view of the calendar showing the last month's events in a month view... |
| Heads.... Brick Walls |
Conrad Rowlands |
0 / 1 |
08 Jan 2010 |
| Hi Dmitry,
Not the first time we've conversed and I doubt the last... First Off I am using out-of-the-box VSTO, initially targetted at 2003 upwards but can draw a line at 2007 if need be....
I wondered if you had any idea on how to trap if the user changes their selection in a calendar. For instance I have a summarised view of the calendar showing the last month's events in a month view... |
| Heads.... Brick Walls |
Conrad Rowlands |
0 / 1 |
08 Jan 2010 |
| Hi Dmitry,
Not the first time we've conversed and I doubt the last... First Off I am using out-of-the-box VSTO, initially targetted at 2003 upwards but can draw a line at 2007 if need be....
I wondered if you had any idea on how to trap if the user changes their selection in a calendar. For instance I have a summarised view of the calendar showing the last month's events in a month view... |
| How to get Inspector or MailItem from wordEditor |
Tom |
0 / 7 |
08 Jan 2010 |
| Thanks Ken. The further discusion will go out of the scope of Outlook & VBA.
I am going to ask on Outlook general another one.
Tom
"Ken Slovak - [MVP - Outlook]" wrote:
> The results you are seeing are inconsistent with what normally is seen with
> Outlook and WordMail.
>
> In Outlook 2003 you would have 2 windows as seen in Spy++ that have a class
> of "OpusApp". One is a... |
| Import to Access errors out |
Sue Mosher [MVP] |
0 / 20 |
07 Jan 2010 |
| I disagree. If you set a database field to a certain value, but read out a
different value from the same field, then the cause would seem to lie in the
database. Nothing else has touched the data. It's certainly not an Outlook
issue. I have no idea what in Access could cause this other than having the
wrong data type for the field. If you pursuse this on an Access forum, which
I would... |
| Need Help - Lotus Notes Migration to Outlook 2003 |
Pankaj |
0 / 1 |
07 Jan 2010 |
| Greetings,
We have a requirement to migrate out Lotus Notes to Outlook 2003. Me
and my team has never done such a migration. Can someone please help
me in coming out an approach for this. Basically, I would like to know
the things to be taken care before, mid and after deployment? How to
deploy (i.e tools or something else)?
A best practice for such migration, if possible.
TIA... |
| How can I stop Outlook to run subsequent rules from VBA function bound to cur... |
iScape |
0 / 1 |
07 Jan 2010 |
| And I thought to use Rule's olRuleActionStop in VBA.
Submitted using http://www.outlookforums.com... |
| How can I stop Outlook to run subsequent rules from VBA function bound to cur... |
iScape |
0 / 1 |
07 Jan 2010 |
| I'm using Outlook 2007.
Submitted using http://www.outlookforums.com... |
| How can I stop Outlook to run subsequent rules from VBA function bound to cur... |
iScape |
0 / 1 |
07 Jan 2010 |
| Hi,
Let's assume I have Outlook "Rule A" that runs a function from VBA script. In the function I change "stop processing more rules" property of the "Rule A".
The question is: should I expect that after Outlook VBA will complete execution of the function, decision if to process rule following "Rule A" or not will be driven by the current state of "stop processing more rules" that I changed... |
| -> [O2007]: get the message HTML original source code? |
Steve JORDI |
0 / 7 |
07 Jan 2010 |
| On Thu, 7 Jan 2010 13:18:56 -0500, "Sue Mosher [MVP]"
<suemvp@gmail.com> wrote:
>Messages in the Junk Email folder will display only plain text.
That's good to know. But it's messages in the Inbox.
I think I will reinstall Outlook 2007 because they seem ok on my
laptop but definitely not on my desktop!
Sincerely,
Steve JORDI
(Remove the K_I_L_LSPAM from my email address)... |
| ->[O2007] Parsing each line of a MailItem HTMLBody? |
Steve JORDI |
0 / 3 |
07 Jan 2010 |
| Hi Ken,
thanks for your help.
Ok, I'll check this. I had a hunch it would be string operations.
Just come from Excel VBA programming and of course handling
information in Excel and Outlook is different :-)
Sincerely,
Steve JORDI
(Remove the K_I_L_LSPAM from my email address)
------------------------------------------------
1197 Prangins Email: stevejordiK_I_L_LSPAM@hotmail.com... |
| VBA Editor doesn't Start |
Alberto |
0 / 2 |
07 Jan 2010 |
| It works again, seems that Outlook deactivated the vba___ .dll because of a
problem with the Office Communicator Add-In. I think I will post in the the
add-in forum. But by the way, does anybody know if there are known issues
when using macros and also thjis add-in?
Add-In: Communicator Office 2007
version of Outlook 2003
Bye,
"Alberto" wrote:
>
> Hello,
>
> when... |
| Automating Exporting to pst file |
Trouble |
0 / 4 |
07 Jan 2010 |
| "Karl Timmermans" wrote:
> May I suggest also checking some excellent and relatively inexpensive
> ($50) backup/restore products that would be useful not just for backing
> up Outlook but also for your system (or any part of it) and it can all be
> automated.
>
> Acronis (TrueImage Home)
> http://www.acronis.com/
> Genie-Soft
> http://www.genie-soft.com/
> NTI
> http://www.... |
| use customizedform for the exsisting contacts |
ed |
0 / 21 |
07 Jan 2010 |
| Thank you for ALL your HELP!!! Learned a lot and thank you.
"Sue Mosher [MVP]" wrote:
> The registry substition method would be used, for example, to cause all
> IPM.Contact items (i.e. all items using the standard contact form) to open
> in the published form IPM.Contact.MyForm, regardless of what folder those
> items are in.
>
> The steps you gave are correct for implementing... |
| Help in programmatically setting formatting in an AppointmentI |
Sue Mosher [MVP] |
0 / 3 |
07 Jan 2010 |
| How formatting is applied depends in part on what the current Word.Selection
object encompasses. You should see similar effects when you're working
manually in a document. As you already seem to know a bit about how to move
the selection, I suggest you continue playing with that, using the Word
macro recorder as needed, to nail down the exact effect you want.
What do you mean by... |
| Code to add calnedar options/add holiday |
Zamsheer |
0 / 1 |
07 Jan 2010 |
| Can someone help me to get a code(any language) to automate below mentioned
tasks? I need to develop a code which will do below mentioned tasks. It can
be a vb application or any .net or any languange.
1.Select Calendar Options, and under Calendar options, click Add Holidays.
2.Select the check box next to 'South Africa' . You may Uncheck other Boxes
as necessary. You may add... |
| automate outlook stationary |
Southern at Heart |
0 / 2 |
06 Jan 2010 |
| Any recent ideas on this?
thanks.
"Southern at Heart" wrote:
> Hi,
> I've done a little vba programming (in Access, mostly) and am wanting to
> attempt to make a 'stationary changer'. I currently just use a blank
> stationary for my emails. I want to put a button on the tool menu that I can
> click that will automatically paste a picture into the top of my email body.
> Can... |
| Possible to write a macro to print all attachments with specific . |
Perry |
0 / 2 |
06 Jan 2010 |
| I failed to notice the "print attachments" option in the printer dialog box.
So I checked that box--went to my "finishing" option and chose to print four
pages per page and printed. The result was that all attachments were printed
at once, but it ignored the finishing selection of printing four pages per
page. Hmmmmmm.
"Perry" wrote:
> So here's the deal:
>
> I get emails... |
| Determining if Outlook is installed? |
Tony Toews [MVP] |
0 / 7 |
06 Jan 2010 |
| JP <jp2112@earthlink.net> wrote:
>Try this function:
>
>Function IsOutlookInstalled() As Boolean
> On Error Resume Next
> IsOutlookInstalled = (Not CreateObject("Outlook.Application") Is
>Nothing)
>End Function
Ah, now that's an interesting idea. I'll play around with that a bit.
My concern though is it might take several seconds to return a
response while waiting for Outlook... |
| Delete Appointments with Notifications |
jdharley |
0 / 2 |
06 Jan 2010 |
| Gee.. Is this so obvious I should know how to do it already (I don't)? Or is
it so frought with complexity noone wants to take it on?
Thanks - Jonathan
"jdharley" wrote:
> Hey folks,
>
> My calendar is full of appointments that were imported when my group moved
> out of Lotus Notes into Exchange/Outlook.
>
> The problem is, they were imported with one wrong e-mail address... |
| instructions disppear when users begin type (text field) |
Sue Mosher [MVP] |
0 / 2 |
06 Jan 2010 |
| It's hard for me to visualize exactly what you're expecting to happen. If
you want the instructions to stay on the screen, you could display them in a
label control.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"John" <John@discussions.microsoft.com>... |
| Linking Outlook to Access for Contacts in Access |
Sue Mosher [MVP] |
0 / 4 |
06 Jan 2010 |
| Reread the article, which describes both importing and linking.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"Gary S" <GaryS@discussions.microsoft.com> wrote in message
news:89642CE6-2AB9-4522-B6A1-FDDABB12AACB@microsoft.com...
> Sue,
> Thanks for the... |
| How to export a particular line in the body of the mail to excel? |
Michael Bauer [MVP - ... |
0 / 2 |
06 Jan 2010 |
| See the ItemAdd event of the Items collection. In that event read the Body
property of the email. I'd probably use the Split function, and split the
content by vbCRLF, which returns an array - one item per row.
In order to work with the Excel object library add a reference to it via
Tools/References. Use the object browser (f2) to get familar with that
object model. You'll probaly... |
| Using VBA to load the CC line on an Outlook email |
Glenn Suggs |
0 / 3 |
06 Jan 2010 |
| Thanks a million, Ken. It works great.
--
Glenn
"Ken Slovak - [MVP - Outlook]" wrote:
> Set olRecipient = olMessage.Recipients.Add(strEmailRecipient)
> olRecipient.Type = olCC ' or olTo or olBCC
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007.
> Reminder Manager, Extended Reminders, Attachment Options.
>... |
| Did Microsoft put a block on Jet Blue? |
go jetter |
0 / 1 |
06 Jan 2010 |
| When I book a flight on line with Jet Blue they usally e-mail me my
Itinerary,it's work before ,now i can't receive them. WHY?... |
| add to existing distribution list |
Sue Mosher [MVP] |
0 / 4 |
05 Jan 2010 |
| There's nothing special about Outlook syntax. It's all objects, properties,
methods, and events, the same as with other libraries you may have used in
VB/VBA. The method you need, Items.Find, is well documented in Outlook VBA
Help and in the Outlook Developer Reference on MSDN.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and... |
| Application_ItemSend not firing even with low security |
Remou |
0 / 2 |
05 Jan 2010 |
| The problem was that I had installed Outlook 2010 after Outlook 2000, as far
as I can tell, so the library referenced was Outlook 9.0 (msoutl9.olb),
rather than Outlook 14.0 (msoutl.olb). I renamed
C:\Users\%User%\AppData\Roaming\Microsoft\Outlook\VbaProject.OTM to
VbaProject.OLD and this appears to have sorted everything out.
"Remou" wrote:
> The code below does not fire in... |
| Can not change email body content on Outlook 2010 |
Tom |
0 / 3 |
05 Jan 2010 |
| Thanks Sue! That's really help!
"Sue Mosher [MVP]" wrote:
> You need to call Item.Save after changing the item's content.
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "Tom" <Tom@discussions.microsoft.com> wrote in message
>... |
| Add logic to what Voting buttons do |
Sue Mosher [MVP] |
0 / 2 |
05 Jan 2010 |
| Yes, that's possible IF your form is for internal use only and can be
published to the Organizational Forms library on your company's Exchange
Server. Just write code for the form's Item_CustomAction event handler.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.... |
| VBA routine to calendar birthdays from imported contacts. |
Susan May |
0 / 6 |
05 Jan 2010 |
| Peter, I have 663 birthdays to add to my bosses' calendar. The person in
charge of the list adds the employees' birthdays in the birthday field in
Outlook Contacts. I delete my contacts in my personal folder and copy her
contacts lists each month to my folder because the employees are ever
changing.
Where do I go to add this code so the birthdays automatically display in my... |
| PST file corrupted |
Sue Mosher [MVP] |
0 / 2 |
05 Jan 2010 |
| Try one of the tools at http://www.slipstick.com/problems/scanpst.asp. And
if you have further problems, post them in the
microsoft.public.outlook.general group, not this one, which is for
programming issues.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54... |
| Some code to set your due tasks 20 days from now |
replacewithat |
0 / 1 |
05 Jan 2010 |
| Sub taskadd_days()
Set myOlApp = Outlook.Application
Set myNameSpace = myOlApp.GetNamespace("MAPI")
Set myFolder = myNameSpace.GetDefaultFolder(olFolderTasks)
Set myItems = myFolder.Items
For Each x In myFolder.Items
If x.Complete <> True And x.DueDate < Date Then
x.DueDate = Date + 20
x.ReminderTime = Date + 15 + TimeValue("09:00:00")
x.ReminderSet =... |
| Select the position of an attached file in a HTML mailitem |
Sue Mosher [MVP] |
0 / 2 |
05 Jan 2010 |
| Correct: Only RTF message bodies place the attachment in the body.
Therefore, the position is relevant only to RTF messages, not HTML or plain
text.
It is not possible to make a hyperlink to an attached file in an Outlook
message.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.... |
| Outlook-Exchange bug??? |
Alberto |
0 / 7 |
05 Jan 2010 |
| Thank you Ken. I give up with the issue. I hope someday I will find why 2
operations just like:
--------
Dim MySharedFolder, MyPublicFolder
Set MyPublicfolder = ..... 'Folder in Exange Public Folder
Set MySharedFolder = ....'Folder in shared mailbox
------------
give me a problem when I run this code and go after that to the shared
folder without having "touched" it before.... |
| writing to excel from outlook |
Michael Bauer [MVP - ... |
0 / 4 |
04 Jan 2010 |
| That's how it works as Excel is another process, and the last line of code
executed is always in Outlook, which brings Outlook up to the front. You
could minimize the current Outlook window, or use some Win32 API functions
in order to find the Excel window.
--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.... |
| move contents from hundreds of emails into excel |
pete the greek |
0 / 4 |
04 Jan 2010 |
| hi all
just a thought if the body text is divided up by colons you might want to
look at split
BodyArray=split(Myitem.body,":")
this will give you array each element will be the text between the colons
regards
Pete
"volda2000" wrote:
> I have just been tasked with the same request. Were you able to get this to
> work?
>
> "JSpence2003" wrote:
>
> > I have... |
| Saving Embedded Images in Outlook 2007 |
Michael Bauer [MVP - ... |
0 / 4 |
04 Jan 2010 |
| Select the first line of the code, and press f9 for a breakpoint. Then press
f8, and with f8 walk trough the code step by step. With that you can where
the error is raised.
--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>
Am Sun, 03 Jan 2010 23:19:16 GMT schrieb The Old Bloke:
> On Sun, 3... |
| Running a Macro when email arrives |
Michael Bauer [MVP - ... |
0 / 2 |
04 Jan 2010 |
| I'd probably create a Word document, insert the body of the email, and then
print the document instead of the email.
--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>
Am Mon, 4 Jan 2010 12:52:58 +0800 schrieb Gardos Catalin:
> Hello everybody. I trie to make a macro that print my incoming... |
| How do I create a macro to add contacts from email messages? |
Michael Bauer [MVP - ... |
0 / 2 |
03 Jan 2010 |
| If you want to do that when receiving an email, see the ItemAdd event of the
Inbox (there's an example in the VBA help file). And for sent item see the
ItemSend event of the Application object.
In that events you can either read the SenderEmailAddress property, or all
the addresses from the Recipients collection.
For creating a contact see the CreateItem function. You could call... |
| Outlook 2007 items.count incorrect |
Johnb |
0 / 2 |
02 Jan 2010 |
| It has worked fine in 2003 for several years. In the end I rewrote it and
triggered it from a rule.
Thanks for your suggestion
John
"Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message
news:eZ8EubeiKHA.6096@TK2MSFTNGP02.phx.gbl...
> Keep in midn that MAPI events are asynchronous and it is possible that
> NewMail event is fired before the message is actually created/saved... |
| Currency Edit Control on custom Taskpanes |
escamoteur |
0 / 2 |
02 Jan 2010 |
| Hi,
this might have got overlooked because I posted it just before X-Mas.
I'm still looking for Help
Best
Tom
"escamoteur" <mail@burkharts.net> schrieb im Newsbeitrag news:DF6EC406-D637-4575-8CEA-4AD8EDDE95F9@microsoft.com...
> Hi,
>
> on my Formregion I have Editcontrols that display me the local Currency Symbol automatically with the content formated as
> currency. I would like... |
| How to Create Buttons in email body / toolbar |
Dmitry Streblechenko |
0 / 3 |
02 Jan 2010 |
| You would need to insert your own button to the Explorer or Inspector
toolbar (CommandBar) and then write code in the button event handler that
takes the contents of the currently selected e-mail
(Application.ActiveExplorer.Selection collection) and performs the
appropriate action on it - create new message using Application.CreateItem
or MailItem.Reply, populate its properties,... |
| OL 2003 button: schedule automatic send/receive |
Microsoft |
0 / 1 |
02 Jan 2010 |
| Would like to add a macro to toggle automatic send/receive in the current
profile. Action would be equivalent to checking/unchecking Setting for
groups "All Accounts" - Schedule automatic send/receive (or perhaps toggle
interval between zero, non-zero?).
Thanks for any ideas.
George... |
| Open Advanced Search Dialog |
Sue Mosher [MVP] |
0 / 2 |
01 Jan 2010 |
| What you want can't be done. The best you could do probably would be to use
CommandBars techniques to execute the menu/toolbar item that displays the
Advanced Find dialog. The Outlook object model does not, however, provide a
way to preset any of the options in that dialog (although it might be done
with a SendKeys kludge -- not a solution I'd ever give to users).
--
Sue Mosher,... |
| send email using template |
judith |
0 / 8 |
01 Jan 2010 |
| Thanks for your help Dmitry. I think this is getting a bit beyond me. I will
just attach a .snp file or try to get my customer to upgrade to 2007 and
attach as pdf
Thanks
"Dmitry Streblechenko" wrote:
> No, if the mesage is not being displayed (you could then use the Inspector
> objects), you need to read the HTMLBody and insert your new text (HTML) at
> the appropriate place.... |