| Thread | Last Author | Messages
read/total | Date |
|---|
| VBA Tips - Cdigo de exemplo determinar a letra de unidade de CD-ROM - Sample ... |
Andr Luiz Bernardes |
0 / 1 |
20 May |
| ... |
| .SendUsingAccount |
Ian Letters |
1 / 1 |
04 May |
| I am trying to send emails using VBA but using an email account in Outlook 2010
The following code has been working find for sending emails using our Exchange Account in Outlook but when I try to use another account in Outlook 2010 it doesn't. I am not an experienced programmer in VBA but can using work my way around things. The code pasted below is what works fine: The .SentOnBehalfOfName =... |
| Macro not working windows x64 |
Jimmy Chen |
1 / 1 |
23 Apr |
| Hi there this VBA code works with Outlok 2007 and Windows 7 + XP 32bit. I have just upgraded a PC to win7 x64 and it's not working I receive a "compile error" User-defined type not defined when I try to compile. It's a outlook 32-bit install on Win7x64. I'm not a programmer so I can't figure it out, I've attached the original code below.
Thanks in advance.
Private Const... |
| Subject Name into a Userform |
Dave |
1 / 1 |
17 Apr |
| I am opening a userform in outlook and would like the subject to show in a text box,
Something like...
Private Sub UserForm_Initialize()
TextBox1 = Subject
End Sub
So when I show the Userform, the textbox will diplay the open email's subject.
Thanks... |
| Place subject line into a Textbox on a Userform. |
davesexcel@gmail.com |
1 / 1 |
17 Apr |
| For example, I want to show a userform and display the textbox as what is in the email subjct box
Private Sub UserForm_Initialize()
TextBox1 = thisemail.Subject
End Sub
Thank you... |
| Get Outlook Contact name for Sender and Recipients of Emails |
McKilty |
1 / 1 |
16 Apr |
| I am looping through sent and received emails and pulling the contact
names from each. What I would like is for the name to be what I have
in my contacts for that person, rather than what may appear in
Suggested Contacts or what the user has chosen his display name to be.
For example, I have a contact named Tom Steele who is filed in my
Contacts as Steele, Tom. He also happens to... |
| extract SMTP address to table |
bobh |
1 / 1 |
03 Apr |
| Hi All,
Anyone have vba code they will share that will get the smtp email
addresses from Outlook2007/Exchange global address book and add them
to an Access2003 table or just output them to a delimited text file? I
want to display that list in a combobox on an Access form. Linking to
Outlooks/Exchanges global address book directly from Access2003 thru
an odbc connection does not display... |
| Export single contact to MS ACCESS DBMS client table |
Rob Samuels |
1 / 1 |
30 Mar |
| I'm running Office 2007. When I receive an email from a new prospective client. How do I export the single new contact into the client table within an Access DBMS using VBA?... |
| VBA Access - Funo Format (com Datas) |
Andr Luiz Bernardes |
1 / 1 |
24 Mar |
| ... |
| VBA Access - Exportando registros para PARADOX - VBA Code to ImportParadox Ta... |
Andr Luiz Bernardes |
1 / 1 |
24 Mar |
| ... |
| VBA Layout - Eletronic Dashboard - Ford Fusion 2013. |
Andr Luiz Bernardes |
1 / 1 |
24 Mar |
| ... |
| Hiding sidebar in Google EarthLib programmatically |
Jrgen Meyer |
1 / 1 |
20 Mar |
| I am using Google EarthLib from Access 2010
I can't find an item in the object catalog to hide the sidebar
Someone knows how to do it?
Regards
Juergen... |
| Searching for script to MOVE email, and popup for FIND FOLDER |
Oren L |
1 / 1 |
06 Feb |
| Hi All
I need some VBA script, and I can't find.
How I wish it to be:
1. Select email
2. Click on button that activates the script
3. Popup window will appear with text search input
4. As I type all relevant folders will appear below
5. I will click the wanted folder
6. The email will moved to that folder.
How can I find help on that ?
Thanks in advance
Oren... |
| [share] some nice tutorials for the beginner |
James Carl |
1 / 1 |
31 Dec 2011 |
| There're more than 60 tutorials on a variaty of categories I'd like to
share with you:
Access.2010.Queries.in.Depth
Android Tutorial - Lessons
Cocos2D Box2d Tutorials
Cocos2D iPhone Tutorials (Bucky)
Cocos2D Tutorial
Create.an.Online.Portfolio.with.WordPress
Create.Animated.Rollovers.With.jQuery.and.Dreamwea ver
CSS.And.XHTML.For.Web.Development
CSS.For.Developers
CSS3.FIRST.LOOK.... |
| sending a form containing radio buttons and text areas (office 2007) |
steeve_dun |
1 / 1 |
21 Dec 2011 |
| Hi all,
I want to send via Access and using outlook (VBA) a message containg
radio buttons and text areas that can be received back and stored in
access.
Reading several posts, I can't decide wether to use :
html content containing html forms (but my form are displayed
correctly in web browser but not in outlook ! )
Word form ? (but how to do this?)
other sollution ?
Any help... |
| Is this possible? |
Tony C. |
1 / 1 |
08 Dec 2011 |
| Hi
I'm a newbie to Office development but not dot.net.
Is it possible to send appointments created in one program to
show up in a user's outlook calender who uses Exchange Server?
-I'm looking for someone to point me in the right direction....
(I would need to send appointments to different users, presumably with
their security credentials etc in order to get it to show up... |
| very embarrassing |
bill |
1 / 1 |
16 Nov 2011 |
| All,
Roughly a year ago I created "something" that runs in Outlook and will
send an email periodically if the circumstances are right. Well, it
works just great. I get the emails that I expect on a regualr basis.
Unfortunately, now I CANNOT FIND the code!. When pressing Alt F11 and
checking thru the project, it just is not there.
I spent an hour or two today trying to remember what... |
| Microsoft Excel VBA Professional Projects |
Tiger |
1 / 1 |
14 Oct 2011 |
| Microsoft Excel VBA Professional Projects
Description:
Microsoft Excel VBA Professional Projects
Publisher: Course Technology PTR | ISBN: 1592000657 | edition 2003 |
CHM | 744 pages | 13.5 mb
Microsoft Excel VBA Professional Projects illustrates and teaches
intermediate to advanced techniques in VBA programming using
Microsoft's Excel spreadsheet application. It provides an... |
| VBA API for Outlook and Email managment |
duadinam |
1 / 1 |
08 Oct 2011 |
| Hello,
I'm working on a VBA application to log email correspondances in a
spreadsheet. I would like to be able to export email conversations
along with dates, and other ppl involved in the conversation in a
spreadsheet. Anytime an email is sent to or from select address
Outlook will update this spreadsheet.
What is the best way to go about this? Is this possible and what
API's,... |
| MSG file attachment is not picked by Javascript‏ |
sleepyrajesh |
1 / 1 |
16 Sep 2011 |
| Hi,
Whenever we attach a '.MSG' file from Outlook, its extension doesn't
appear. Whereas if mail is sent to outlook from mail client other than
Outlook , the file's extension is displayed.
Does Outlook consider MSG file as a normal attachment?? Please guide
me.
Thanks in advance.
Rajesh... |
| Copy From Email to BCC field |
HammerJoe@gmail.com |
1 / 1 |
19 Jul 2011 |
| Hello,
Can someone help with my issue.
Everytime I write an email I need to copy the FROM email (I use
different mailboxes) into the BCC field to have a copy of it in the
mailbox.
It would be nice that everytime I create a new email or reply to one
to have that done automatically.
Is that possible and how?
thank you.... |
| MAPIFolder/ActiveX Excel cannot find Outlook folder |
Andy |
2 / 2 |
06 Jul 2011 |
| I used some simpler code to see if Excel can find Outlook but still no
luck...
"Microsoft Outlook 12.0 Object Library" reference is ticked.
Sub OutlookTest()
On Error Resume Next
gOutlookApplication = GetObject(, "outlook.application")
If gOutlookApplication Is Nothing Then
Err.Clear
gOutlookApplication = CreateObject("Outlook.application")
End If
If gOutlookApplication... |
| Can't open a FileDialog in outlook |
Peter Sellmeijer |
1 / 1 |
24 Jun 2011 |
| From a macro i do want to open a filedialog.
In the Help i can find a example:
'Declare a variable as a FileDialog object.
Dim fd As FileDialog
'Create a FileDialog object as a File Picker dialog box.
Set fd = Application.FileDialog(msoFileDialogFilePicker)
The last line gives in outlook an error.
But in Excel it works fine.
Why?
Is there an alternative for... |
| Outlook 2007 VBA code won't run in Windows 7 |
Azonei |
1 / 1 |
18 Jun 2011 |
| I created a rule to run a custom VBA script to parse incoming emails
for specific items and add the data to an Excel workbook. I wrote and
tested the code in Outlook 2007 on a WinXP machine (SP3) and
everything worked perfectly. When I deployed the macro to the target
machine (Outlook 2007 on Windows 7), the VBA code is not running at
all. I verified this by removing all of the code and... |
| Rule to Auto-Accept Calendar Invites from select emails |
Howard Solovei |
3 / 3 |
17 Jun 2011 |
| Did you ever get resolution on this. I am trying to do the same thing.
Thanks,
Howard
> On Saturday, August 16, 2008 6:12 AM w.sham wrote:
> Hey,
>
> I'm trying to set up a rule in Outlook 2003 that automatically accepts
> any calendar invite from a select list of emails. I can set up the
> rule to only apply to Calendar Invites, and only for select people,
> but the Accept... |
| save after send in personal folder |
Dima |
1 / 1 |
15 Jun 2011 |
| Hi all,
I'm trying to write macro which picks a folder from personal folders
ans save a mail after it is sent instead of in "sent" box.
the problem is, that it works fine as long as I pick the folder from
Mailbox and not from personal.When I pick a folder from personal
folder, the mail stays in sent items folder.
this is may code:
Public Sub SendAndSave()
Dim obj As Object
Dim Mail... |
| view.GoToDate working inconsistently |
Adam and Kelly MacKenzie |
1 / 1 |
27 May 2011 |
| I'm attempting to automate a calendar pull to populate a product we
use (and manually update) extremely regularly. It's essentially 3
screenshots of 3 days of calendars. I'm using various win32 api calls
to find the handle of the active calendar explorer (usually have a
separate window open since I'm monitoring several shared calendars),
pass the focus to that window and grab a screenshot.... |
| Attach Files to a message - loop through subdirectory |
Harvey Richardson |
2 / 2 |
26 May 2011 |
| Not sure this is the cleanest code, but I got it to work! Here it is
if anyone needs it:
Sub MyIMAPMacro()
Dim myFileName As String
thefilepath = "s:\scan\To IMAP\"
theemail = "email@me.com.au"
myFileName = Dir("" & thefilepath & "*.*")
Do While myFileName <> ""
Set myOutlook = CreateObject("Outlook.Application")
Set mymail = myOutlook.CreateItem(olMailItem)... |
| How do I add emails as attachments to a new email? |
McKilty |
2 / 2 |
16 May 2011 |
| I saw this post...
http://www.pcreview.co.uk/forums/send-existing-email-attachment-using-vba-t3726344.html
...and now I think maybe my code as written should work. However, it
doesn't. I tried many different ways to write this:
objOutlookMsg.Attachments.Add (SafeMail.Item) 'Runtime error
-2146697203. The operation failed.
objOutlookMsg.Attachments.Add SafeMail.Item 'Runtime... |
| How can I send task request using vCalender/VTodo component using C# |
Manu |
1 / 1 |
10 May 2011 |
| I am writing a separate application to send task requests to the
client using simple mail. Then the emails should be added to the mail
box task list box in MS Outlook.
Here I have used vCalender/vTodo format to set values . But when I
send the email it is not sending as a task request and it displays as
an email but it is not added to the task list box. That is the
question I have.
1.... |
| StartTimezone returns Standard Time during Daylight Saving Time |
American since 1749 |
1 / 1 |
25 Apr 2011 |
| When run with an appointment as the current item, the code below
prints "Eastern Standard Time" for an appointment created today,
starting and ending later today, during Daylight Saving Time. Both
Windows and Outlook are correctly set to Eastern Time; Windows is set
to adjust automatically for Daylight Saving Time (I cannot find a
separate option for this in Outlook 2010, though I'm sure... |
| converted from outlook2003 to outlook2007, thismessageitem automatic process |
nina |
1 / 1 |
04 Apr 2011 |
| All of our office systems were upgraded from outlook2003 to outlook2007
I used to run for each incoming email, a short vba code that would simply
log the headers to a drive but can't remember now how I initialized it?
Can someone help me?
Basically, I want to run a simple piece of vba code, similar to snippet
below and have this run for every incoming email
I inserted the code... |
| Can't get a response and can't access my VBE in Outlook 2010 anymore! |
Youie |
1 / 1 |
20 Mar 2011 |
| Hi, I'm totally dazed and confused about this. My Outlook 2010 has
just woken up one day and decided it won't allow me to access the VBE
either through the toolbar or with Alt-F11. Can anyone give me any
clue at all, please?... |
| vbaproject.otm ignored when outlook.exe started by another process |
Yorkie |
1 / 1 |
11 Mar 2011 |
| Hi,
I have a macro saved in vbaproject.otm, which is distributed across
all users at my firm. This works fine when using Outlook and has been
for a few years.
We recently installed a new telephone system at my firm and with it
some desktop software which can read Outlook contacts and dial them.
This application is launched at startup for every user.
The problem with it is,... |
| Automatically add signature with different mailboxes in the sameexchange server |
HammerJoe@gmail.com |
2 / 2 |
08 Feb 2011 |
| ... |
| outlook used as frontend for Access |
Uwe Fechner |
1 / 1 |
08 Feb 2011 |
| Hi,
I would like to create in Outlook in the Folder view an entry in which
then displays in the list view a table from Access.
The entry in the folder view to be bold, and as a figure behind it's
the number of rows of the DB, which have been added new.
I googled already quite long after that, but there is nothing to.
Now I can create search folders (also vb) but I can define a search... |
| How can I open an Excel Workbook from an Outlook macro andactivate that workb... |
brightenmyoutlook |
2 / 2 |
26 Jan 2011 |
| ... |
| Select Outlook signature based on From: field email address |
Thomas |
1 / 1 |
25 Jan 2011 |
| Hi,
I'm working in an IT support environment and am connected to 5 different email accounts (all under the same Outlook profile).
I manually change the From: email address to reflect which mailbox I'm using. I'm now looking for a way to automatically change the email signature based on the email address specified in the From:.
Like if I send an email from addres1@company.com Outlook... |
| Searching for emails in MS outlook public folders |
Dimithri |
1 / 1 |
11 Jan 2011 |
| Hi,
Does anyone know how to search for emails located within public
folders in MS outlook?
We store all emails in public folders so everyone can access them but
when I try to find something its a nightmare. I've tried the MS
outlook search but it always returns 0 results even when I know its
there.
I've heard google desktop can search emails but can it search within
public... |
| Macro & buttons to reply Dear - new idea (Outlook 7) |
Mark |
1 / 1 |
13 Dec 2010 |
| I wish to develop my idea further and need help - I've been playing
with it but I'm not an expert
Presently I fire up the below macro when I have an email highlighted
and it enters the "Dear Joe" etc in the email body.
I'm wondering if it would be possible to apply this slightly
differently. To start an email i.e. new or click reply, ensure that
there is a recipient in the 'To' box, e.... |
| Problem in creating outlook task remotely using outlook object mod |
veenu |
7 / 7 |
02 Dec 2010 |
| rujuta_l wrote on 07/24/2009 02:58 ET :
> Yes. Receiver has given author permission to the sender for his task folder.
> Exchange server can be either 2003 or 2007.
> The application is hosted on 2003 server (name of the server is svr03) .
> Outlook on the server is configured with some email account e.g.
> txtAdmineMailID.Text is readonly textbox and contains this
> email id i.e.... |
| Sending e-mails with different name display |
Richard |
1 / 1 |
01 Dec 2010 |
| I would like to write a script for a mass mailing that has "Client
Accounts" as the from name rather than my name. Is this possible? I
don't see anything that would allow this.
Thanks in Advance.
Rich... |
| How to get the fullpath of the *.pst's in the current profile? |
Sebastian Wain |
2 / 2 |
23 Nov 2010 |
| ... |
| Manipulate subject property of new email on change |
nnichols |
1 / 1 |
17 Nov 2010 |
| Hi All,
I hate posting without at least having a starting point but I am
absolutely clueless on this one. When a user enters an eleven or
thirteen digit number into the subject I would like to do some
processing on it.
We use a barcode scanner to enter an eleven digit number into the
subject line which is then manually reformatted to remove the last
digit (a check digit) and add a... |
| SEX Videos of SCARLETT JOHANSSON |
jackson11 |
1 / 1 |
11 Nov 2010 |
| Due to some Restrictions i have Hidden the VIDEOS ........ CLICK on
the IMAGE which is below SEARCH BOX for VIDEOS http://hotactress4u.4-all.org... |
| Saving attachments to folder from public folder |
Andy |
22 / 22 |
26 Oct 2010 |
| You've been more than helpful already - Thanks Ken... |
| Reading Member Of list from Global Address List |
Ken Slovak |
4 / 4 |
21 Oct 2010 |
| You can't get what you want using CDO 1.21, which is what you are using. You
would need to use an LDAP query against the Active Directory to get that
information. I'm not all that familiar with LDAP usage so I couldn't help
you with that.
If you were to use Redemption (www.dimastr.com/redemption) instead of CDO
you could get the RDOAddressEntry object from the GAL (RDOAddressList)... |
| Change category of original message upon reply |
OutdoorRuss |
5 / 5 |
18 Oct 2010 |
| Here's what I ended up with... seems to work great for me. - Russ
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As
Boolean)
'Declaration
Dim myItems, myItem, myAttachments, myAttachment As Object
Dim myOrt As String
Dim myOlApp As New Outlook.Application
Dim myOlExp As Outlook.Explorer
Dim myOlSel As Outlook.Selection
Dim Response As... |
| how do I paste Excel clipboard cells to Outlook Word Editor and send it out u... |
Ken Slovak |
2 / 2 |
05 Oct 2010 |
| Outlook doesn't have any methods for using the clipboard, and VBA doesn't
provide any clipboard methods as VB6 would. You will need to review the
methods for using the clipboard using the Win32 API calls for the clipboard.
There is code for that in VB6 that you can modify to use in VBA at Randy
Birch's Web site and code samples at www.mvps.org. You can also search on
the Web for VB6... |
| Outlook 2003 Addin loading but not showing up in ComAddins list |
Ken Slovak |
10 / 10 |
05 Oct 2010 |
| Again, I haven't been using the VS 2010 installer so it may be different.
In other versions you right-click on the setup project and select to view
the registry settings. You then add your registration information for the
addin at either HKCU or HKLM or to User/Machine Hive. If the registration is
for User/Machine Hive it will be placed in either HKCU or HKLM depending on
whether the... |