OutLook Attachment

[Stanley]

This is probably an Outlook question, but maybe someone can help be out here.
(I am using VBA to sent e-mails from a Access program).
I create an e-mail object MyMail.
I then set an attachment:
MyMail.Attachments.Add filename, olByValue, 1, "My Name"
My problem is my e-mail is identified by filename, not "My Name"

Also, another question I have is that the attachment shows as an icon. What
can I do to have the attachment box of the e-mail show in the e-mail heading
with the attachment showing there?
Thanks,
Stan

 

[Sue Mosher [MVP-Outlook]]

What are you trying to do with that code?

As for your second question, how the attachment appears in the message depends on the message format -- RTF vs. HTML or plain text.

 

[Stanley]

Attachments.Add adds an attachment to an email that I later send. I am
sending a group of e-mails where I attach different files (and different
filenames) to the emails. I would like the name of the attachment to be "My
Name" not the file name. The Attachments.Add gives me that option, but I
can't get it to work.
Thanks,
Stan

 

[Sue Mosher [MVP-Outlook]]

That option doesn't apply to attached files (there are other types of attachments). You would need to change the filename before you invoke Attachments.Add.