Send Emails with pictures in the body and also with attachments of your choice .

thank you

RoSoft_Steven

Hi Steven

erm not quite getting this

I want to add my logo into sendEmail

I've added a png into image file (set to small) and set it to share

looking at your DB  I have extracted what I think are 3 relevent lines.

to add into my into existing script (you lines as follows)

let log1 := first(select Settings).HTMLlogo1;
    let log1 := replace(log1, "{UL1}", shareFile(first(select Settings).Logo1));
        let body := replace(raw(Message), "{logo1}", if 'Include Logo 1 (from Settings Table)' then
            log1

If I change to suit me it won't accept or save the script

let log1 := first(select Quote_Chasing).xLogo;
let log1 := replace(log1, "{URL1}", shareFile(first(select Quote_Chasing).xLogo));
let body := replace(raw(Message), "{xLogo}", log1;

So clearly I am going wrong here or I have missed something important

you apper to have your logos with a formula field - is that right?

Do I use an image field to hold my logo as you are mention HTML? or simple drop my logo into rich text of something. Also I am not understanding the URL ref . ie i have not copied the url itself (yet?). New area for me so deffo need a bit of explanation and help to understand

full script

QuoteSentFlag := null;
let thisBody := first((select Quote_Chasing).xQuoteLetter);
let myAtt := QuoteImage;
let myAtt2 := first((select Contact_Mailing).Advert1);
let myEmail := userEmail();
let log1 := first(select Quote_Chasing).xLogo;
let log1 := replace(log1, "{URL1}", shareFile(first(select Quote_Chasing).xLogo));
let body := replace(raw(Message), "{xLogo}", log1;
thisBody := replace(thisBody, "{xFirst}", text(eContact));
thisBody := replace(thisBody, "{Customer Ref}", 'Customer Ref');
thisBody := replace(thisBody, "{Quote Description}", 'Quote Description');
thisBody := replace(thisBody, "{Quote Number}", text(QteNum));
thisBody := replace(thisBody, "{Quote Date}", text(QteDate));

sendEmail({
        from: myEmail,
        to: xEmail,
        cc: "test@118123456789.co.uk",
        subject: "Your promo/print quote" + QteNum + "from 118 Print",
        text: "Quote Updated",
        html: thisBody,
        attachments: [myAtt, myAtt2]
    })
 

RoSoft_Steven

So got up at 6am this morning and after some 4 hours of head scratching and much testing! I finally got there !

Heres my very cut down trial version

let thisBody := first((select Settings_Quotes).xQchaseLetter1);
let log1 := first(select Settings_Quotes).HTMLxLogo;
let log1 := replace(log1, "{UL1}", shareFile(first(select Settings_Quotes).xLogo));
let myEmail := userEmail();
thisBody := replace(thisBody, "{xFirst}", text(eContact));
thisBody := replace(thisBody, "{Customer Ref}", xName);
thisBody := replace(thisBody, "{Quote Description}", 'Quote Description');
thisBody := replace(thisBody, "{Quote Number}", text(QteNum));
thisBody := replace(thisBody, "{Quote Date}", text(QteDate));
thisBody := replace(raw(thisBody), "{xLogo}", log1);
sendEmail({
    from: myEmail,
    to: xEmail,
    subject: "We recently sent you a quote from 118 Print",
    text: "text",
    html: thisBody
})

and lovely test result !

At first - I was struggling because I see in your excellent DB  sample you use two tables one with a message and other with body in the archive and I had missed that and had assumed that "Message" was a reserved word as part of SendEmal/SMTP etc and also I am not composing all the message with one field printing instead to have a message letter that i call from another table. AND - I had complete missed your tab section field referencing the image sizing.

Also I bought a book on HTML5 (some time ago but never got around to reading - until now. However the fact remains. Steven without your usual help. I could not have achieved this.

Silly question tho. Given that the internet is all about HTML and given that sending emails is an everyday thing. Then why don't people like Ninox give us a special field ) ie field for logo(images) that will be used with email protocols etc - so you drop the logo into it and it creates an html code snippet !

Thank you as ever