Forum: Outlook and VBA
January 28th 10, 08:49 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 2,305
Copy Range of Cells from Excel
I have a range of cells on a spreadsheet that I want to copy to Outlook as
the body of the message. The range is 9 rows by 9 columns. Three rows have
data on them, and each row of data has 2 or 3...
|
|
Forum: Outlook and VBA
January 28th 10, 04:51 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 4
Views: 1,493
Setting Outlook Parameters in VBA
Hadn't thought about that - certainly a solution - I'll probably try that for
now. Just seems like somebody would have wanted to do this before and
someone would have found out how.
--
Bill @...
|
|
Forum: Outlook and VBA
January 28th 10, 02:11 AM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 4
Views: 1,493
Setting Outlook Parameters in VBA
All the answers I've seen refer to the signature - I have that part worked
out. But that doesn't give me the background and font I want.
--
Bill @ UAMS
"Michael Bauer [MVP - Outlook]" wrote:
|
|
Forum: Outlook and VBA
January 27th 10, 05:20 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 1
Views: 364
Range for Body of E-Mail
I am trying to use a range of cells in Excel as the body for an e-mail in
Outlook. The name for the range is 'DuesReceipt'. It doesn't seem to like
setting olBody to the range. Can someone...
|
|
Forum: Outlook and VBA
January 23rd 10, 05:40 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 4
Views: 1,493
Setting Outlook Parameters in VBA
I am using the following code to send e-mail through Outlook from Excel.
SigString = "C:\Documents and Settings\...\Signatures\Bill.txt"
If Dir(SigString) "" Then
Signature =...
|
|
Forum: Outlook and VBA
January 22nd 10, 01:58 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,056
Signature Folder
This is a separate folder, in addition to the *rtf, *htm, and *.txt files.
--
Bill @ UAMS
"Michael Bauer [MVP - Outlook]" wrote:
|
|
Forum: Outlook and VBA
January 21st 10, 02:22 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 3
Views: 1,056
Signature Folder
When you create a signature in Outlook, it creates a folder in the Signatures
folder (Docs and Settings\.....\Microsoft\Signatures) with three items -
colorschememapping, filelist, and themedata. ...
|
|
Forum: Outlook and VBA
January 20th 10, 11:56 PM Posted to microsoft.public.outlook.program_vba
|
|
Replies: 2
Views: 443
Using Outlook from Excel
I have a subroutine in Excel that sends out e-mails in Outlook. Works
perfectly, except that it doesn't use my standard layout (style) nor does it
insert a signature. Can anyone help me get that...
|
