Why can't 2003 handle the macros I wrote for 2000

  • Thread starter Thread starter cinnamngrl
  • Start date Start date
Status
Not open for further replies.
C

cinnamngrl

The shut down usually happens around opening a balloon.

This is a macro that I use to selectively merge contacts.
 
What do you mean by "opening a balloon"? What happens when you step through

the code in the debugger?

Sue Mosher

"cinnamngrl" <cinnamngrl@gmail.com> wrote in message

news:f7c55a50-0039-4d2a-a3f3-bc11173be746@f5g2000yqh.googlegroups.com...
> The shut down usually happens around opening a balloon.

> This is a macro that I use to selectively merge contacts.
 
On Jan 9, 8:10 am, "Sue Mosher [MVP]" <sue...@gmail.com> wrote:
> What do you mean by "opening a balloon"? What happens when you step through
> the code in the debugger?
> > Sue Mosher
>    >      >    
> "cinnamngrl" <cinnamn...@gmail.com> wrote in message

> news:f7c55a50-0039-4d2a-a3f3-bc11173be746@f5g2000yqh.googlegroups.com...
>
> > The shut down usually happens around opening a balloon.

>
> > This is a macro that I use to selectively merge contacts.


Sigh. I don't you remember me, sue but i'm the dork that taught

themselves to write macros by cutting and paste ing from the help

file.

So tell me about stepping through. it is the assistant balloon that

takes you through a selection process with my contacts. here I am

looking for contacts with different names and the same work phone.

Set inq = Assistant.NewBalloon

With inq

> Heading = "Available in Contacts for " & vwork

> Text = "Select one to delete"

For i = 1 To vnumber.Count

> Labels(i).Text = "name " & vnumber(i) & Chr(13) & "work # " &

vnumber(i).BusinessTelephoneNumber & Chr(13) & "home # " & vnumber

(i).HomeTelephoneNumber & Chr(13) & "email " & vnumber

(i).Email1Address & Chr(13) & "user1 " & vnumber(i).User1

Next

> Button = msoButtonSetOK

End With

Select Case inq.Show

Case 1

vnumber(1).Delete

Case 2

vnumber(2).Delete

Case 3

vnumber(3).Delete

Case 4

vnumber(4).Delete

Case 5

vnumber(5).Delete

Case Else

vcombine = True

End Select
 
Thanks for the additional information.

To step through code in VBA, use the F9 key to set a breakpoint, where code

execution will stop. Then, run the macro. After execution hits the

breakpoint, continue by pressing F8 to execute each statement. In all

likelihood, you'll see where the problem is occurring or where your code

logic isn't quite right.

Assistant is a hidden object in the Outlook object model, and I've never

seen any successful Assistant code for Outlook. If it's making Outlook

crash, I'd seek another approach, i.e. a regular VBA userform.

Sue Mosher

"cinnamngrl" <cinnamngrl@gmail.com> wrote in message

news:b3b0e442-86a1-4f89-95d1-541c3a53ea28@f6g2000vbp.googlegroups.com...

On Jan 9, 8:10 am, "Sue Mosher [MVP]" <sue...@gmail.com> wrote:


> What do you mean by "opening a balloon"? What happens when you step
> through
> the code in the debugger?

> "cinnamngrl" <cinnamn...@gmail.com> wrote in message

> news:f7c55a50-0039-4d2a-a3f3-bc11173be746@f5g2000yqh.googlegroups.com...
>
> > The shut down usually happens around opening a balloon.

>
> > This is a macro that I use to selectively merge contacts.


Sigh. I don't you remember me, sue but i'm the dork that taught

themselves to write macros by cutting and paste ing from the help

file.

So tell me about stepping through. it is the assistant balloon that

takes you through a selection process with my contacts. here I am

looking for contacts with different names and the same work phone.

Set inq = Assistant.NewBalloon

With inq

> Heading = "Available in Contacts for " & vwork

> Text = "Select one to delete"

For i = 1 To vnumber.Count

> Labels(i).Text = "name " & vnumber(i) & Chr(13) & "work # " &

vnumber(i).BusinessTelephoneNumber & Chr(13) & "home # " & vnumber

(i).HomeTelephoneNumber & Chr(13) & "email " & vnumber

(i).Email1Address & Chr(13) & "user1 " & vnumber(i).User1

Next

> Button = msoButtonSetOK

End With

Select Case inq.Show

Case 1

vnumber(1).Delete

Case 2

vnumber(2).Delete

Case 3

vnumber(3).Delete

Case 4

vnumber(4).Delete

Case 5

vnumber(5).Delete

Case Else

vcombine = True

End Select
 
Ok, It makes sense to switch to user forms.

I have created userforms and run them from macros but how do change

variables for labels and for the vb code in the form? do I need to

write a macro that creates a userform?
 
Each control in the userform can be accessed in VBA code by name, e.g.

TextBox1, and its properties changed.

Sue Mosher

"cinnamngrl" <cinnamngrl@gmail.com> wrote in message

news:aa53e0b4-3f30-41c7-ab26-bf38e3e1f0b8@35g2000yqa.googlegroups.com...
> Ok, It makes sense to switch to user forms.

> I have created userforms and run them from macros but how do change
> variables for labels and for the vb code in the form? do I need to
> write a macro that creates a userform?
 
Ok I made the switch and it works great thank you

Sue Mosher [MVP] wrote:
> Each control in the userform can be accessed in VBA code by name, e.g.
> TextBox1, and its properties changed.
> > Sue Mosher
> > >

> "cinnamngrl" <cinnamngrl@gmail.com> wrote in message
> news:aa53e0b4-3f30-41c7-ab26-bf38e3e1f0b8@35g2000yqa.googlegroups.com...
> > Ok, It makes sense to switch to user forms.
> > I have created userforms and run them from macros but how do change
> > variables for labels and for the vb code in the form? do I need to
> > write a macro that creates a userform?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Outlook 2003 stopped dead Using Outlook 2
D Outlook 2021 not working with Outlook 2003 installed Using Outlook 5
D Outlook 2003 stopped working - get they dialog box asking for username & Password Using Outlook 2
D Wishlist How to use 'app password' in Outlook 2003 after Google pulled plug on "less secure apps" Using Outlook 2
J Outlook 2003 .pst Will Not Restore Completely to Outlook 2019 Using Outlook 5
D Outlook 2003 Mail Fails Using Outlook 1
D Wrong email address in Outlook 2003 "From" tab in new outgoing emails Using Outlook 4
V Outlook 2003 and Windows 11 Using Outlook 4
glnz Moving from Outlook 2003 to MS365 Outlook - need basics Using Outlook 4
I Outlook 2003 shows html code when To: field is empty Using Outlook 7
B Outlook 2003 email sending & receiving suddenly stopped working Using Outlook 3
H Outlook 2003 find by "has attachment" Using Outlook 1
glnz How set up new IMAP on Outlook-Office 365 and merge in pst from Outlook 2003 for same two email accounts? Using Outlook 5
P Import Categories from Outlook 2003 Using Outlook 8
V Outlook 2003 problem with Windows 10 Creators Update 1709 Using Outlook 0
M Outlook 2003 pictures - some visible, some not Using Outlook 0
S Outlook 2003 to Outlook 2013 pst file Using Outlook 5
O Memory Leak in Outlook 2003 Using Outlook 3
B 2013 to 2003 Exchange Server Administration 0
W Changing looks of emails in Outlook 2003 Using Outlook 0
O Outlook 2003 can't send, but settings seem OK Using Outlook 1
P URL Hyperlink not working correctly in Outlook 2003 Using Outlook 10
C 2003 OL to OneDrive People Using Outlook 1
O Outlook 2003 can't open contacts. Using Outlook 2
J Using 2003 .pst files w 2013 Using Outlook 1
O Promoting Outlook 2003 User Templates Using Outlook 1
M Can't open .pst file in Office 2003. Using Outlook 2
O W-a-a-y too many PSTs (Outlook 2003) Using Outlook 0
B Exchange 2003 EDB corrupt Exchange Server Administration 6
C Can't open .pst file in Office 2003 Using Outlook 1
J Outlook 2003-2010 PST Field Editor Using Outlook 1
P Outlook 2003 - Do I need a new profile? Using Outlook 2
E Want to Import Outlook 2003 pst files to later version Using Outlook 6
A error message outlook 2003 Using Outlook 1
B Seeking advice now Outlook 2003 is unsupported by Exchange Using Outlook 4
O Change Debit to Credit in Outlook 2003? Using Outlook 1
J problems downloading POP3 emails to Outlook 2003 Using Outlook 1
G Outlook 2003 VBA Won't Run In Outlook 2010 Outlook VBA and Custom Forms 4
P Macros in Word 2003 - how to transfer to another Word 2003? Using Outlook 1
P Outlook 2003 - possible to recreate corrupt account? Using Outlook 3
Calvyn Outlook 2003 cannot import .vcs subject Using Outlook 1
T Query about one aspect of migrating .pst files from Outlook 2003 to Outlook 2013 Using Outlook 5
C Outlook 2003 contacts Using Outlook 1
G Configuring Outlook 2003 for Gmail with both pop3 & imap4 accounts Using Outlook 1
M HELP--Extract Data from 2003 outlook transfer to excel spreadsheet Using Outlook 1
C Trying to move my Business Contact Manager ver. 2003 to BCM ver. 2010 Using Outlook 3
V Outlook 2003 editing problem Using Outlook 4
X Outlook 2003 not sending all of the new email message Using Outlook 1
D cleaning up old Exchange 2003 data on Exchange 2010 Exchange Server Administration 2
2 How to use outlook 2003 calendar in always offline mode Using Outlook 0

Similar threads

Back
Top