Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Sending data to Outlook for emailing

Hi,

I have the u/m code that send some data to OUTLOOK, it
works fine on my computer, but the other people in my
office are unable to get it to work. We are all running
the same equipement. I understand that there is a limit of
number charaters that can be sent.

The error message the others get (that I don't receive) is
as follows:

"Could not preform this operation because the default mail
client is not properly installed" Once you press OK it
opens OUTLOOK, creates part of the message and then goes
jibb-er-iss, simular to when you try and send too many
charaters.

I have try re-installing outlook on all machines, but this
does not make any difference. I find it strange that it
works on my machine, and noby elses???? I have attached
part of the code in the hope someone can see my mistake.

Many tahnsk for your assistance.

[[[[[ CODE ]]]]

Recipient = Selection.Offset(0, 1)
GoTo start

'======

start:

Subj = "ESTIMATE PORT DISBURSEMENTS"

Msg = Msg & "%0A" & "ITEM"
Msg = Msg & "%0B" & "----"
Msg = Msg & "%0B" & "MARINE NAV. LEVY" & " " &
UserForm3.Label12
Msg = Msg & "%0B" & "OIL POL. LEVY" & " " &
UserForm3.Label16
Msg = Msg & "%0B" & "CONS. DUES" & " " &
UserForm3.Label14
If UserForm3.Label20 0 Then Msg = Msg & "%0B"
& "PILOTAGE" & " " & UserForm3.Label20
If UserForm3.Label24 0 Then Msg = Msg & "%0B" & "TOWAGE"
& " " & UserForm3.Label24
If UserForm3.Label28 0 Then Msg = Msg & "%0B"
& "LINESMEN" & " " & UserForm3.Label28
If UserForm3.Label32 0 Then Msg = Msg & "%0B" & "LINES
LAUNCH" & " " & UserForm3.Label32
Msg = Msg & "%0B" & "BERTHAGE" & " " & UserForm3.Label54
If UserForm3.Label36 0 Then Msg = Msg & "%0B"
& "PRATIQUE" & " " & UserForm3.Label36
If UserForm3.Label37 0 Then Msg = Msg & "%0B" & "REFUSE
REMOVAL" & " " & UserForm3.Label37
If UserForm3.Label42 0 Then Msg = Msg & "%0B"
& "SECURITY" & " " & UserForm3.Label42
If UserForm3.Label46 0 Then Msg = Msg & "%0B" & "VRP"
& " " & UserForm3.Label46
If UserForm3.Label50 0 Then Msg = Msg & "%0B"
& "SURVEYS" & " " & UserForm3.Label50
If UserForm3.Label58 0 Then Msg = Msg & "%0B" & "PORT
SUNDRIES" & " " & UserForm3.Label58
If UserForm3.Label62 0 Then Msg = Msg & "%0B" & "SHIP
SUNDRIES" & " " & UserForm3.Label62
If UserForm3.Label66 0 Then Msg = Msg & "%0B" & "AGENCY
FEE" & " " & UserForm3.Label66
If UserForm3.Label70 0 Then Msg = Msg & "%0B" & "AGENCY
SUND." & " " & UserForm3.Label70
If UserForm3.Label78 0 Then Msg = Msg & "%0B" & "OTHER"
& " " & UserForm3.Label78
Msg = Msg & "%0B" & "====="
Msg = Msg & "%0B" & "TOTAL (AUSD)" & " " &
UserForm3.Label74
Msg = Msg & "%0B" & "TOTAL GST (AUSD)" & " " &
UserForm3.Label76

Msg = Application.WorksheetFunction.Substitute(Msg, " ", "%
20")

HLink = "mailto:" & Recipient & "?"

HLink = HLink & "subject=" & Subj & "&"
HLink = HLink & "body=" & Msg
ActiveWorkbook.FollowHyperlink (HLink)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending Excel through Outlook MsNat Excel Discussion (Misc queries) 1 October 21st 09 10:11 PM
Meeting Request Outlook XP sending to some Ailish Excel Discussion (Misc queries) 1 May 9th 08 01:08 PM
Sending notifications through outlook Doberman Excel Discussion (Misc queries) 2 May 6th 07 04:26 PM
How do I get Excel to use my normal Outlook profile when emailing Ericthesailor Excel Discussion (Misc queries) 0 September 8th 05 10:54 AM
Macro Emailing an XLS via Outlook ynissel Excel Discussion (Misc queries) 5 May 26th 05 09:56 PM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"