Macro to attach a file to out going emails?

[THTABE]

I have a macro set up to send personalized emails to my mailing list and need it to attach a PDF be for sending it. Is there a way to do this? Bellow you can see my current macro. Thanks!

Please Login or Register  to view this content.

[mehmetcik]

Sorry I am not going to look at your file.

I use this below:-

It copies some data into the body of the Email and also attaches a file.

Please Login or Register  to view this content.

[THTABE]

mehmetcik

I do appreciate your offering help. Unfortunately for me, what you have offered is well above my head. Could you possibly narrow it down to the few parts I need to add to what I have already done?

[Arkadi]

Please Login or Register  to view this content.

where TempFileName is the full path\filename of the file you want to attach

[mehmetcik]

I am sorry I found this on line a few years ago and modify it to do what I need.

Cut out the bits that you do not need until you are down to the bare bones. Thats what I do.

I will cut out the parts that I do not think you need to help.

Please Login or Register  to view this content.

[THTABE]

Thanks Arkadi but I am getting a Syntax error. Any thoughts?

Please Login or Register  to view this content.

[Arkadi]

try:

Please Login or Register  to view this content.

(the quotes around the filename is what I added)

[THTABE]

Worked perfectly Arkadi! Thank you very much.

[Arkadi]

You're welcome
Please remember to mark the thread as solved if you are satisfied? Thanks!

And thanks for the rep.

[zbor]

THTABE,

Please use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window.

I've fix it now for you.