fetch data from excel and paste in .OFT file and send mailsss

Hi,

I have a .OFT file. i have my template typed and saved it as outlook file template.

I need a Excel VBA macro to generate email of this template (This i can achieve through ron de bruin excel automation and other stuffs in internet)
but the difficulty i found is that the macro must pick data from an excel file and paste it in the .OFT file (fields) like

Date from excel and paste it in date field in .OFT
Amount from excel and paste it in Amount field in .OFT

..etc...

and send mail.

Same vice macro need to create mails with the same .oft file and fetch data one by one in excel and generate mail( .display) then i will review it and send it.

Each row in excel is a email....



Can this be achieved.... am limited to resources, hence i didn't attahed .OFT file here with. but attached sample excel file with data needs to be fetched and keep in mail template and mail ID's for To and Cc fields.


Thanks for your time and consideration.

Hi All,

With ron de bruin codes... i tried below code to accomplish my task...ofcourse i know am doing errors in using multiple For Each Loops.
Am keeping on getting lot of compile errors..... Can anyone please help me in this....

Please Login or Register  to view this content.

i separated your two codes as well...i didnt quite understand what you were doing

so i hope i separated it correctly

assumed you wanted to check to make sure c was [email protected] format
B and A were not formulas

i created a pretty lame OFT file to check it worked and it did....remember it is case sensitive

Hi Hum,

Awesome job done.... thank you very much...

i added some more data fields and tried by modifying code and it works.

I want to go a step further, the OFT file i created has company logo in it... so i want the outlook to generate it with thw image and pull the data from excel and generate mail. but the macro creating mails with out the image...why is that?

I also tried saving my template in .rtf rich text format, now the image is showing in the generated mail but below the signature of the mail, but not in where i placed it....

Do you have any idea on achieving the macro with image embeded .OFT file.... please help....

i have attached the excel, but npt able to attach .OFT file...

i also pasted below the modified macro codes for pulling more data fields, please correct me if any mistake i have done while manupulating....

Thanks...

Please Login or Register  to view this content.

did some research
oft/template does not readily lend itself to having images

have you thought about using the HTML method instead?
http://vba-useful.blogspot.com.au/20...ed-images.html

Hi Hum,...

Thanks a ton... i appreciate your kindness and helping manner....

I had gone through the link and it helped me in adding the image in VBA mail macro. but am not able to intersect both the above macro you gave and the image link codes... I tried, it was working but if image comes, data fields are not replaced and if data field are replaced, image s not show up.

Sorry for adding more requirements in this thread.... Can i solve this thread ( My actual initial requirement was fulfilled) and post my further requirement as a new thread.... or can i continue here....

if so i will provide the sample i hav tried.... Thansk again...

please provide sample of where your up to

the thing you need to change in html is the syntax

humdingaling,

I worked it and found the mistakes i done.... Finally i got the macro working perfectly. Thanks a lot....

I Will come back to you... If i need anymore suggestions or advise in macro.

Now solving the post.

well done
always good to work it out yourself so you amend it in the future if you require

you know where to find me
Cheers
hum