Excel vba to create email - having a FROM (problem)

Hi all,

I have got some code that generates a new email as i want. The only problem is the FROM element.


In outlook i am connected to 4 Inbox's.

By default my Outlook is connected to MY personal works email address. But I need the email to be sent from the department email address.

So even though im putting the department email address in the - Email_Send_From = "DEPARTMENT EMAIL ADDRESS", it is still sending from MY personal email address.

At the minute when the email is generated I have to select the "FROM" dropdown and select the department email address.

Can anyone help?

Please Login or Register  to view this content.

Hi,

Try this (obviously changing the department email address)

Please Login or Register  to view this content.

Hi badlydrunkboy,

GENIUS!!! thank you so so so so much!

No worries at all. I recently had to use the exact same thing. Think i got it from http://www.rondebruin.nl/index.htm which is really usefull for vba around emails and attachments etc.

Just had a quick look for the help with attachments as i want to attach a PDF.

Please can you link me?

This one? http://www.rondebruin.nl/win/s5/pdf.htm

Cant figure it out, im trying to attach a pdf this is the code im trying.

It errors where red.

Please Login or Register  to view this content.

I'm afraid I've never used it myself. I'll try to have a look at it a bit later but it's propbably a better idea to ask someone else or start a new thread regarding attaching .PDFs to an email.

Sorry.