Search results

If I read this right create an email - but send it from another account? - that is not the one you are using - that seems a bit weird You can create an email say from Mickey Mouse - and the email trail will show it coming from Mickey Mouse - but you can change the signature - to pretty...

weird Is the tax static - ie - the same say 8 % or does it differ per item Boots @ 8% Shirts @ 15% If its the same - easy peesey - if it floats all over the place then that's a little trickier is it per items per sale or what so in your imaginary shopping basket Boots cost 100 * 5 pairs...

I've bailed out - vbaInet - can run rings round me - I can hack things together picked from various people - but anything creative .... regards G:o

my attachment table Location =S:\folder\sub folder\another subfolder1\filename.pdf Filename = name of the file Attachmenttblatuo= id number Filter = K

See if this helps anything in a [] is a field on the form Quoteform some of the [] i should of named properly anyway the bottom part EmailSend.Attachments.Add (Me.[Attach2a]) Attach2a = a field on my form that is a drop down list from a table that table has a location field on it Drive\...

Brain fried when asking the question.. will let you known how I get on G

Any pointers on how to stop this repeating ? G

Hey - update It pops a html file in to the first email - fine but them duplicates itself 2 - and 3 fold itself on the 3 - so if I send say 50 emails i will get the html in the last email 50 times - I think I need to clear the html.body rather than just the once .. hoep this makes sense G

oops .. I give that a try - might be a couple of days before I can get back to confirm all ok - long weekend - going to Norway ... so thanks in advance .. G

where would I put this ?

Hey everyone - thanks for your help - this works a treat but now I want to enhance it what i want to do is inset a html file into the body of the email I have created a publisher file and saved as html ..say C:\test\pub1.html :banghead: how do I get this in to the body ? code to date...

Well blow me down as simples as Pbaldy said Thanks to you both what i will do is get this tidied up (I putting an email function in as well) and put it up as a sample Big thanks G

cheers I try that - it late here UK time one for Monday G

a very bland heading I know I have this report that needs to be export - 1 report per record the report exports out but its the same record export out each time ( the name changes - but the data doesn't) i am sure it simplies - but not seeing it ? (I have tried the code down - as there was a...

OK Guys i have cocked up (no surprise there) i have a table with 10 records in it and i want the export to do 10 exports of 1 record each currently i am getting 10 exports with 10 records where have i lost it ? (I know the email element will need changing as this doesn't work this way)...

OK guys almost there (I have "borrowed" from all over the place ) my loop names the file - good I have an email sending out its the attachment that got me foxed Private Sub Command0_Click() Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sSubject As...

I have had a look at my report and it's so simple that there are 22 lines of text of which 11-12 are going to be the merge element DoCmd.OutputTo acOutputReport, "Reportname", acFormatRTF, "S:\Test Data\xxxx\Policy\" & ReferenceNo & ".Doc", False so this will create a RTF file singular...

starting point for Email element attachement element would easy enough (I have pinched this from another posting ..) i presume "Dim Sattachment as string etc - link it to my exported word doc location say S drive Test s\\test\ s\\Test\12345.doc ( or from my query ) Dim MyDb...

Hi guys long time Bit of a weird one - and i cannot quite grasp it outline I need to create a word file (it needs to be word) based on template (not a very complicated template) max 1 to 1 and 1/2 pages long the word doc needs to be named from the recordset but for now assume...

this has had to take a back seat at the moment - while I resolve my "upgrade" are resovle its issue - I will return tot his if I get stuck G