Mail Merge without using Word

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

I want todo a mail merge using a excell template as the document tobe
sent out.
1 Excell spreadsheet contains the address and the other the template
letter, Is this possable.

Thanks
Garry
 
If you are talking about putting the address and salutation in the body of a letter that is easy enough to do with a looping macro

for each n in range("a2:a22")
line1=n
line2=n.offset(,1)
line3=n.offset(,2)
line5="Dear "& & n
activesheet.printout
next n
Click to expand...


Thanks for the answer, I dont think I have explained this correctly.

I have template (1) spreadsheet which has the below as Headings.

NAme Description Price Serial Number


There is also a field where i can sign and date and a few other
things.




On another (2) spreadsheet I have the same headings with the details
of items below, So Like this.

NAme Description Price Serial Number

Pin Pointed thing 1.7 02345
Pin Pointed thing 1.9 02349

etc etc etc etc.


Get the idea.

So by mergeing (2) into (1) I should have multiple templates filled in
that I can print.

Thanks
 
Thanks for the answer, I dont think I have explained this correctly.

I have template (1) spreadsheet which has the below as Headings.

NAme Description Price Serial Number

There is also a field where i can sign and date and a few other
things.

On another (2) spreadsheet I have the same headings with the details
of items below, So Like this.

NAme    Description     Price   Serial Number

Pin     Pointed thing   1.7     02345
Pin     Pointed thing   1.9     02349

etc     etc             etc     etc.

Get the idea.

So by mergeing (2) into (1) I should have multiple templates filled in
that I can print.

Thanks- Hide quoted text -

- Show quoted text -
Click to expand...

Bump..
 
I want todo a mail merge using a excell template as the document tobe
sent out.
1 Excell spreadsheet contains the address and the other the template
letter, Is this possable.

Thanks
Garry
Click to expand...

Send file and complete explanation dguillett1 @gmail.com
 
Back
Top