Excel with outlook - attachments

Hey guys,

Just having some trouble with some syntax. Basically my excel spreadsheet is sending an email out and I want the clickable button when clicked to ask which attachment should be added, so an open file dialog box.

I have written this code for the file dialog:

Please Login or Register  to view this content.

And the part of my Code that adds the recipient and attachments is:

Please Login or Register  to view this content.

Basically, the .Attachments.Add is where I am stuck, you can put a destination path in quotes and that works fine, but I want to run my other sub so that the user can select the file to attach.

Thanks in advance for any replies, info always greatly appreciated! If anyone has an alternative method I'm open to that also!

Liam

Hiya,

I have been coding a spreadsheet that can take information from within the sheet and place it into an outlook mail item.

My Code goes as follows:

Please Login or Register  to view this content.

This code creates an outlook message and displays it to send. My problem is that when the code gets to:

Please Login or Register  to view this content.

I want it to be a selection instead of typing the path to the file (mainly so that the spreadsheet can be moved from PC to PC).
So I need an open file dialog for which this code is written:

Please Login or Register  to view this content.

This works fine but what I want to do is integrate it into the above code so that the user is asked to select the attachment to add.

So Does anybody know how to integrate my 'Get_Data' Sub procedure into the attachment.add command. or another way of doing this?

Thanks in advance!

Hi, thanks for your reply

I want to attach a new file, such as a word document.

I'm trying to stay away from:

Please Login or Register  to view this content.

Which would add current sheet, instead want the user to be able to browse for whichever file they want, be it on desktop or in my documents