Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default (Email code) Strange sned/receive problems Help ??

I have the below code to send a range of cells, including any images in the range in the body of an email.

Sub Send()
ActiveSheet.Range("A51:P103").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "This is a sample worksheet."
.Item.To = Range("J64")
.Item.CC = Range("J65")
.Item.Subject = Range("B1")
.Item.Send
End With
End Sub

If I place this in a NEW Workbook and run it from a button it works fine.
It uses Outlook and places a copy of the sent email in the SENT items, AND the email arrives complete with the image on it.
BUT, if I:


Run the above(same) code in the workbook I have set up with numerous other macros, it sends, but
I get NO copy in the SENT ITEMS and NO IMAGE when it arrives.

I tried placing ALL the macros I have into 1(one) Module, to no avail.
I Tried placing each macro into it's own Module, to no avail.
I tried disabling each macro 1 x 1 to no avail.

What else could be affecting this?
Has anyone had similar behaviour?

How do I rectify it?

Corey....
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
How do I calculate the percentage of email i receive over time Pearl[_2_] Excel Discussion (Misc queries) 1 April 17th 10 09:13 PM
Strange problem with Code PH NEWS Excel Worksheet Functions 1 September 27th 06 10:16 AM
Strange problems with setting hidden property of a range when sheet protected with UserInterfaceOnly [email protected] Excel Programming 2 June 6th 06 04:15 PM
excel close everytime I receive an email with lotus notes 6.5.5 sigh Excel Discussion (Misc queries) 0 May 31st 06 06:53 AM
Strange code showing up in Immediate Window tod Excel Programming 3 March 5th 04 09:37 PM


All times are GMT +1. The time now is 12:45 PM.

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

About Us

"It's about Microsoft Excel"