Merge Email discussion

[v4let20]

Hello guys,

Well i will start with a short story of what i'm doing.
I tryin to pull out a way to change the "email sender" (from) while tryin to merge mail for massive send.
I beein searching around, but i couldn't find much, most threads tell me to go to control panel and change some settings here and there ( that actually works) but i want to make it automated or less boring.



I think i might have found the solution, plz if i'm wrong point me. Cuz i'm quite new to this ( i been working for almost 2months with access+vba ) but outlook and word its my first time.

Anyway the way i did it, in the "E-mail" tab my main email acc is default and at the "Data File" <- i think its the trick part, the email i want to send the massive emails like "from: info[at]xxxx[at].pt

- no img xD
- no img xD
(still need more post )
I was on this mad search to find if it was possible to create a macro to change the Data file or do a .bat file donno rly , but still no luck...maybe should do more reading. :banghead:

P.s Sorry for my bad writing and some grammar errors.
English is my 3th language.

 

[Ranman256]

For the SEND list, do you mean take a list of persons and send bulk email to them?
If so, then either , have a table with groups, ie, Finance Dept, or Maintenance Dept, and all emails listed with this dept. Then one would pick the dept, and send.

or
user picks from a list of people, THAT list gets the emails.
?

 

[v4let20]

For the SEND list, do you mean take a list of persons and send bulk email to them?
If so, then either , have a table with groups, ie, Finance Dept, or Maintenance Dept, and all emails listed with this dept. Then one would pick the dept, and send.

or
user picks from a list of people, THAT list gets the emails.
?

The massive email list is set, while merging instead of sending them with my main acc.
I want to send them with my other acc.
(Search in google : merge email word+excel ) i will get and idea of what im tryin to do here.

Too bad i cant post no pics or links yet...need to step my post game xD

 

[Ranman256]

whatever db you use, you must build a query to pull the data, and emails.
then you can run the merge, and tell the merge wizard to use the email field to 'send'.

 

[v4let20]

whatever db you use, you must build a query to pull the data, and emails.
then you can run the merge, and tell the merge wizard to use the email field to 'send'.

I think you are not understanding my issue here.
I know all that and i've done all that, if you test the merge wizard it wont allow you the change the sender name.
Like instead of sending from blahblah[at]companyname[at].pt, i want to send from info[at]companyname[at].pt.

The search has been mad, but the failure has been outrageous xD :banghead:

 

[GaryPanic]

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 much whatever you want - Say Donald Duck


but the trail will also say its from Mickey Mouse -- otherwise you could be into a situation where i could send hate mail to someone and its trail could be pointed towards someone else ..

 

[Gasman]

I had this problem, just a week or so ago.

If using Office 2003, it is very hard. later versions allow you to do it with the Outlook object and SenderName.

I got around my problem by creating a template in outlook that used the account I wished to use and then created the mail using CreateItemFromTemplate.

However in outlook 2003 you can still use SendOnBehalfOfName, so any reply would go back to that account, however I needed it to use the account on send.