Re: Attachment code won't work
From: Ray (mym4junk_at_hotmail.com)
Date: 02/01/05
- Next message: devlei: "Re: Filling a UserForm ComboBox with Calendar items"
- Previous message: Ray: "Re: Attachment code won't work"
- In reply to: Eric Legault [MVP - Outlook]: "RE: Attachment code won't work"
- Next in thread: Sue Mosher [MVP-Outlook]: "Re: Attachment code won't work"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Feb 2005 12:50:18 +0800
Thanks Eric
Sue's suggestion has done the trick. I don't understand why but it is
working. See response to her post.
Many thanks for taking the time to respond.
Ray
"Eric Legault [MVP - Outlook]" <elegaultZZZ@REMOVEZZZmvps.org> wrote in
message news:57698A6A-0414-4314-AAEE-3FEA095A1A83@microsoft.com...
> Could you please show all of your relevant code? A lot of variable
> declarations are missing, so it is difficult to troubleshoot without them.
>
> It might be as simple as the double dot in "..Attachments.Add". Also,
> what
> is a sample value from the [fsfrSupportersMessage].[Form]![fAttachment]
> field?
>
> Can you compile your module without errors?
>
> --
> Eric Legault - B.A, MCP, MCSD, Outlook MVP
> --------------------------------------------------
> {Private e-mails ignored}
> Job: http://www.imaginets.com
> Blog: http://blogs.officezealot.com/legault/
>
> "Ray" wrote:
>
>> Hi
>>
>> I posted this in a access group and then later read a response to another
>> question that made me realise I should have posted here. Sorry about the
>> double post.
>>
>> I have been trying to modify some code I picked up from
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/odc_ac_olauto.asp
>>
>> I am uing Office 2003
>>
>> I have modified most of it to run referencing my form but the attachment
>> section doesn't work properly. I hope someone can help me
>>
>> The original code section is as follows
>>
>> ' Add attachments to the message.
>> If Not IsMissing(AttachmentPath) Then
>> Set objOutlookAttach = .Attachments.Add(AttachmentPath)
>> End If
>>
>> When I first tested the code as the web article suggested it worked fine
>> but
>> now that I have modified it to read from my form it doesn't work
>>
>> ' Add attachments to the message.
>> If Not IsNull([fsfrSupportersMessage].[Form]![fAttachment]) Then
>> Set objOutlookAttach =
>> ..Attachments.Add([fsfrSupportersMessage].[Form]![fAttachment])
>> End If
>>
>> No matter what I try objOutlookAttach always show as being
>> "objOutlookAttach = Nothing" Yet when I point at
>> ([fsfrSupportersMessage].[Form]![fAttachment]) the correct path is
>> reported.
>>
>> The error message reads "438 Object doesn't support this property or
>> method"
>>
>> Please I am confused and can't seem to see my way forward on this one.
>> Any
>> help would be very much appreciated.
>>
>> Ray
>>
>>
>>
- Next message: devlei: "Re: Filling a UserForm ComboBox with Calendar items"
- Previous message: Ray: "Re: Attachment code won't work"
- In reply to: Eric Legault [MVP - Outlook]: "RE: Attachment code won't work"
- Next in thread: Sue Mosher [MVP-Outlook]: "Re: Attachment code won't work"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
