Sending an email NOT from default account

[Manc]

Good evening demigods,

I have the macro below working fine, but is there a way to send it from a different mail account rather than my defualt one? I'm using Outlook and obviously I realise that the "other" mail account would have to be set up on every PC using this code.

The reason being, I want to delete the print preview step of the code, and have the report sent autmatically with a message attached saying something along the lines of "generated from an automatic mail account. Please do not reply to this message."

I'm guessing I may have to approach the relms of VBA rather than Macro to achieve this.

Open Report
Report Name : rptQuote
View : Print Preview
Filter Name :
Where Condition: = [Forms]![frmQuote]![ClientID] = [tblQuote]![ClientID]
Window Mode : Normal
 
EMailDatabaseObject
Object Type : Report
Object Name : rptQuote
Output Format: PDF Format (*.pdf)
To : =[QuoteContactEmail]
Cc :
Bcc :
Subject : ="Quotation to " & [QuoteDestination]
Message Text : = "Dear" & [QuoteContactFirstName] & Chr(13) & Chr (10) & Chr (13) & Chr (10) & "Please find attached your quotation as requested."
Edit Message : Yes
Template File :

Any ideas or suggestions, greatly appreciated.
Kind regards
manc

 

[gemma-the-husky]

I haven't checked, but maybe there is a From: as well as a To: ?

 

[Dhamdard]

Well. I think, the coding you have done is dependant on Outlook. This coding doesn't have control over outlook to change sender's account. Maybe you would need to download "Total Access Emailer" or use CDO coding to send email through gmail account. You can search on Google for CDO Gmail email codes.

Hamdard