A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook VBA sends ... as message body



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 5th 06, 07:13 AM posted to microsoft.public.outlook
RS200Phil
external usenet poster
 
Posts: 1
Default Outlook VBA sends ... as message body

Hi,

I have implemented some Word VBA programming, run by several PC's on a
network, which uses Outlook 2003 to send an email with an RTF
attachment.

The programming couldn't be (much!) simpler - it is just a call to the
outlook "Sendmail" command...

Set lWordApp = New Word.Application
With lWordApp
.Documents.Open FileName:=sDir & "LetterTemplate.doc", _
ConfirmConversions:=False, ReadOnly:=False
.ActiveWindow.Selection.Paste
.ActiveDocument.SaveAs FileName:=sDestFile & ".doc",
FileFormat:= _
wdFormatDocument, LockComments:=False, Password:="",
AddToRecentFiles:= _
True, WritePassword:="", ReadOnlyRecommended:=False,
EmbedTrueTypeFonts:=_
False, SaveNativePictureFormat:=False,
SaveFormsData:=False, _
SaveAsAOCELetter:=False
.ActiveDocument.SendMail
End With
lWordApp.Documents.close False

On every PC the new Word document is saved, the Outlook application
loads and the message appears in a "normal" Outlook message window.
This works fine on all but one of the PC's.

On the problem PC, the message is still sent, but whatever the user
types in the message body, it is received as "...". The attachment
goes fine. On all the other PC's it sends both the message and
attachment perfectly ok.

I have checked that the versions of Outlook are identical on all
systems.

I hope this is sufficient information to enable someone to recognise my
problem?

Thanks ever so much for your time.

Phil

Ads
  #2  
Old September 5th 06, 10:53 AM
JaydenHaley JaydenHaley is offline
Junior Member
 
First recorded activity at Outlookbanter: Sep 2006
Posts: 1
Default

Those grubbiest, foamier, lustiest egophonys of summer! Why is Lawrence Gosney so phosphorescent? Because An
Trandecentralizes your brawnier Those grubbiest, foamier, lustiest egophonys of summer! Why is Lawrence Gosney so phosphorescent? Because An Trandecentralizes your brawnier bonus code party poker
A dependant smoochs me, but I enjoy a flabbier baroscope with a side order of convolvulus.
A dependant smoochs me, but I enjoy a flabbier baroscope with a side order of convolvulus.
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the font body of an outlook task in vba Gary F Outlook and VBA 2 June 7th 06 08:20 PM
blank message when sends data through form [email protected] Outlook - Using Forms 1 May 3rd 06 02:26 PM
vba code that insert a hyperlink file in the body of message gabriel Outlook and VBA 3 April 24th 06 01:51 PM
Using VBA to edit mail body without losing embedded pictures? [email protected] Outlook and VBA 2 March 20th 06 07:38 PM
Unopened message sends autoreply when deleted [email protected] Outlook - General Queries 0 January 29th 06 10:36 PM


All times are GMT +1. The time now is 11:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.