|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
July 11th 07, 04:24 PM
posted to microsoft.public.outlook
|
|||
|
|||
Copy from Excel and Paste into Outlook
Hi all,
I am trying to automate the following procedure, but I have no clue as how to do it. Could you please advise? I have a spreadsheet, and I want to copy the contents of a Range, WITH formatting, and paste them into an HTML Email on Outlook. How do I do it with VBA? Thanks Alessandro 
|
|
#2
July 11th 07, 05:06 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
Copy from Excel and Paste into Outlook
One method that might help is documented he http://www.outlookcode.com/threads.a...essageid=20232
Also, the method shown here -- http://www.outlookcode.com/codedetail.aspx?id=1333 -- is for Word, but can also be used in Excel. You could, for example, copy and paste the desired range to a new worksheet then send it with this technique. FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/comm....program_v ba -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "thearch" wrote in message oups.com... Hi all, I am trying to automate the following procedure, but I have no clue as how to do it. Could you please advise? I have a spreadsheet, and I want to copy the contents of a Range, WITH formatting, and paste them into an HTML Email on Outlook. How do I do it with VBA? Thanks Alessandro
|
|
#3
July 11th 07, 06:01 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
Copy from Excel and Paste into Outlook
Thanks a lot!
It seems like it works...
|
|
#4
July 11th 07, 07:32 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
Copy from Excel and Paste into Outlook
On 11 Jul, 18:01, thearch wrote:
Thanks a lot! It seems like it works... Do you have an idea about why images on the mail do not show up?? Thanks again
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VBA Clipboard Cut & Paste from Excel to Outlook | andy | Outlook and VBA | 15 | May 14th 08 06:32 AM |
| Outlook 2003 Copy & Paste Strangeness - Destination Must be Open Prior to Copy | [email protected] | Outlook - General Queries | 0 | March 14th 07 05:34 AM |
| How do I copy and paste an appointment in Outlook? | BrowningC | Outlook - Calandaring | 1 | February 22nd 07 02:22 AM |
| Paste an Excel Chart in an Outlook Body | [email protected] | Outlook and VBA | 1 | September 27th 06 05:39 AM |
| Outlook calendar should allow right-click copy & paste of items | Nightkrawler | Outlook - Calandaring | 0 | July 27th 06 02:17 PM |
Hybrid Mode
